By Feuerstein S., Dye Ch., Beresniewicz J.
A whole connection with all the built-ins, together with the hot applications on hand with Oracle8, this ebook offers vast examples and is derived with a disk containing a web instrument constructed by means of RevealNet, Inc., that gives point-and-click entry to the various documents of resource code and on-line documentation built by means of the authors.
Read Online or Download Oracle Built in Packages PDF
Similar databases books
This e-book brings all the parts of database layout jointly in one quantity, saving the reader the time and rate of creating a number of purchases. It consolidates either introductory and complicated themes, thereby protecting the gamut of database layout technique ? from ER and UML strategies, to conceptual information modeling and desk transformation, to storing XML and querying relocating gadgets databases.
Oracle Call Interface. Programmer's Guide
The Oracle name Interface (OCI) is an program programming interface (API) that permits functions written in С or C++ to have interaction with a number of Oracle database servers. OCI supplies your courses the aptitude to accomplish the entire variety of database operations which are attainable with an Oracle database server, together with SQL assertion processing and item manipulation.
Oracle Warehouse Builder 11g: Getting Started
This easy-to-understand instructional covers Oracle Warehouse Builder from the floor up, and faucets into the author's vast event as a software program and database engineer. Written in a calm kind with step by step causes, plenty of screenshots are supplied through the e-book. there are various assistance and worthy tricks all through that aren't present in the unique documentation.
Additional info for Oracle Built in Packages
Example text
If the statement is a DDL statement, then the parse also executes the statement. No VARIABLE_VALUE Gets a value of a variable in a cursor. 2. Familiarity with these methods and the kinds of code you need to write for each will help you use DBMS_SQL most effectively. 4 Types of Dynamic SQL 47 [Appendix A] What's on the Companion Disk? 2: Types of Dynamic SQL Type Description DBMS_SQL Programs Used Method 1 No queries; just DDL statements and UPDATEs, INSERTs, or DELETEs, which have no bind variables.
Sql Simplifies use of this difficult procedure. SET_SESSION_ LONGOPS DBMS_UTILITY. spp Makes it easier to obtain specific initialization values from the database instance. DESCRIBE_COLUMNS so you don't need to declare PL /SQL tables and call that wordy built−in procedure to obtain the column information. spp Hides the need to provide a DBMS_SQL database mode when you parse a SQL statement. This technique is especially useful when you are writing code in Oracle Developer/2000 Release 1. spp GET_PARAMETER_ VALUE DBMS_UTILITY.
3, you will find the source code files in /this directory/: $ORACLE_HOME/rdbms73/admin If you are working in Windows NT, these files are located in, C:\OraNT\RdbmsNN\admin where C is the drive on which Oracle was installed. You can probably deduce the pattern at this point for other operating systems. If you are working in a UNIX environment that conforms to the OFA (Optimal Flexible Architecture) configuration standards, the catalog scripts will be found under, $ORACLE_HOME/rdbms/admin 38 [Appendix A] What's on the Companion Disk?