(Bob Watkins) Executing Data Manipulation Language (DML) statements within a PL/SQL loop is time consuming because each time through the loop a switch is made from the PL/SQL engine to the SQL engine. A better approach is to use the FORALL statement, which passes the SQL statement only once along wi

(Rudy Limeback) I retrieve two columns named SuperVisor and totalcontracts using this query: select SuperVisor, count(ContractNo) as totalcontracts from Contract group by SuperVisor Now I want to get the maximum of totalcontracts from the retrieved data using a select statement. (R)

(Christian Shay) Lots of you are using ASP.NET and the Oracle Data Provider for .NET to create web applications that access Oracle. When those applications call a PL/SQL stored procedure, wouldn’t it be great to just step right into the PL/SQL and begin debugging with the live parameter values still

This is a collection of 27 FAQs on Oracle loading data and exporting data. Clear answers are provided with tutorial exercises on saving data as flat files, loading data from flat, exporting and importing database, schema and tables, creating external tables.

(Rudy Limeback) I have a database with several tables that use a composite primary key of ID, start date, end date. If I am changing any description on a particular table, I will update the start date and end date, then I will insert the new row. This is because of keeping a history. Is there any pr

(Paula Rooney) Oracle’s Unbreakable Linux 2.0 likely won’t fragment the Linux distribution business out of the gate, but the long-term impact on Red Hat, Novell and the operating system market remains unclear, industry observers say.

(Lucas Jellema) I just came out of – well actually, as I am writing this down I am still in it – a very good session on the Oracle JDBC drivers by Douglas Surber, principal developer for Oracle JDBC Drivers. In a very powerful delivery, Douglas discussed the ten worst practices – and their proper co

(Bob Watkins) One of the best features of Oracle 10g is its Advisory Framework, which is a collection of tuning advisors that help you get the most out of your database. One of these advisors, the SQL Access Advisor, can recommend changes in your schema’s indexing or materialized views to improve pe

(Rich Seeley) Mashups are the killer apps for SOA, according to keynote speakers at Oracle OpenWorld conference. (R)

(Mark Brunelli) Larry Ellison is going after Red Hat Inc. support customers in a big way. (R)