How can I get column names from a table in oracle?
- 1 Answers
- 1151 Views
- I also Faced
- E-Mail Answers
Answer / Rakshit Kumar
To retrieve the column names (or headers) of a table in Oracle SQL, you can use the DESCRIBE command. For example, to see the column names for the EMPLOYEES table, you can execute `DESCRIBE employees`. This will display a list of columns with their data types and other details.
| Is This Answer Correct ? | 0 Yes | 0 No |
How to assign values to variables?
How to connect ms access to oracle servers?
What is the difference between sharding and replication?
What are the various oracle database objects?
sql query to get zero records from a table
Describe the different type of Integrity Constraints supported by ORACLE ?
ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process
how to find the n'th highest salary from emp ?
Will the Optimizer always use COST-based approach if OPTIMIZER_MODE is set to "Cost"?
Why is oracle used?
Explain the use of record length option in exp command.
I have a table emp. There is only one column in the table. In that , there are only three rows in that column. The value in the first row is 'A' and the value in the second row is 'B' and the third row is 'C'. Now, my question is , How will you write a select query to display the output as B C A Note: order by cannot be used coz it gives us output as CBA. But the output should be BCA.
Oracle General 
