Answers to Chapter 2
 | Reviewing It |
| 1: | What is Oracle's main character-mode interface? |
| A1: | SQL*Plus |
| 2: | What is the syntax of the CHANGE command to change text in the SQL buffer? |
| A2: | C/<source string>/<new string> |
| 3: | The DESCRIBE command is useful for what? |
| A3: | Displaying Object column names and attributes |
| 4: | What will the command SELECT * FROM EMP do? |
| A4: | This will show all the rows in the table EMP |
| 5: | In the table EMP, give the ORDER BY clause that will return the rows in the order of DEPTNO ascending and within DEPTNO, SAL descending. |
| A5: | ORDER BY DEPTNO, SAL desc |
| 6: | What is the difference between a NULL and a 0 field? |
| A6: | NULL contains no value at all |
Get Oracle9i™ Development by Example now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
