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


July 07, 2008 05:45:19 #7
 krishnaveni_g   Member Since: July 2008    Total Comments: 9 

RE: Select from table without using column name
 
You describe the table it will show all the columns in the table

Ex: Describe Employees;
     

 

Back To Question