Oracle PL/SQL Language Pocket Reference
Language: English
Pages: 190
ISBN: 1491920009
Format: PDF / Kindle (mobi) / ePub
Be more productive with the Oracle PL/SQL language. The fifth edition of this popular pocket reference puts the syntax of specific PL/SQL language elements right at your fingertips, including features added in Oracle Database 12c.
Whether you’re a developer or database administrator, when you need answers quickly, the Oracle PL/SQL Language Pocket Reference will save you hours of frustration with concise summaries of:
- Fundamental language elements, such as block structure, datatypes, and declarations
- Statements for program control, cursor management, and exception handling
- Records, procedures, functions, triggers, and packages
- Execution of PL/SQL functions in SQL
- Compilation options, object-oriented features, collections, and Java integration
This handy pocket reference is a perfect companion to Steven Feuerstein and Bill Pribyl’s bestselling Oracle PL/SQL Programming.
Starting out with Visual C# 2012 (3rd Edition)
Getting Started with Amazon Redshift
Linux Essentials (2nd Edition)
ref expression into a string containing its hexadecimal equivalent. ROWIDTOCHAR(rowid) Converts rowid to a VARCHAR2(18) string equivalent. ROWIDTONCHAR(rowid) Converts rowid to an NVARCHAR2(18) string equivalent. TABLE Maps a collection to a database table (inverse of MULTISET). TO_BINARY_FLOAT(expression [,fmt]) Converts number or string expression to a BINARY_FLOAT; optionally use format model fmt. TO_BINARY_DOUBLE(expression [,fmt]) Converts number or string expression to a
1) together with the NOT NULL variations NATURALN and POSITIVEN. SIGNTYPE is restricted to three values (−1, 0, 1). PLS_INTEGER is an unconstrained subtype (alias) of BINARY_INTEGER. SIMPLE_INTEGER has the same range as BINARY_INTEGER except that it does not allow for null values and does not raise an exception if an overflow occurs. For example, 2147483647 + 1 = −2147483648 (note the negative value!). SIMPLE_INTEGER datatypes can result in significantly faster execution speeds when the PL/SQL
RESULT constructor_function_spec Attribute specifications must appear before method specifications. Object attributes, like table columns, are defined with a name and a datatype. The name can be any legal identifier, and the datatype can be almost any datatype known to SQL other than LONG, LONG RAW, ROWID, and UROWID. Attributes can be declared using other programmer-defined object types or collection types, but not of the special types ANYTYPE, ANYDATA, or ANYDATASET. Attributes cannot be of
standard WE8MSWIN1252 or WE8ISO8859P2 character set does not support some languages, such as Chinese and Greek. To support multiple languages, the database allows two character sets—the database character set and a Unicode character set, sometimes called the national character set (NLS). The two NLS datatypes, NCHAR and NVARCHAR2, are used to represent data in the Unicode character set. NCHAR values are fixed-length character data; the maximum length is 32,767 bytes. NVARCHAR2 values are
Conversion functionsTO_MULTI_BYTE built-in function, Conversion functions, String functionsTO_NUMBER built-in function, Conversion functionsTO_RAW built-in function, Conversion functionsTO_SINGLE_BYTE built-in function, Conversion functions, String functionsTO_TIMESTAMP built-in function, Conversion functions, Date and time functionsTO_TIMESTAMP_TZ built-in function, Conversion functions, Date and time functionsTO_YMINTERVAL built-in function, Conversion functions, Date and time