我是使用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,0), 6 title varchar2(10), 7 hire_date varchar2(10) not null, 8 manager number(3,0), 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.
默认情况下,SQL * Plus不喜欢空白行。但是,我们可以轻松配置SQL * Plus环境以忽略它们:
SQL> set sqlblanklines on
我们还可以将设置放入glogin.sql文件中(假设我们可以编辑它,但情况并非总是如此)。
请注意,此参数在旧版本的客户端中不起作用。