Select column name

[FumacII]

Hi,

Does anyone know if there is any possibility to select an column name with an cell that contains a specific value?
I am using Oracle 8.0.

Something like:
Select columnname
from thisDatabaseName
where value = 0
and id = 1

I need to know which columns that contains the value 0 (False).

Thank you for any resonse,

/Fumac

 

[Whitebat]

Maybe
SELECT *
FROM thisDatabaseName
WHERE value = 0
AND id = 1

 

[FumacII]

No not really, that wont return the column names.
But I´ve solved it in another way, I remade the table.

Thank you anyway!

/Fumac