Rules For SQL

1. SQL must start with a verb. Example: SELECT statements
2. Every verb followed by clauses
3. Space is used to separates clauses
4. Comma(,) separates parameter without clause
5. ';' is used to end SQL statements
6. Statements may be split across lines but keywords may not
7. Identifiers, operator names, literals are separated by one or more spaces or other delimiters
8. Reserved words can't used as identifiers unless enclosed with double quotes("").
9. Identifiers must start with alphabetic characters and contain up to 30 characters.
10. Date and character literals must enclosed within single quotes.
11. Numeric literals can be represented by simple values.
12. 2 Type of Comments
• Enclosed between /* and */ symbols For multi line comments
• Prefixed with a -- symbols For Single line comments

Reserved Words as Below:

AS	BY	IN	IS	OF
ON	OR	TO	ADD	ALL
AND	ANY	ASC	NOT	RAW
ROW	SET	UID	CHAR	DATE
DESC	DROP	ELSE	FILE	INTO
LIKE	LOCK	LONG	MODE	NULL
ROWS	SIZE	THEN	USER	VIEW
WITH	ALTER	AUDIT	CHECK	FLOAT
GRANT	GROUP	INDEX	LEVEL	MINUS
ORDER	PRIOR	PUBLIC	ROWID	SHARE
START	TABLE	UNION	WHERE	ACCESS
COLUMNS	CREATE	DELETE	EXISTS	HAVING
INSERT	MODIFY	NOWAIT	NUMBER	ONLINE
OPTION	RENAME	REVOKE	ROWNUM	SELECT
UNIQUE	UPDATE	VALUES	BETWEEN	CLUSTER
COMMENT	COMPRESS	CONNECT	CURRENT	DECIMAL
DEFAULT	INITIAL	INTEGER	OFFLINE	PCTFREE
NOAUDIT	SESSION	SYSDATE	SYNONYM	TRIGGER
VARCHAR	DISTINCT	RESOURCE	ROWLABEL	SMALLINT
VALIDATE	VARCHAR2	WHENEVER	EXCLUSIVE	IMMEDIATE
INCREMENT	INTERSECT	IDENTIFIED	MAXEXTENTS	NOCOMPRESS
PRIVILEGES	SUCCESSFUL