Tuesday, November 18, 2008

IT Hall of Shame


Oracle column alias length limitation

The following SQL:

select 1 as "Why shouldnt you have a very long column name" from dual

will result in

"ORA-00972 identifier is too long"

The maximum length for a column alias in Oracle is 30 characters. Guys, we live in age of Terabytes!

Trying to pass a list as parameter

Try the following SQL:

select 1 from dual where 1 in (:var)

with :var = 1 (works)
with :var = 1,2 (no error but no result. The list is interpreted as float)
with :var = 1,2,3 (error Invalid number)

There is no way with standard SQL instruments to pass a list as parameter in Oracle.

No comments: