This discussion is archived
0 Replies Latest reply: May 3, 2013 12:44 AM by 1006781 RSS

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

1006781 Newbie
Currently Being Moderated
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.
Thanks.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points