(Shahid Hafeez) This script will get the number of rows per table in the current schema. (script)

(Amar Kumar Padhi) We have various levels of security (inside and outside of Oracle database) that can be implemented according to one’s requirements. Mentioned here is a way of implementing security against structural changes or Data Definition Language (DDL) changes. This security is put within th

(Robert Westervelt) With the Unix and Linux versions of the Oracle 10g database now available, and the Windows version due out in several weeks, database administrators are clamoring to get their hands on its automated features and new manageability options. (R)

(Gautam Arora) Use this simple SQL script–lay.sql–to generate the layout for the spooled file. Run the script before spooling the table to get the layout. (script)

SQL*Loader is the primary method for quickly populating Oracle tables with data from external files. It has a powerful data parsing engine that puts little limitation on the format of the data in the datafile. SQL*Loader is invoked when you specify the sqlldr command or use the Enterprise Manager in

(Ajay Gursahani) This article gives a brief understanding about External tables. External Tables are defined as tables that do not reside in the database, and can be in any format for which an access driver is provided. This external table definition can be thought of as a view that allows running a

(Renee Boucher Ferguson) Citing advice from Goldman, Sachs and Co. and Citigroup Global Markets Inc., PeopleSoft Inc.’s board of directors urged shareholders this morning to reject Oracle Corp.’s latest tender offer.

(Olivier Le Diouris) Unit testing gained popularity with the adoption of eXtreme Programming (XP). JUnit introduced the possibility to run unit tests in Java. Several other components running on top of JUnit can be used to run unit tests concerning some specific technologies, like XML and HTTP. This

(James Koopmann) Have you ever wondered about storing documents into your Oracle database and just didn’t know where to start? Here is a quick introduction to the basics you need to know.

This document explains how to call Reports that have a parameter form from Forms Services using the Forms RUN_REPORT_OBJECT Built-in. The solution described in this document works with the Forms and Reports components of Oracle Application Server releases 9.0.2.x and 10J. All PL/ SQL and Java cod