Oracle:Section1

Main Page >> Oracle and SQL >> Workbook >> Section 1 answers

Answers to Section 1

You should only look at the answers once you have attempted them yourself!

Exercise 1.1 Type in the SQL code to display the structure of the CUSTOMER table.

DESC CUSTOMER

The result should be similar to the following:

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 CNO                                                NUMBER(4)
 ORDERDATE                                          DATE
 NAME                                               VARCHAR2(15)
 CITY                                               VARCHAR2(15)
 COUNTRY                                            VARCHAR2(15)
 PNO                                                NUMBER(4)
 DESCRIPTION                                        VARCHAR2(20)
 QTY                                                NUMBER(4)

Type in the following commands separately:

describe dept

Shows the structure of the dept table

select * from dept;

Shows the contents of the dept table (data)

select * from emp;

Shows the contents of the emp table (data)

describe salgrade

Shows the structure of the salgrade table

select * from salgrade;

Shows the contents of the salgrade table (data)

Exercise 1.2

Now try and retrieve the employee's name, hiredate and sal:

SELECT ENAME, HIREDATE, SAL
FROM EMP;

The results should be similar to:

ENAME HIREDATE SAL

---

--------- ----------

KING 17-NOV-81 5000 JONES 02-APR-81 2975 SCOTT 09-DEC-82 3000 ADAMS 12-JAN-83 1100 FORD 03-DEC-81 3000 SMITH 17-DEC-80 800 BLAKE 01-MAY-81 2850 ALLEN 20-FEB-81 1600 WARD 22-FEB-81 1250 MARTIN 28-SEP-81 1250 TURNER 08-SEP-81 1500 JAMES 03-DEC-81 950 CLARK 09-JUN-81 2450 MILLER 23-JAN-82 1300

14 rows selected.