hi,

we can use desc[ribe] attribute to list down the columns of the table. but Is there any way to retrieve column names of a table using sql query?

thanks in advance,
saran.

__________________
Best Regards,
Saran.

Use System view user_tab_columns to fetch the required info.

Select column_name, data_type from user_tab_columns where table_name = 'urtablename'

Thanks Suresh,

   Its working fine. Thanks a lot once again.

   suresh...could u do one more help for me?

   How to store & retrieve value from number(20,2) in oracle. for ex. i neet an output as 123456789012345678.99 but im getting only 1.23456789012346E17.

   kindly check my new post (P2P Forum > Database > Oracle > Number(20,2) Rounding off Problem) for detail and help me. thanks a lot.

Best Regards,
Saran.

Best Regards,
Saran.