Re: sqlplus question

Hi Martin,
You have nearly good,just add the keyword table to create statement like this :
sql> create table j_f_table

     (j_f number (2),
      description char (30));

However, why do you use char type for the description field and not varchar2 type ? Is ther a specific reason ?

Regards. Olivier

Martin Meadows wrote:

> Hi. I'm Joe user. Can't I execute the following in sqlplus:
>
> sql> create j_f_table
> (j_f number (2),
> description char (30));
>
> I get error at line 1:
> ORA-00901: invalid CREATE command
>
> Why?
>
> Thanks for the info,
> Martin Meadows
Received on Sat Mar 28 1998 - 00:00:00 CET