0 Replies Latest reply: May 3, 2013 7:44 AM by 1006781 RSS

    Failed to commit: ORA-00928: missing SELECT keyword  table creation

      Hello guys.
      i tried to create the table with web interface on oracle 11g.

      i just follow this path on interface: Schema ---> table ---> create ---> Standard (Heap Organized)---> select SQl on creation mode --->
      and i just use this scripts to create the table:
      CREATE TABLE suppliers
      ( supplier_id number(10) not null,
      supplier_name varchar2(50) not null,
      contact_name varchar2(50)

      but this error happened: Failed to commit: ORA-00928: missing SELECT keyword!

      would you please help me?
      and i couldnt find any manual for working with web interface in oracle 11g.
      please give me somesources for starters.