General |
Note: Contains functional interface for procedures and functions associated with management of private outlines |
Source |
{ORACLE_HOME}/rdbms/admin/dbmsol.sql |
First Available |
9.0.1 |
Dependencies |
DBMS_ASSERT |
DBMS_OUTLN_EDIT |
DBMS_OUTLN_LIB |
DBMS_SQLTCB_INTERNAL |
|
Security Model |
Execute is granted to DBA, OUTLN and
EXECUTE_CATALOG_ROLE roles |
Synonym |
DBMS_OUTLN_EDIT |
|
CHANGE_JOIN_POS |
Change the join position for the hint identified by outline name and hint number to the position specified by newpos |
outln_edit_pkg.change_join_pos(
name IN VARCHAR2,
hintno IN NUMBER,
newpos IN NUMBER); |
TBD |
|
CREATE_EDIT_TABLES |
Create outline editing tables in calling user's schema |
outln_edit_pkg.create_edit_tables; |
exec outln_edit_pkg.create_edit_tables; |
|
DROP_EDIT_TABLES |
Drop outline editing tables in calling user's schema |
outln_edit_pkg.drop_edit_tables; |
exec outln_edit_pkg.drop_edit_tables; |
|
GENERATE_SIGNATURE |
Generates a signature for the specified SQL text |
outln_edit_pkg.generate_signature(
sqltxt IN VARCHAR2,
signature OUT RAW); |
set serveroutput on
DECLARE
x RAW(32767);
BEGIN
outln_edit_pkg.generate_signature('SELECT user FROM
dual', x);
dbms_output.put_line(x);
END;
/ |
|
REFRESH_PRIVATE_OUTLINE |
Refresh the in-memory copy of the outline, synchronizing its data with the edits made to the outline
hints |
outln_edit_pkg.refresh_private_outline(name
IN VARCHAR2); |
exec outln_edit_pkg.refresh_private_outline('OL_DEMO'); |