Oracle OUTLN_EDIT_PKG
Version 12.2.0.1

General Information
Library Note Morgan's Library Page Header
Coming to OpenWorld 2018? Be sure to visit the TidalScale booth in Moscone South and learn how to solve performance problems and lower costs with Software Defined Servers. Before you visit the booth, or if you can't make it this year, check out TidalScale at www.tidalscale.com. Be sure to click on the Solutions link and look through the Oracle resources.
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
This package is not available, even in script form, in 18c and will be dropped from the 19c Library.
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
Built-in Functions
Built-in Packages
DBMS_SPM
Outlines
OUTLN_PKG
Tuning
What's New In 12cR2
What's New In 18cR3

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