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
 

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
Need Help with Stored Procedure 1
Inserting blob using ORACLE OLEDB 3
Problems with Session variable 2
ADO .NET ODP Equivalent of DBMS_SESSION.SET_CONTEXT 1
Security Questions 7

Back
Top