Hi,
I have maybe a little bit newbie question about file extensions in Oracle environment when you save files. Which file extension do you use for following files (or other not mention too):
- Functions (pls)
- Procedures (pls)
- Package Specification (pks)
- Package Body (pkb)
- Trigger (trg)
- SQL Scripts separated by / (creating/dropping tables, relations, etc) (sql)
Do you use PLS or SQL? Which extension should I use for above file types? In parenthesis I found some extensions. When you for example save above files (with File > Save As) in SQL Developer you won't always get "correct" extension. Can you write some your opinions and good practice about that topic? I was looking for some official document about that, but I can't find it. Is the general rule what contain PL/SQL (Declare...Begin...End) should be PLS and the rest SQL or no?
Is maybe where available some official extension list for all different objects you can save in Oracle and you use/follow?
BB