Selecting All Columns from a Table

Selecting All Columns from a Table

If you want to select all columns in a table, rather than enumerate each column name in a long list, you can use the asterisk character ( * ) in your select list. In the following example, the asterisk is used with SELECT to retrieve all columns from the customers table:

  SELECT *   FROM customers;  CUSTOMER_ID FIRST_NAME LAST_NAME DOB PHONE ----------- ---------- ---------- --------- ------------  1 John Brown 01-JAN-65 800-555-1211  2 Cynthia Green 05-FEB-68 800-555-1212  3 Steve White 16-MAR-71 800-555-1213  4 Gail Black 800-555-1214  5 Doreen Blue 20-MAY-70 

As you can see, all the columns in the customers table are displayed.