Oracle Database 11g: SQL Fundamentals I 1 - 6
Selecting All Columns
You can display all columns of data in a table by following the SELECT keyword with an asterisk
(*). In the example in the slide, the department table contains four columns: DEPARTMENT_ID,
DEPARTMENT_NAME, MANAGER_ID, and LOCATION_ID. The table contains eight rows, one for
each department.
You can also display all columns in the table by listing all the columns after the SELECT keyword.
For example, the following SQL statement (like the example in the slide) displays all columns and all
rows of the DEPARTMENTS table:
SELECT department_id, department_name, manager_id, location_id
FROM departments;
Note: In SQL Developer, you can enter your SQL statement in a SQL Worksheet and click the
“Execute Statement” icon or press [F9] to execute the statement. The output displayed in the Results
tabbed page appears as shown in the slide.