Category Archives: Oracle table

Print Oracle Table Definitions

HOSTNAME::ORACLE $ cat dd_step4b.sql rem Filename : dd_step4b.sql rem Note     : This Version is for IFMS and prints only the rem          : ‘Data’ Tables, which begin with FMS_TD_ rem SELECT name FROM V$DATABASE; SHOW USER; spool dd_step4b.op select TO_CHAR(SysDate,’DD/Mon/YYYY HH:MI … Continue reading

Posted in Definitions, Oracle table | Leave a comment

Create a Primary key column on a table

———————————————————————– — Filename:   DBA_add_PK.sql — Purpose:    Create a Primary key column on a table were this is not —             yet available — Notes:      This script will create a new script that extends your —             tables with a extra column to … Continue reading

Posted in Oracle table, Primary Key | Leave a comment