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, 5249👍, 0💬
Popular Posts:
What Happens to Indexes If You Drop a Table? - Oracle DBA FAQ - Managing Oracle Table Indexes If you...
What is the difference between Authentication and authorization? This can be a tricky question. Thes...
Can we use the constructor, instead of init(), to initialize servlet? Yes , of course you can use th...
How many types of validation controls are provided by ASP.NET ? There are six main types of validati...
What is effort variance? Effort Variance = (Actual effort – Estimated Effort) / Estimated Effort.