| SQL Edit 32 HELP Documentation |
SQLEdt32 - download page
MDI Window menu File menu
| New | Create a new buffer (editing window). |
| Open | Open an existing file. |
| Close | Close current file editing window. |
| Save | Save current editing window to file. |
| Save As | Save current editing window by opening a "Save As" dialogue. |
| Printer | Print current buffer. |
| Printer Setup | Open a setup dialogue where you can set printer properties. |
| Exit | Exit the application. |
Window menu
| Tile | Tile the buffers (stack them on top of each other). |
| Cascade | Cascade the editing windows behind each other. |
| Arrange icons | Arrange minimized editing window title bars. |
| <Buffer name | Will set focus on the selected buffer window. |
Help menu
| Feedback | Send feedback, comments and bug reports. |
| SQLEdt32 Manual | View this help document. |
| SQLEdt32 FAQ | View frequently asked questions on SQLEdt32. |
| Scripts page | Open HTML page with links to SQL scripts. |
| Check for upgrade | Check if there exists a later version of SQLEdt32. |
| Messages ORA- | View help on ORA- error messages. |
| Messages PLS- | View help on PLS- PL/SQL error messages. |
| Messages PCC- | View help on PCC- error messages. |
| Messages DBA- | View help on DBA- error messages. |
| Messages EXP- | View help on EXP- export utility error messages. |
| Messages IMP- | View help on IMP- import utility error messages. |
| Messages MOD- | View help on MOD- error messages. |
| SQL*Loader messages | View help on SQL*Loader error messages. |
| V$Parameter / INITORA Help | Help on database initialization parameters. |
File editing window menu
Edit menu
| Cut | Cut out selected text and place it on clipboard. |
| Copy | Copy selected text to clipboard. |
| Paste | Paste text from clipboard. |
| Delete | Delete the selected text. |
| Select All | Select all the text in the editing window. |
| Replace | Open a "Find & Replace" dialogue. |
| Find | Open a "Find" dialogue. |
| Indent More | Increase indentation with 4 characters. |
| Indent Less | Decrease indentation with 4 characters. |
| Huge Indent | Add a large indentation to the selected code. |
| Strip Whitespace | Strip whitespace in selection. |
| Prefix lines with :NEW. | Add :NEW. to the start of every line in selection. For use in trigger bodies. |
| Prefix lines with :OLD. | Add :OLD. to the start of every line in selection. For use in trigger bodies. |
| End Line With Comma | Add a comma to the end of every line in selection. Good for use in INSERT, SELECT and UPDATE statements. |
| Start Line With Comma | Add a comma to the start of every line in selection. For use in INSERT, SELECT and UPDATE statements. |
Character menu
| Left | Left align the selected text. This is for printing only. It will not change the contents of the saved file. |
| Right | Right align the selected text. This is for printing only. It will not change the contents of the saved file. |
| Center | Center align the selected text. This is for printing only. It will not change the contents of the saved file. |
| Word Wrap | Toggle Word Wrap mode. word Wrap Mode will cause lines to continue on the next line. When not in Word Wrap Mode, a horizontal scrollbar is shown if the line length of the text in the editing window is longer than the width of the editing window itself. |
| Font | Change font of the selected text. This is for printing only. It will not change the contents of the saved file. |
Blocks menu
The "Blocks menu" provides you with a very fast way of writing PL/SQL code. Write the code top-down (beginning with the outermost block) and use menu selection "Indent More" on the "Edit menu" for formatting.
| Begin . . . End | Create an empty begin-end block with empty default exception statement. |
| Exceptions | Insert any of all predefined exceptions. Also syntax for PRAGMA EXCEPTION_INIT and Raise_Application_error. |
| If . . . End If | Create an empty "IF ... END IF;" statement. |
| If Else End If | Create an empty "IF ELSE END IF;" statement. |
| For . . . Loop | Create an empty "FOR (IN) LOOP . . . END LOOP" statement. |
| Cursor Is | Create an empty "CURSOR . . . IS SELECT . . . " statement. |
| Cursor Loop | Insert an empty cursor loop structure. |
| Cursor Fetch If Else | Insert a loop with cursor fetch with test for %NOTFOUND. |
| Cursor . . . For Update | Create structure with a "cursor for update". |
| Exit When | Insert a loop with cursor fetch with "exit loop when %NOTFOUND". |
| Implicit Cursor Attribs | Example of implicit cursor attributes (DELETE - WHEN SQL%FOUND). |
| PL/SQL Table Attribs | Example of PL/SQL table attributes (as EXISTS, COUNT, FIRST, LAST, PRIOR, NEXT, and DELETE). |
Create menu
| Procedure | Create a new procedure stucture. |
| Function | Insert an empty stucture for a new function. |
| Package Spec | Create a new package specification. |
| Package Body | Create a new package body. |
| Sequence | Create a new sequence. |
| Table | DDL command for creating a table. |
| Constraint | Create various constraints. |
| Cluster | Create a cluster. |
| Index | DDL for creating a cluster. |
| Security | Various sequrity DDL snippets (user, role, grants, audit). |
| DBA Create | Create database links, tablespaces, RB-seg, snapshots. |
| Object (Type) | Create Oracle 8 objects. |
| Record | Create a record. |
| Standard Comment | Insert a standard (empty) comment. |
| Header | Insert a standard header. |
DML menu
| Select | DML for a select statement. It contains GROUP BY and HAVING and provides a fast way of entering the basic structure of an select statement. |
| Update | An example of update DML. |
| Delete | An example of delete DML. |
| Savepoint | How to issue a savepoint. |
| Rollback | How to issue a rollback. |
| Prior Level | Example of LEVEL and PRIOR in select statement. |
| Hints | This entry contains all available hints sorted on function. |
| Locking | Examples of various strategies for handling record locking. |
| Set Transaction | Syntax for "Set Transaction". |
| Partitioned Table DML | Oracle 8 partioned table select (see also Create / Table). |
Triggers menu
| Row Trigger | Create a new row level trigger. |
| Statement Trigger | Adaptable empty structure for a statement trigger. |
| PL/SQL Table Trick | This piece of code shows how to defer the execution of code from the row level trigger to statement level trigger. It is in some cases the only way to avoid error ORA-04091 (Mutating trigger). |
Alter menu
| Database | Various "ALTER DATABASE . . " DDL commands. |
| Datafile | Commands for altering datafiles. |
| Tablespace | Commands for altering tablespaces. |
| Rollback segment | DDL commands for use with rollback segments. |
| Session | Alter commands for a session. |
| Cluster | Alter commands for clusters. |
| Table | Alter commands for tables, table triggers and constraints. |
| System | Various "ALTER SYSTEM . ." DDL commands. |
| Snapshot | Commands for altering snapshots. |
| Mount Exclusive | How to mount an DB exclusive. |
| Kill Session | Syntax for "KILL SESSION". |
| Flush Shared Pool | How to flush the shared pool. |
Scripts menu
| Extraction Scripts | Extraction scripts for tables, views, triggers, indexes and constraints. |
| DML Scripts | Create insert or update statements for a table with a lot of columns using just a select statement on the system catalogue. |
| Uncompiled | Fast way to recompile uncompiled objects.. |
| Explain Plan | Example of the use of "Explain Plan". |
| Import Parfile | A collection of import utility parameter files. |
| Export Parfile | An almost ready to use export utility parameter file. |
| Encrypt (Object Code) | How to encrypt stored objects to keep the source code secret. |
Information menu
| Find Objects | Search for a specific object in all_objects. |
| Object Errors | Show errors in packages, procedures and functions - including the exact location of the error along with a description. Neat!. |
| Sessions | See summary of all sessions. |
| Locking | See locked objects or locking sessions. |
| Storage | Retrieve storage information. |
| Parameter Info | Detailed descriptions of quite a lot of various INITORA initialization parameters. |
| Hit Ratios | Get information on hit ratios. |
| Tuning | Retrieve tuning information. |
| System Info | Show system information. |
| Foreign Key | Enter the owner (schema) and the foreign key name and you'll get detail information on tables and columns affected. Usable when you violate a foreign key. |
| Primary Key Columns | Retrieve the columns in the primary key for a table. |
| Table Constraints | Retrieve primary key, referencing foreign keys, referenced foreign keys and uniqu constraints for any table. |
| User Dependencies | See all user dependencies. |
| Profiles | Retrieve information on profiles. |
| Synonyms | Retrieve information on synonyms. |
| ASCII Charset | See all characters having ASCII-value 32..255. Also includes a small recursive function for retrieving characters having ASCII-value greater than 31. |
Extras menu
| Dynamic SQL | A function taking any SQL-statement as argument. The entered SQL-statement will be run on the server |
| Enable Constraints | Just a script for enabling all constraints in a schema. |
| Remove Duplicates | This entry shows how to remove duplicate records from a table. |