SQL

수정시 : 라인번호 변경하고자 하는 명령어
list l
run /

create table test (id integer, name char(8))
  같은거
  1  create table test
  2  (id integer,
  3* name char(8))

SQL> desc test
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 ID                                                 NUMBER(38)
 NAME                                               CHAR(8)

 

insert into test
  2  values (100, 'YB')
  3

SQL> select * from test;
        ID NAME
---------- --------
       100 YB