What is the structure of PL/SQL and what are comments?
Posted by silpa on Dec 18 2006
PL/SQL is a block oriented language.
A block oriented language is based on a delimited block of code. In the case of PL/SQL, code is wrapped in a BEGIN..END construct. The most basic block of code in PL/SQL is:
BEGIN
END;
Comments in PL/SQL: Comments can begin in any column on any line. If you are embedding comments in SQL that will be embedded in PL/SQL you need to be careful (and I’ll show why in a future article) but just about any other use is ok. A rule I like to follow is to always leave at least one space between program code and program comments and never mix multi-line comments with code.
More here: http://blogs.ittoolbox.com/oracle/guide/archives/learn-plsql-structure-and-comments-10379
Leave a Comment