Maximum Length of Oracle Variable Names

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am writing SQL statements that takes in variables such as

select * from <tablename> where userid = :userid

:userid is the variable that this statement needs...does anyone know
what is the maximum length of VARIABLE NAMES in Oracle

Parveen
 
Parveen

the size of an identifier cannot exceed 30 characters - that's for SQL and
PL/SQL

regards
roy fine
 
Back
Top