SQL Oracle PHP Java JSP JDBC MORE

SQL Comments


Comments are used to explain the SQL query and stop executing the part of query which is commented.

Single Line Comments

Single line comments start with --.

This comment cannot affect to the next line.

Example:

--Select all: SELECT * FROM Employee;

Multiline Comment

Multi-line comments are like PHP.

It starts with /* and end with */.

The text between this two /* and */ are skipped or ignored.

Example:

/*SELECT * FROM 
Employee*/
Where id=1;