Query per estrarre la DDL degli oggetti ORACLE

Estrazione DDL TABLE: set heading off; set echo off; Set pages 999; set long 90000; select dbms_metadata.get_ddl(‘TABLE’,’&TABLE_NAME’,’&user’) from dual; Estrazione DDL INDEX: set heading off; set echo off; Set pages 999; set long 90000; select dbms_metadata.get_ddl(‘INDEX’,’&INDEX_NAME’,’&OWNER’) from dual; Estrazione DDL VIEW: set heading off; set echo off; Set pages 999; set long 90000; select dbms_metadata.get_ddl(‘VIEW’,’&VIEW_NAME’,’&OWNER’) … Leggi tuttoQuery per estrarre la DDL degli oggetti ORACLE

Wordpress Social Share Plugin powered by Ultimatelysocial
Facebook
Facebook
Twitter
YouTube
LinkedIn