UEDIT32 combined with SQLPLUS
People who have used UEDIT32 know that although this tool is small, it is full. As long as we are working in work.
Wonderful use uses it, you can make our work efficiency more than half-effaller. So, in the following article, I will talk about it.
UEDIT32 and Oracle SQLPLUS Usage. First download and install Uedit32, make sure SQLPLUS can run normally, the next thing is both
The system is configured, and according to the following steps: Step 1: Find this folder in the Oracle installation directory, if this file is not available
Clip, create a folder named DBS, then create a new text file under this folder,
Taken to: login.sql. Step 2: Newly built a text file in the UEDIT32 installation directory, named: plsql.txt Step 3: Open Uedit32, under Advanced of Uedit32 Main Menu, Select
Configuration ... Enter a page UltraEdit Configuration. at this
Select Syntax Highlighting in the page, in Full Path Name for, the second
Step to create PLSQL.txt Connect to this, that is, click Browse, directly in the Uedit32 directory
Find this file in Plsql.txt, after confirming, everything is OK. Step 4: Will be under the View as (Highlightiing File Type under the VIEW of the Uedit32 main menu)
Show a SQL, which means that your configure already succeed.
There is no SQL under the menu, indicating the Configuration error, repeating the steps on the upper side until
Now SQL. ***** If the configuration is successful, each time the SQL statement is edited in SQLPLUS, you have edited
Or the SQL statement modification is executed, you can enter the ED directly to enter the editing status of the UEDIT32, so
Very convenient for use speed.
Another attached: login.sql file script:
Define _Editor = 'udit32.exe' set editfile a.sql set line 1000
Description: PLSQL.TXT scripts are mainly used to control SQL statements in the font display color in Uedit32, change
Quantity name, function name, etc. will be displayed in different colors, convenient to modify and identify. Due to the limited space, if needed,
You can give me Mail.
Marine
2002-05-31