Basic Oracle Concepts and Programming Question:
Download Questions 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>

Download Oracle Database Interview Questions And Answers PDF

Previous QuestionNext Question
How To Select All Columns of All Rows from a Table in Oracle?How To Select Some Rows from a Table in Oracle?