[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Modify command in SQL Plus

Posted on 2008-11-09
3
Medium Priority
?
1,310 Views
Last Modified: 2013-12-19
How I can modify commands written before in SQL Plus as SELECT statement ?

Note: Modify the commands stored in buffer.
0
Comment
Question by:interbus
  • 2
3 Comments
 
LVL 27

Accepted Solution

by:
sujith80 earned 2000 total points
ID: 22919457
You may type
"ed"
and press enter.

It will open the command in the buffer in an editor window. You can edit and close it. And press "/" followed by "enter" to execute the command.
0
 
LVL 27

Expert Comment

by:sujith80
ID: 22919470
there are other sqlplus options like "list" change etc.

Take a look at this URL
http://download.oracle.com/docs/cd/B19306_01/server.102/b14357/ch5.htm#i1210079
0
 

Author Comment

by:interbus
ID: 22919478
Good solution thank you
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
Via a live example, show how to take different types of Oracle backups using RMAN.
This video shows how to recover a database from a user managed backup
Suggested Courses
Course of the Month18 days, 8 hours left to enroll

825 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question