我是使用sqlPlus但不是新的使用sql的新手,并且在我的编辑器中写入这些信息后,我会收到以下错误,并尝试运行我写的脚本.所有这一切似乎是有效的,并在sql小提琴上工作…我不知道是什么问题.有任何想法吗??我创建的文件都没有似乎工作….
原文链接:https://www.f2er.com/oracle/205419.htmlsql> 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.