Get Oracle - Introduction to Oracle9i - PL-SQL - Stude PDF

Read or Download Oracle - Introduction to Oracle9i - PL-SQL - Stude PDF

Best databases books

Read e-book online The New Relational Database Dictionary: Terms, Concepts, and PDF

It doesn't matter what DBMS you're using—Oracle, DB2, SQL Server, MySQL, PostgreSQL—misunderstandings can continually come up over the fitting meanings of phrases, misunderstandings which could have a significant impact at the luck of your database tasks. for instance, listed here are a few universal database phrases: characteristic, BCNF, consistency, denormalization, predicate, repeating workforce, subscribe to dependency.

Extra info for Oracle - Introduction to Oracle9i - PL-SQL - Stude

Sample text

Number having precision p and scale s. The precision p can range from 1 to 38. The scale s can range from -84 to 127. NUMBER [(precision, scale)] Introduction to Oracle9i: PL/SQL 1-18 Base Scalar Data types (continued) Data Type Description BINARY_INTEGER Base type for integers between -2,147,483,647 and 2,147,483,647. PLS_INTEGER Base type for signed integers between -2,147,483,647 and 2,147,483,647. PLS_INTEGER values require less storage and are faster than NUMBER and BINARY_INTEGER values. Base type that stores one of three possible values used for logical calculations: TRUE, FALSE, or NULL.

Introduction to Oracle9i: PL/SQL 1-28 Displaying Bind Variables To display the current value of bind variables in the iSQL*Plus environment, use the PRINT command. However, PRINT cannot be used inside a PL/SQL block because it is an iSQL*Plus command. The following example illustrates a PRINT command: VARIABLE g_n NUMBER ... PRINT g_n You can reference host variables in PL/SQL programs. These variables should be preceded by a colon.

When the block is executed successfully, without unhandled errors or compile errors, the message output should be as follows: • Section keywords DECLARE, BEGIN, and EXCEPTION are not followed by semicolons. • END and all other PL/SQL statements require a semicolon to terminate the statement. • You can string statements together on the same line, but this method is not recommended for clarity or editing. Note: In PL/SQL, an error is called an exception. With modularity you can break an application down into manageable, well-defined modules.

Download PDF sample

Rated 4.86 of 5 – based on 23 votes