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 All Columns of All Rows from a Table
How To Select All Columns of All Rows from a Table? - Oracle DBA FAQ - Understanding SQL SELECT Query Statements
✍: FYIcenter.com
The simplest query statement is the one that selects all columns of all rows from a table: "SELECT * FROM table_name;". The (*) in the SELECT clause tells the query to return all columns. The tutorial exercise below gives you a good example:
SQL> SELECT * FROM departments;
DEPARTMENT_ID DEPARTMENT_NAME MANAGER_ID LOCATION_ID
------------- -------------------- ---------- -----------
10 Administration 200 1700
20 Marketing 201 1800
30 Purchasing 114 1700
40 Human Resources 203 2400
50 Shipping 121 1500
60 IT 103 1400
70 Public Relations 204 2700
80 Sales 145 2500
90 Executive 100 1700
......
2007-04-21, 6969👍, 0💬
Popular Posts:
How did you implement UML in your project ? PART II Implementation phase / Coding phase (Class diagr...
Can we get a strongly typed resource class rather than using resource manager? In the previous quest...
What will be printed as the result of the operation below: #define swap(a,b) a=a+b;b=a-b;a=a-b; void...
Do events have return type ? No, events do not have return type.
If we have two version of same assembly in GAC how do we make a choice ? OK first let’s try to under...