| |
GeekInterview.com > Interview Questions > Oracle > SQL
| Print | |
Question: Select from table without using column name
Answer: How can I select column values from a table without knowing the column name ?
Suppose , select employee_id from employees , now I don't know the column name and I want to select the column.
Please let me know the answer |
| June 06, 2008 12:04:41 |
#6 |
| srividhya_85 |
Member Since: June 2008 Total Comments: 6 |
RE: Select from table without using column name
|
To Know Column_Name from the table
Select COLUMN_NAME
from USER_TAB_COLUMNS
Where TABLE_NAME = 'EMPLOYEES';
|
| |
Back To Question | |
