Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To Select Some Columns from a Table
How To Select Some Columns from a Table? - Oracle DBA FAQ - Understanding SQL SELECT Query Statements
✍: FYIcenter.com
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; LOCATION_ID DEPARTMENT_NAME ----------- ------------------------------ 1700 Administration 1800 Marketing 1700 Purchasing 2400 Human Resources 1500 Shipping 1400 IT 2700 Public Relations 2500 Sales 1700 Executive ......
2007-04-21, 5066👍, 0💬
Popular Posts:
How To Select an Oracle System ID (SID)? - Oracle DBA FAQ - Creating New Database Instance Manually ...
Where Do You Download JUnit? Where do I download JUnit? I don't think anyone will ask this question ...
How To Manage Transaction Isolation Level? - Oracle DBA FAQ - Introduction to PL/SQL Transaction iso...
What Articles Have You Read about JUnit? There are a number of JUnit articles that you should read: ...
Can a variable be both const and volatile? Yes. The const modifier means that this code cannot chang...