| |
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 |
| September 09, 2008 04:41:48 |
#9 |
| raghuprasad |
Member Since: August 2007 Total Comments: 19 |
RE: Select from table without using column name |
We can not select a particular column values without knowing it's name.
However, we can select all the columns from a table using the following statement.
SELECT * FROM table_name; |
| |
Back To Question | |