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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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
12,839 views