Select
<exp>
From
<t_name>
[where<cond>]
[group<col_name>]
[having
by <group col_name>]
[order
by <col_name>[asc|desc]];
Identifiers in PL/SQL
PL/SQL identifiers are constants, variables, exceptions, procedures, cursors, and reserved words. The identifiers consist of a letter optionally followed by more letters, numerals, dollar signs, underscores, and number signs and should not exceed 30 characters. By default, identifiers are not case-sensitive. So you can use integer or INTEGER to represent a numeric value. You cannot use a reserved keyword as an identifier.
