Powered By Blogger

Saturday 2 June 2012

Query for getting Create Script.

1)))))This query give the create script of table/view/synonyms/sequences.

>>>>>SELECT DBMS_METADATA.GET_DDL('TABLE','TABLE_NAME') FROM DUAL;

if you wants VIEW then use ('VIEW','VIEW_NAME') like that you can use for all objects

2)))For separate the particular column SUPPOSE your column name is  WORD

WORD
------------
ABC
EFG
XYZ
PQR


IN THIS FORMAT

'ABC','EFG','XYZ','PQR'


>>> SELECT WM_CONCAT(''''||WORD||'''') FROM TABLE_NAME;