Maximum Length of Oracle Variable Names

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
 
R

Roy Fine

Parveen

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

regards
roy fine
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Joining oracle and SQL Server data 1
Multiple Values To Oracle Parametter Object (IN) 3
Database Auditing and connection strings 4
ADO .NET ODP Equivalent of DBMS_SESSION.SET_CONTEXT 1
Need Help with Stored Procedure 1
Oracle dbid length exceed maximum (>16) 3
Security Questions 7
Syntax error converting the varchar value 'admi' to a column of datatype int. 2

Top