Re: SQLPLUS On Linux, Command to quit from its Buffer i.e. go through 'ed' [message #375088] |
Wed, 25 July 2001 04:42 |
Cindy
Messages: 88 Registered: November 1999
|
Member |
|
|
login into SQL Prompt:
1) SQL> ed testing.sql (press return)
2) Inside the buffer now.
spool testing.list
select 'HI' from dual
/
spool off
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
:wq!
(I'm using vi editor. Esc i to write text, Ese again to exit write mode and use command mode. So to save file press Esc to exit write mode, then enter :wq! press return key, it should get back to SQL prompt.)
"testing.sql" 6 lines, 55 characters
SQL> @testing.sql
'H
--
HI
SQL>
--------------------------------------
Hummm....it works on my....it should work with your system too. Did you just enter 'ed test.sql' in Linux prompt or unless your environment is way different? Are you using the edit editor in Linux prompt, to exit edit editor in Linux prompt you enter q then press return.
|
|
|