(Milind Deobhankar) Auditing the database to find out who is logged on, who has logged off, from which machines users are logged in, and from which program users are connected can be a very cumbersome task. Here is a procedure that will help the DBA to trace who has logged on, logged off, and at wh

by Sanjay Mishra – Among several new features, Oracle9i has introduced the ANSI standard join syntax. The new join syntax is not only SQL92 compliant, but it is elegant and makes the outer join syntax more intuitive. The biggest advantage of the new join syntax is its support for full outer joins, w

By Boris Milrud – Use Oracle’s package structure as a holder for session-persistent data in combination with the new Oracle 8i BULK COLLECT feature and LIMIT keyword.

By Michael Miley – United Airlines, Raytheon, and Gulf Insurance Company are just a few of the companies enjoying streamlined operations, greater security, and better performance after migrating to Oracle from a variety of database systems. Here’s how they did it—and how and why your company can do

By MARC L. SONGINI – As Oracle Corp. prepares to roll out a database upgrade that’s due for release next month, users and analysts last week said software pricing and support issues are affecting the company’s relations with some of its database customers.

By jai Tanwar – Reports sometimes need the time to be represented in MM:SS format but in the database table it often must be stored in seconds. To convert from one format to the other, use the following function. Use this function with SQL queries like this:

By Allen Bernard – It’s taken some time, but Larry Ellison’s vision of software being delivered as a service is coming to fruition — all Oracle products are now available in ASP-enabled versions.

Installation of Oracle 9i server on Redhat 7.2 is the same as on Redhat 7.1, except for some really strange behaviour I experienced when the Database configuration assistant (dbca) was invoked, both as part of installation and later when I tried to invoke it manually. This combination is not certifi

By John Edwards – Web services aren’t revolutionary, but their standards-based approach to integration and interoperability is something new. And some Oracle customers are already putting Web services to the test.

By Chris Lawson and Roger Schrag – In this paper, two experienced Oracle DBAs will introduce you to this exciting new feature. Since neither of us works for Oracle Corporation, we’d like to think this paper is balanced and objective. First we will introduce the DBMS_REDEFINITION package. Then we wil