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.