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


June 06, 2008 02:25:07 #3
 checkout_rajesh   Member Since: June 2008    Total Comments: 1 

RE: Select from table without using column name
 
desc tablename; will show all column description
select * from tablename;
     

 

Back To Question