next up previous contents
Next: Add data to a Up: Oracle Basics Previous: Connect and Startup   Contents

Create a table

If you disconnected from SQL*Plus reconnect and we'll try creating a table.

bash-2.05$ export ORACLE_SID=test
bash-2.05$ sqlplus /nolog        

SQL*Plus: Release - Production on Tue Oct 5 17:25:27 2004

Copyright (c) 1982, 2004, Oracle.  All rights reserved.

SQL> connect sys/passwd as sysdba
SQL> create table address_book (
  2  id number,
  3  name varchar2(30),
  4  home_num varchar2(12),
  5  cell_num varchar2(12),
  6  location varchar(40)
  7  );

Table created.