Question

SQL创建表时出错，请问是什么原因。

SQL> begin
2 create table students
3 (
4 student_id number not null,
5 student_name varchar2(20),
6 )
7 tablespace users
8 /
create table students
*
ERROR at line 2:
ORA-06550: line 2, column 1:
PLS-00103: Encountered the symbol "CREATE" when expecting one of the following:
( begin case declare exit for goto if loop mod null pragma
raise return select update while with <an identifier>
<a double-quoted delimited-identifier> <a bind variable> <<
continue close current delete fetch lock insert open rollback
savepoint set sql execute commit forall merge pipe purge

Answer 1

从错误消息理解 貌似是语法错误。

Answer 2

begin是多余的。。。

Answer 3

create table students ( student_id number not null, student_name varchar2(20));
试一下