Oracle PL/SQL Built-ins Pocket Reference by John Beresniewicz, Chip Dawes, Steven Feuerstein

By John Beresniewicz, Chip Dawes, Steven Feuerstein

This pocket reference offers quick-reference details to help you use Oracle Corporation's large set of integrated services and programs, together with these new to Oracle8.Oracle's PL/SQL language is a programming language delivering procedural extensions to the SQL relational database language and to an ever-growing variety of Oracle improvement instruments. one of the most valuable constructs within the PL/SQL language are the integrated features and packages.Built-in features are constructs that function on specific sorts of knowledge (e.g., numeric, personality) to come a outcome. by utilizing capabilities, you could reduce the coding you want to do on your courses. capabilities are defined intimately in Steven Feuerstein's Oracle PL/SQL Programming; this entire consultant to development purposes with PL/SQL has turn into the bible for PL/SQL builders who've raved approximately its completeness, clarity, and practicality.

Show description

Read Online or Download Oracle PL/SQL Built-ins Pocket Reference PDF

Similar oracle books

Oracle PL/SQL Programming 4Th Edition

За последние 10 лет книга Oracle PL/SQL Programming издательства O'Reilly's стала бестселлером среди книг по PL/SQL, процедурному языку базы данных Oracle. Снабженная примерами и полезными рекомендациями книнга является незаменимой как новичкам, так и гуру, как разработчикам на Oracle kinds, так и администраторам - используйте PL/SQL на полную мощь.

Oracle Streams 11g Data Replication

Grasp Oracle Streams 11g Replication permit real-time info entry and knowledge sharing throughout your dispensed framework utilizing the specialist info during this Oracle Press consultant. Oracle Streams 11g information Replication explains easy methods to manage and administer a unified company info sharing infrastructure.

Oracle Application Express 4 Recipes

Oracle program convey four Recipes offers an example-based method of studying software convey - the ground-breaking, speedy program improvement platform integrated with each Oracle Database license. The recipes layout is perfect for the quick-study who simply wishes a very good instance or to kick commence their pondering and get pointed within the correct path.

Additional info for Oracle PL/SQL Built-ins Pocket Reference

Example text

READ_EV (iev BINARY_INTEGER ,oev OUT BINARY_INTEGER); Returns the current session's event level setting for trace event number iev into variable oev. SET_EV (si BINARY_INTEGER ,se BINARY_INTEGER ,ev BINARY_INTEGER ,le BINARY_INTEGER ,nm IN VARCHAR2); Sets the level for event number ev in the session identified by sid si and serial number se to the value specified by le. Variable nm is used to specify the event name. 18 DBMS_STANDARD 27 [Chapter 1] Oracle PL/SQL Built−ins Pocket Reference (sid IN NUMBER ,serial# IN NUMBER ,sql_trace IN BOOLEAN); Turns SQL tracing on or off in the session identified by sid (sid) and serial number (serial#) according to the value of sql_trace (TRUE = on; FALSE = off).

FUNCTION LPAD (str1 IN VARCHAR2 CHARACTER SET ANY_CS ,len BINARY_INTEGER [,pad IN VARCHAR2 CHARACTER SET str1%CHARSET]) RETURN VARCHAR2; Returns str1 padded on the left to a length of len with pad character pad. FUNCTION LTRIM (str1 IN VARCHAR2 CHARACTER SET ANY_CS := ` ` [,tset IN VARCHAR2 CHARACTER SET str1%CHARSET]) RETURN VARCHAR2; 39 [Chapter 1] Oracle PL/SQL Built−ins Pocket Reference Returns str1 stripped of any leading characters that appear in tset. FUNCTION REPLACE (srcstr IN VARCHAR2 CHARACTER SET ANY_CS ,oldsub IN VARCHAR2 CHARACTER SET srcstr%CHARSET ,newsub IN VARCHAR2 CHARACTER SET srcstr%CHARSET:= NULL) RETURN VARCHAR2; Returns scrstr with all occurrences of oldsub replaced with newsub.

The name of the table does not have to be known. 4 only. DELETE_OBJECT (reference IN REF ANY); Deletes the object (actually the row containing the object) identified by reference. LOCK_OBJECT (reference IN REF ANY); Locks the object referenced by reference. 24 UTL_REF 36 [Chapter 1] Oracle PL/SQL Built−ins Pocket Reference Locks the object referenced by reference and retrieves the object into object. Similar to a SELECT FOR UPDATE statement. SELECT_OBJECT (reference IN REF ANY ,object IN OUT ANY); Retrieves the object referenced by reference into object.

Download PDF sample

Rated 4.45 of 5 – based on 20 votes