SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to get all column names from table.

Mickel JohnFeb 28 2017 — edited Feb 28 2017

Hi,

I am trying to get all column names at a time using database query.

I am using oracle database(11g).

Ex:--

Emp_table:

id name address

----------------------------

1 jack US

Then after running the query i get only id,name, address only.

This is my requirement.

Please help me.

Thank you in advance.

This post has been answered by Gaz in Oz on Feb 28 2017

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 28 2017

Added on Feb 28 2017

#sql-developer

8 comments

52,965 views