Database Reference
In-Depth Information
Figure 4.2
SQL*Plus Report
Layout.
To select specific columns, the asterisk could be changed to something
like PRESSED_DATE, TITLE, MUSICCD_ID, listing columns in the
sequence specified.
SELECT PRESSED_DATE, TITLE, MUSICCD_ID FROM MUSICCD;
The next query contains a calculation between two columns. You can
add, subtract, multiply, divide, and use parentheses to affect the calculation
order of factors in expressions. When you combine columns, include calcu-
lations, or other operations, an expression is created. Expressions can be
used in a SELECT statement anywhere you use a column.
SELECT ARTIST_ID, SESSION_DATE, AMOUNT_CHARGED-AMOUNT_PAID
FROM STUDIOTIME;
Observe that the column heading of the third column is
AMOUNT_CHARGED - AMOUNT_PAID. This is long, and if you
