Re: SQL column's as var's

Hi Ken,

Try making use of USER_TAB_COLUMNS

for i in (Select column_name from user_tab_columns where table_name='TABLE1')
loop

        if (i.column_name= ur condition)
......

I hope this is what u were looking for.

HTH Sameer Mahajan
sameermj_at_usa.net

Ken Leach <KLeach_at_ids.net> wrote in article <34C61E8B.7F55F71F_at_ids.net>...
> Does anyone know how to get the name of a column from a SQL statement
> into a variable?
>
> SELECT T1.COL1, T2.COL8
> FROM TABLE1 T1, TABLE2 T2
> WHERE T1.COL2 = T2.COL2
>
> I need to parse the 'COL1' column name as a var.
>
> lvs_column := ???;
> if lvs_column = 'COL8' then ...
>
> how?
>
>
>
  Received on Thu Jan 22 1998 - 00:00:00 CET