Skip to content
Advertisements

How to exit out of ed in sql

When you try to edit using ed

SQL> ed
Wrote file afiedt.buf
35
q

1* select count(*) from dba_objects
SQL>

 

Solution :

type ‘ q ‘ and enter

 

Even sometime  if you type q and enter, not working

SQL> ed
Wrote file afiedt.buf
35
;djg;fg;
?
p
/
p
/
i
k
l
m
q
nm
n;

Solution

ctrl + D

 

Use editor vi

SQL> define_editor=vi

SQL> ed
Wrote file afiedt.buf

1* select count(*) from dba_objects where owner=’APPS’
SQL> /

COUNT(*)
———-
183940

Advertisements
No comments yet

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: