Oracle OUTLN_EDIT_PKG
Version 12.2.0.1

General Information
Library Note Morgan's Library Page Header
"I spent my entire adult life looking out for the well-being, the training, the equipping of the troops for whom I was responsible. I will not be lectured about what our military needs by a five-deferment draft dodger,"
~ Sen. Tammy Duckworth
Purpose Contains functional interface for procedures and functions associated with management of private outlines

Deprecation Notice: Outlines are deprecated as of 12cR1: Instead use baselines
AUTHID CURRENT_USER
Dependencies
DBMS_ASSERT DBMS_OUTLN_LIB DBMS_STANDARD
DBMS_OUTLN_EDIT    
Documented No
First Available 9.0.1
Security Model Owned by SYS with EXECUTE granted to PUBLIC and to the DBA and EXECUTE_CATALOG_ROLE roles
Source {ORACLE_HOME}/rdbms/admin/dbmsol.sql
Synonym DBMS_OUTLN_EDIT
Subprograms
 
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');

Related Topics
DBMS_SPM
Outlines
OUTLN_PKG
Packages
Tuning
What's New In 12cR1
What's New In 12cR2

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2017 Daniel A. Morgan All Rights Reserved