| |
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 |
| August 08, 2008 03:18:41 |
#8 |
| navkmh |
Member Since: August 2008 Total Comments: 1 |
RE: Select from table without using column name
|
I have been using this sql query for selecting the column names of a table.
select column_name from information_schema.columns where table_name='tablename'
Hope u find it useful.
-Naveen |
| |
Back To Question | |
