CREATING A NEW TABLE
CREATING A NEW TABLE
To create a new table on the local database,
if you are using Oracle Navigator
you can:
(Navigator is the first screen you see when you open Personal Oracle7. It functions
like the Windows 95. You can use Navigator to access data connections, database objects,
all projects),
- Right-click the Table folder under Local Database on the left side of the
Navigator.
- A list of options appear.
- Click New. The New Table dialog appears.
- To create the table using the Table wizard, click use Table Wizard and
follow the instructions.
- Click Create table and click OK.
- The New Table property Sheet appears.
- Type the table name in the Name field.
- Click the down arrow in the Owner field and select the owner
from the list.
- Click the Design tab. The Design page appears.
- Fill out the table grid. Click OK. The new table appears in the
list on the right side of Navigator.
If you are using "CREATE TABLE" statement:
you can click here :CREATE A TABLE
Back to SQL/ORACLE Overview