Топ-100
 

CREATE OUTLINE

Описания команд доступны в программе CerebroSQL

RDBMS Type: Oracle
Topic

CREATE [ OR REPLACE ]
[ PUBLIC | PRIVATE ] OUTLINE [ outline ]
[ FROM [ PUBLIC | PRIVATE ] source_outline ]
[ FOR CATEGORY category ]
[ ON statement ] ;

Example

CREATE OUTLINE salaries FOR CATEGORY special
ON SELECT last_name, salary FROM employees;

CREATE OR REPLACE PRIVATE OUTLINE my_salaries
FROM salaries;

CREATE OR REPLACE OUTLINE public_salaries
FROM PRIVATE my_salaries;