Write SQL*Plus command to display a character column in 30 columns, and a numeric column with 9,999.99 format.
Write queries/statements for the following. (Use tables created in Chapter 4 Lab Activity.)
```
SQL> COLUMN LName FORMAT A30
SQL> COLUMN Salary FORMAT $999,999.99
SQL> /
LNAME SALARY
------------------------------ ------------
Smith $265,000.00
Houston $150,000.00
Roberts $75,000.00
McCall $66,500.00
Dev $80,000.00
Shaw $24,500.00
Garner $45,000.00
Chen $35,000.00
8 rows selected.
```
You might also like to view...
When adding records in a form, the data is stored in ________
A) a table B) a query C) a report D) the form
Which statement about comments is false?
a) Comments begin and end with /* and */, respectively. b) Programmers insert comments to document programs and im-prove program readability. c) Comments do not cause any machine language object code to be generated. d) Lengthy comments can cause poor execution-time performance.