Subject: Re: Chapter 5 Text
|
| Message no. 9592 [Reply of: no. 9570 ] |
| Author: Rajeev Kumar Nagubandi (rnagubandi) |
| Date: Tuesday, July 1, 2008 2:47pm |
| Hello Everyone, Does any one knows how to edit the statements typed in SQL*PLUS of Oracle 10g? In Oracle 8i and 9i I use ‘ED' command to edit. If I use this command in SQL*PLUS of Oracle 10g, I am unable to edit, moreover it directly asks to save the file. If I do, the file saves in the home directory in .sql format but no contents were saved in that file. Thank you Rajeev Nagubandi |
Subject: Re: Chapter 5 Text
|
| Message no. 9594 [Reply of: no. 9592 ] |
| Author: Syed Shah (snshah) |
| Date: Tuesday, July 1, 2008 4:10pm |
Rajeev If you are unable to edit files. What is wrong?
One can edit SQL scripts and the command buffer (the last command entered) with the EDIT (or ED) command. However, sometimes one needs to select an editor before using this command.
Examples:
Use the Unix/Linux vi-editor: DEFINE _EDITOR=vi
Use the Notepad on Windows: DEFINE _EDITOR=notepad
Important! Add this command in your login.sql or glogin.sql scripts so it executes every time you start sqlplus.
Try this.......
Syed Naveed
Subject: Re: Chapter 5 Text
|
| Message no. 9595 [Reply of: no. 9592 ] |
| Author: Syed Shah (snshah) |
| Date: Tuesday, July 1, 2008 4:13pm |
Rajeev When SQL Plus starts up, it looks for a global login script called glogin.sql in the $ORACLE_HOME/sqlplus/admin directory. If found, this script will be executed. Thereafter, sqlplus will try to find a local login script called login.sql in the directory where you start sqlplus from, alternatively the directories listed in the SQLPATH environment variable. When found, sqlplus will execute it. NOTE: From Oracle 10g SQL Plus will attempt to execute glogin.sql and login.sql after each successful connection
Syed Naveed |
|
|
