Oracle:Initial Queries

From mi-linux
Jump to navigationJump to search

Main Page >> Oracle and SQL >> Workbook >> Getting Started >> Initial Queries

Initial Queries

Try the following commands and exercises:

Getting Information about the Attributes of a Table

To get a description of a particular table use the DESCRIBE command.

To describe the table EMP:

 describe emp 

Note, describe is a command proprietary to Oracle and is not part of the SQL standard. These commands are part of the Plus commands Oracle provides and do not need a semi-colon after them.

Exercise 1.1

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

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
 select * from dept;
 select * from emp;
 describe salgrade
 select * from salgrade;

⇒ Make notes on how the results differ.

Next Step

This concludes setting up the Oracle database. Return now to the Workbook for the next section.