May 4, 2000

Altering the Substitution Character in SQL*Plus

When you are inserting data into Oracle tables in SQL*Plus using hard-coded string, some of the character fields may contain the ampersand character (&). The following is an example: insert

Indexing Foreign Key Columns in Child Tables

Although an index is not mandatory on your foreign keys, if they are not indexed you will cause additional locking when certain Data Manipulation Language statements are executed against the

Pre-Compiled Database Triggers

Many programmers create stored procedures out of large bodies of database trigger codes. This has primarily been because while stored procedures are stored in compiled form, database triggers are compiled

View SQL Behind System Stored Procedures

If you are ever trying to write SQL to access SQL server’s system tables, it is often useful to look at SQL Server’s own system stored procedures. You can do