79758

Creating a Table

You can usc SQL Developer to crcate a tablc.

In the following example. you creatc a tablc called purchase_orders in the HR schema.

The table has the following columns:

See Also:

■"About Tables" on page 8-5 See Also:

■ "About Tables" on page 8-5

Column Name Data Type Si/.e Not Nuli Primary Key

PO_NUMBER NUMBER Yes Yes PO_DESCRIPTION VARCHAR2 200 No PO_DATE DATĘ Yes Managing Tables

8-12 Oracle Database 2 Day DBA

To create the PURCHASE_ORDERS table in the HR schema:

1.    Navigatc to the Tables nodc in the schema wherc you want to create the ncw tablc, as dcscribed in "Viewing Tables" on page 8-10.

2.    Right-click the Tables node and selcct New Table.

The Create Table dialog box appears, with the Tablc tab displayed.

You can create simple tables quickly using only the default options on the Table tab. If you want to create morę advanced tables, select the Advanced chcckbox, which provides many morę options for table creation. Unselect the Advanced checkbox to return to the default options on the Table tab.

3.    In the Schema field, select HR.

4.    In the Name field, enter PURCHASE_ORDERS.

5.    In the Columns section, enter column information foreach of the columns in the PURCHASE_ORDERS table as specified in the table in the introduction to this topie. For example, for the First column in the PURCHASE_ORDERS table, enter the name

PO_

NUMBER and the data type NUMBER, select the Not Nuli check box, and select the Primary Key check box. Click Add Column after adding a column. and then add the information for the ncxt co