Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Oracle PL/SQL code conventions [closed]

I am curious, is there any offcial code guidlines or conventions for code formatting in Oracle PL/SQL?

like image 342
Skeeve Avatar asked Jul 15 '13 13:07

Skeeve


People also ask

Is PL SQL outdated?

The answer is that PL/SQL is not growing, but not going away either. Because it is used in the Oracle database, and the Oracle database is a fixture of enterprise systems world-wide, it will outlive you. High-performance batch processing has to happen close to the data, so PL/SQL will continue to rule in this area.

What are the 3 types of PL SQL statements?

PL/SQL has three categories of control statements: conditional selection statements, loop statements and sequential control statements.

Which of the following is not true about the PL SQL functions?

Q 19 - Which of the following is not true about the PL/SQL functions? A - A PL/SQL function is same as a procedure except that it returns a value.


1 Answers

No, there are no official guidelines or conventions.

Anything "official" would be in the documentation. Other then a few random hints, I've never seen anything like this in any of the books. Obviously I haven't read them all, but I also couldn't find anything in the Master Index. Oracle SQL Developer has a beautifier, but I've never seen anything to imply it's the official way to format code.

like image 53
Jon Heller Avatar answered Oct 20 '22 17:10

Jon Heller