can I use DESC oracle function to display just the column name?

Question

I know how to do this using SELECT but how can I do this using DESC?

Answer 1

No, you can't. These are the only options available regarding DESC/DESCRIBE:

• LINESIZE
• DEPTH
• INDENT
• LINE

Of those, DEPTH would be the most likely - but all it does is lookup children objects & present their attributes in the list.