Basic Oracle Concepts and Programming Question:
Download Job Interview Questions and Answers PDF
How To Select Some Columns from a Table in Oracle?
Answer:
If you want explicitly tell the query to some columns, you can specify the column names in SELECT clause. The following select statement returns only two columns from the table "departments":
SQL> SELECT location_id, department_name FROM DEPARTMENTS;
<pre>LOCATION_ID DEPARTMENT_NAME
----------- ------------------------------
1700 Administration
1800 Marketing
1700 Purchasing
2400 Human Resources
1500 Shipping
1400 IT
2700 Public Relations
2500 Sales
1700 Executive
......</pre>
SQL> SELECT location_id, department_name FROM DEPARTMENTS;
<pre>LOCATION_ID DEPARTMENT_NAME
----------- ------------------------------
1700 Administration
1800 Marketing
1700 Purchasing
2400 Human Resources
1500 Shipping
1400 IT
2700 Public Relations
2500 Sales
1700 Executive
......</pre>
Download Oracle Database Interview Questions And Answers
PDF
| Previous Question | Next Question |
| How To Select All Columns of All Rows from a Table in Oracle? | How To Select Some Rows from a Table in Oracle? |