Read or Download Oracle - Introduction to Oracle9i - PL-SQL - Stude PDF
Best databases books
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
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.