Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle files - Which file extension is proper SQL or PLS and when?

Blue BirdJul 16 2018 — edited Jul 19 2018

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

This post has been answered by BluShadow on Jul 16 2018
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 16 2018
Added on Jul 16 2018
19 comments
15,205 views