Friday, May 5, 2017

user_tab_column



HR/HR@ORCL

select distinct('select DBMS_METADATA.GET_DDL(''TABLE'',''' ||table_name|| ''') from DUAL;') a
from user_tab_columns where data_type in ('CLOB','BLOB','RAW','NCLOB')
order by a;

select DBMS_METADATA.GET_DDL('TABLE','IMAGE_01') from DUAL;


By at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

How to install and configure Oracle Apex 24.1 with ORDS 22, Tomcat 9 and Jasper Report 7 on Oracle Linux 8.10

#########################Install Oracle  APEX 24.1################################ ----------------------------------------------------...