一尘不染

SqlPlus SP2-0734:错误

sql

我是使用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.

阅读 795

收藏
2021-03-17

共1个答案

一尘不染

默认情况下,SQL * Plus不喜欢空白行。但是,我们可以轻松配置SQL * Plus环境以忽略它们:

SQL>  set sqlblanklines on

我们还可以将设置放入glogin.sql文件中(假设我们可以编辑它,但情况并非总是如此)。

请注意,此参数在旧版本的客户端中不起作用。

2021-03-17