About Column Names

[Prakash]

Hi,I need ur help to resolve my issue.I'm using Oracle 9i.I've a table with 10 columns. Each column has 10 values (i.e., 10 records completely). In that, 5 columns have some null values. I want to retrieve the column names in which the records have the null values.Pls help me finding the query.Thanq in advance.Bye.

[vijay]

Hi.. use following query: Query:select * from `table_name` where field1 is null or field2 is null or field3 is null or field4 is null or field5 is null Regards,Vijay-------------------------------------------------------------------

Hi,I need ur help to resolve my issue.I'm using Oracle 9i.I've a table with 10 columns. Each column has 10 values (i.e., 10 records completely). In that, 5 columns have some null values. I want to retrieve the column names in which the records have the null values.Pls help me finding the query.Thanq in advance.Bye.