爱玺玺

SQL> alter table ordersitem add (name varchar2(50) not null);
Table altered

SQL> desc ordersitem;
Name      Type         Nullable Default Comments
--------- ------------ -------- ------- --------
ID        NUMBER                                
ORDERSID  NUMBER       Y                        
BOOKID    NUMBER       Y                        
BOOKCOUNT NUMBER       Y                        
NAME      VARCHAR2(50)                          

注意这里不需要column了