editting .sql file problem - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

editting .sql file problem

editting .sql file problem# Database - 数据库

l*s2003-10-21 07:10

1 楼

without having created a .sql file, I say to the command line:
SQL> edit test.sql
I was expecting the system will open the default VI editor and a
new file called test.sql to let me edit. But Oracle did not. It
led me to a blank of nothing. I had a hard time to go back to the
SQL> prompt. Finally got out of that blank line by randomly pushing
the q and return.
Then my question is: How shall I create a .sql file and edit it
in Oracle? What did I do wrong?
Thank you..

m*t2003-10-21 07:10

2 楼

Try
SQL> DEFINE _EDITOR=vi
SQL> EDIT test

【在 l***s 的大作中提到】

: without having created a .sql file, I say to the command line:
: SQL> edit test.sql
: I was expecting the system will open the default VI editor and a
: new file called test.sql to let me edit. But Oracle did not. It
: led me to a blank of nothing. I had a hard time to go back to the
: SQL> prompt. Finally got out of that blank line by randomly pushing
: the q and return.
: Then my question is: How shall I create a .sql file and edit it
: in Oracle? What did I do wrong?
: Thank you..

s*m2003-10-21 07:10

3 楼

You need to define your default editor in sqlplus environment. If you define
default editor as below, it is valid for current session only. You can set it
to default globally in a file called login.sql or glogin.sql belong to Oracle
installation. Add
define _editor=vi
in this file. Next time when you type edit in sqlplus, vi will be your editor.