Read or Download Oracle - Introduction to Oracle9i - PL-SQL - Stude PDF
Similar databases books
This booklet brings all the components 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 masking the gamut of database layout technique ? from ER and UML concepts, to conceptual information modeling and desk transformation, to storing XML and querying relocating items databases.
Oracle Call Interface. Programmer's Guide
The Oracle name Interface (OCI) is an software programming interface (API) that permits purposes written in С or C++ to have interaction with a number of Oracle database servers. OCI supplies your courses the aptitude to accomplish the whole diversity 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 educational covers Oracle Warehouse Builder from the floor up, and faucets into the author's vast adventure as a software program and database engineer. Written in a calm variety with step by step motives, plenty of screenshots are supplied in the course of the publication. there are various advice and beneficial tricks all through that aren't present in the unique documentation.
Additional resources for Oracle - Introduction to Oracle9i - PL-SQL - Stude
Example text
All rights reserved. Composite Data Types A scalar type has no internal components. A composite type has internal components that can be manipulated individually. Composite data types (also known as collections) are of TABLE, RECORD, NESTED TABLE, and VARRAY types. Use the RECORD data type to treat related but dissimilar data as a logical unit. Use the TABLE data type to reference and manipulate collections of data as a whole object. Both RECORD and TABLE data types are covered in detail in a subsequent lesson.
LOBs also support random access to data. • The CLOB (character large object) data type is used to store large blocks of single-byte character data in the database in line (inside the row) or out of line (outside the row). • The BLOB (binary large object) data type is used to store large binary objects in the database in line (inside the row) or out of line (outside the row). • The BFILE (binary file) data type is used to store large binary objects in operating system files outside the database.
You must declare a variable before referencing it in other statements, including other declarative statements. Assign New Values to Variables in the Executable Section In the executable section, the existing value of the variable is replaced with the new value that is assigned to the variable. Pass Values Into PL/SQL Subprograms Through Parameters There are three parameter modes, IN (the default), OUT, and IN OUT. Use the IN parameter to pass values to the subprogram being called. Use the OUT parameter to return values to the caller of a subprogram.