Return column names with lower case from query
565985Jul 17 2007 — edited Jul 17 2007Hi,
I have another issue :)
Let's say I have this table :
CREATE table tbl1 (col1 int, col2 varchar2(100))
If I do a select * from tbl1 I get the result:
COL1 COL2
-----------------------------
The records are not important, what I need is to return column names without capital letters, like this:
col1 col2
---------------------------
I tryied
select col1 as 'col1' from tbl1
but I get an error on this query.
So is it possible to return column names without capitals ?
I use Oracle 9.2
Thanks