I am curious, is there any offcial code guidlines or conventions for code formatting in Oracle PL/SQL?
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.
PL/SQL has three categories of control statements: conditional selection statements, loop statements and sequential control statements.
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.
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.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With