| General Information |
| Subprograms |
|
| Source |
{ORACLE_HOME}/rdbms/admin/prvtsql2.plb |
| First Available |
11.2.0.3 |
| Dependencies |
|
| Security Model |
Execute is granted to PUBLIC |
| |
| EXPAND_SQL_TEXT |
| Undocumented but fascinating |
dbms_sql2.expand_sql_text(
input_sql_text IN CLOB,
output_sql_text OUT CLOB); |
set serveroutput on
DECLARE
iclob CLOB := 'SELECT srvr_id FROM servers s WHERE EXISTS (SELECT srvr_id FROM serv_inst i WHERE s.srvr_id = i.srvr_id)';
oclob CLOB;
BEGIN
dbms_sql2.expand_sql_text(iclob, oclob);
dbms_output.put_line('Input: ' || iclob);
dbms_output.put_line('Output: ' || oclob);
END;
/
--Note the transformation of the subquery. |
| |
| PARSE |
Undocumented
Overload 1 |
dbms_sql2.parse(
c IN NUMBER,
statement IN VARCHAR2,
language_flag IN NUMBER,
edition IN VARCHAR2,
apply_crossedition_trigger IN VARCHAR2,
fire_apply_trigger IN BOOLEAN,
schema IN VARCHAR2); |
| TBD |
| Overload 2 |
dbms_sql2.parse(
c IN NUMBER,
statement IN CLOB,
language_flag IN NUMBER,
edition IN VARCHAR2,
apply_crossedition_trigger IN VARCHAR2,
fire_apply_trigger IN BOOLEAN,
schema IN VARCHAR2); |
| TBD |
| Overload 3 |
dbms_sql2.parse(
c IN NUMBER,
statement IN dbms_sql.varchar2a,
lb IN NUMBER,
ub IN NUMBER,
lfflg IN BOOLEAN,
language_flag IN NUMBER,
edition IN VARCHAR2,
apply_crossedition_trigger IN VARCHAR2,
fire_apply_trigger IN BOOLEAN,
schema IN VARCHAR2); |
| TBD |
| Overload 4 |
dbms_sql2.parse(
c IN NUMBER,
statement IN dbms_sql.varchar2s,
lb IN NUMBER,
ub IN NUMBER,
lfflg IN BOOLEAN,
language_flag IN NUMBER,
edition IN VARCHAR2,
apply_crossedition_trigger IN VARCHAR2,
fire_apply_trigger IN BOOLEAN,
schema IN VARCHAR2); |
| TBD |
|