GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  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