RSS

 
  Configuration component

Oracle 8i PL/SQL

ZIP FileWindows 9x SFXWindows NT SFX
WinEdt_PLSQLCC.zip
(33 K)
WinEdt_PLSQLCC_9x.exe
(59 K)
WinEdt_PLSQLCC_NT.exe
(59 K)
Last update on: 27.11.2001

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
The highlighted items (keywords):
  • 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

ItemAction
Start with SQL PlusSends 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.
Also you will have to enter the full path to your SQL*Plus executable.

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)