Tuesday, July 25, 2006

Suggestions for standard file extensions in SQL, PL/SQL

Contents of file Extension
---------------- -------------
Package specification .pks
Package body .pkb
Package sepc and body .pkg
Procdueure .pro (or .sp for stored procedure)
Function .fun (or .sf for stored function)
Create table script(s) .tab or .ddl
Synonym creation statements .syn
Index definition .ind
Constraint definitions .con
Test scripts .tst

No comments: