我是使用sqlPlus但不是新的使用sql的新手,并且在我的编辑器中写入这些信息后,我会收到以下错误,并尝试运行我写的脚本.所有这一切似乎是有效的,并在sql小提琴上工作…我不知道是什么问题.有任何想法吗??我创建的文件都没有似乎工作….

sql> start sales.sq;

其中包含

1 create table salesreps

2 (empl_num number(3,0) primary key,3 name varchar2(15) not null,4 age number(3,0),5 rep_office number(2,6 title varchar2(10),7 hire_date varchar2(10) not null,8 manager number(3,9 quota number(10,2),10 sales number(10,2) not null);

产生以下错误

SP2-0734: unknown command beginning "name varch..." - rest of line ignored.

SP2-0734: unknown command beginning "age number..." - rest of line ignored.

SP2-0734: unknown command beginning "rep_office..." - rest of line ignored.

SP2-0734: unknown command beginning "title varc..." - rest of line ignored.

SP2-0044: For a list of known commands enter HELP

and to leave enter EXIT.

SP2-0734: unknown command beginning "hire_date ..." - rest of line ignored.

SP2-0734: unknown command beginning "manager nu..." - rest of line ignored.

SP2-0734: unknown command beginning "quota numb..." - rest of line ignored.

SP2-0734: unknown command beginning "sales numb..." - rest of line ignored.

SP2-0044: For a list of known commands enter HELP

and to leave enter EXIT.

Logo

魔乐社区(Modelers.cn) 是一个中立、公益的人工智能社区,提供人工智能工具、模型、数据的托管、展示与应用协同服务,为人工智能开发及爱好者搭建开放的学习交流平台。社区通过理事会方式运作,由全产业链共同建设、共同运营、共同享有,推动国产AI生态繁荣发展。

更多推荐