Oracle 8i PL/SQL

About

This configuration component contains highlighting, menu and tool bar customizations for programming PL/SQL 8i. The communication with server is accomplished via SQL*Plus and a little programm named PushKeys.

Installation

The contents of a ZIP file should be extracted in %b\Config\PLSQL directory. Note that %b is different from %B. While %B always means the WinEdt program directory (usually it is C:\Program Files\WinEdt Team\WinEdt) %b means:

on Windows 95/98/Me:

equals %B
(usually it is C:\Program Files\WinEdt Team\WinEdt)

on Windows NT/2000/XP working as Administrator (or single user mode):

equals %B
(usually it is C:\Program Files\WinEdt Team\WinEdt)

on Windows NT/2000/XP working as an ordinary user:

equals <userprofile>\Application Data\WinEdt
(usually it is C:\Documents and Settings\<username>\Application Data\WinEdt or C:\WinNT\Profiles\<username>\Application Data\WinEdt)

To make this easier this macro component is distributed in three packages:

1. Plain ZIP file WinEdt_PLSQLCC.zip for general purpose. Unzip it to %b\Config\PLSQL and execute install.edt
2. Self extracting ZIP file with installer WinEdt_PLSQLCC_9x.exe for users that are using Windows 9x/Me or Windows NT/2000/XP as Administrator. By default the installer sets the target directory to C:\Program Files\WinEdt Team\WinEdt\Config\PLSQL After installation the Explorer opens in the target directory allowing you to open install.edt in WinEdt and execute it via Macros|Execute Macro...|install.edt
3. Self extracting ZIP file with installer WinEdt_PLSQLCC_NT.exe for users that are using Windows NT/2000/XP as an ordinary user. By default the installer sets the target directory to <userprofile>\Application Data\WinEdt\Config\PLSQL (usually C:\Documents and Settings\<username>\Application Data\WinEdt\Config\PLSQL or C:\WinNT\Profiles\<username>\Application Data\WinEdt\Config$name). After installation the Explorer opens in the target directory allowing you to open install.edt in WinEdt and execute it via Macros|Execute Macro...|install.edt

What does it contain?

After installation a menu item called Options|Configurations|PL/SQL Editor is added (Figure 1).

Highlighting

To see the highlighting answer 'Yes' at the end of installation or you can later open sample.sql file by hand.

The highlighted items (switches):

• PL/SQL single line comment
• PL/SQL multi line comment
• PL/SQL literal

• PL/SQL types (e.g. NUMBER, DATE, VARCHAR2...)
• PL/SQL functions (e.g. SIN, RPAD, TO_CHAR...)
• PL/SQL logical operators and values (e.g. AND, TRUE, NULL...)
• SQL reserved words (e.g. SELECT, GRANT, UNION...)
• PL/SQL reserved words (e.g. CURSOR, RAISE, LOOP...)

Active Strings

None yet.

Insert Menu

None yet.

Accessories Menu

Item	Action
Start with SQL Plus	Sends to SQL*Plus (or opens if it is not running) 'start %n'. Of course the file has to be in the SQL*Plus current working directory so it i s best to leave WinEdt start SQL*Plus.

(Figure 2)
The login can be done i three ways:

Manual

enter username/password/database manually (Figure 3)

Semi automatic

WinEdt passes your username and database to Log On dialog and you type in the password. Currently only one default connection can be, see %b\Config\PLSQL\SQLPLus.edt for details. (Figure 4)

Automatic

WinEdt passes your username/password/database to Log On dialog. Currently only one default connection can be, see %b\Config\PLSQL\SQLPLus.edt for details. (Figure 5)
NOTE: It is not wise to store your password in a easily accessible file.

Help Menu

None yet.

Dictionary

All PL/SQL keywords and functions are in dictionary that can be used for fast completion using the CTRL + Enter shortcut.

Mode contributed by D Stancer (denis@srce.hr)

Last revised on: 27.11.2001    |    Comments and suggestions to webmaster@winedt.org