HIRE ORACLE DBA IN ABU DHABI
ORACLE DBA JOBS DUBAI
Tuesday, June 3, 2014
column_defaults script in oracle 10g
SET LINESIZE 100
SET VERIFY OFF
SELECT a.column_name "Column",
a.data_default "Default"
FROM all_tab_columns a
WHERE a.table_name = Upper('&1')
AND a.data_default IS NOT NULL
/
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment