By Dilbagh Singh – Users sometimes submit queries through an application multiple times, especially in environments where they are not in a position to maintain/manage the queries they submit. This takes up resources (i.e., temp space, CPU, IO, etc) and causes performance degradation for all users.

Learn how to schedule the periodic execution of user jobs using job queues in Oracle 9i. Also covered are topics on viewing job queue information and managing job queues.

By Harish Kapgate – DUAL is a table automatically created by Oracle along with the data dictionary. It is in the schema of the user SYS, but is accessible by the name DUAL to all users. It has one column, DUMMY, defined to be VARCHAR2(1), and contains one row with a value ‘X’. Selecting from the DUA

This book covers critical relational, object-relational, and Web database concepts, as well as SQL, SQL*PLUS, PL/SQL, Java, JDBC, SQLJ, and XML programming. You’ll also get full details on database administration techniquesand much more. Read all of Chapter 21: “Using SQL*Loader to Load Data.”

By Keshav Chennakeshav – In many data manipulation and querying scenarios, you may need to trim a string. To do this in Oracle, LTRIM and RTRIM are available. Here is a utility function that combines the two. Note: this function is a standard feature of Oracle 8i and higher. So it will be of use for

by Jayant Kulkarni – Displaying session information is a regular task for a DBA. DBAs have been using information from v$session and v$process to find out relevant information about a process in order to kill a session, such as finding the UNIX id associated with the process, identifying more detail

By Martin LaMonica – In a move that has exposed a growing schism in the Java community, an Oracle proposal to bridge Java development tools moved ahead with approval from competing Java companies.

By Ellen O’Brien and Tim DiChiara – Web services, rising in popularity quicker than you can say SOAP, topped the list of future technology priorities for SearchDatabase.com Oracle Report Card respondents.The exclusive survey of 500 Oracle professionals asked them to rate emerging technologie

By Ed Schalk – This tip is designed to increase the security of imports/exports during batch processing of backups. It avoids the security problem of putting passwords in script files for privileged users (such as system). This tip has been tested on Oracle 7.3.3, 8.0.5 and 8.1.6.

By John Taschek – Oracle launched a vicious attack on Microsoft’s Exchange at the recent OpenWorld conference. But Exchange is both too easy and too slippery a target: No matter how many viruses, security alerts, maintenance issues or general complaints come in, Exchange is still the most popular en