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
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
In a PL/SQL block, if you are querying a database table, you need to declare data variables to hold column values returned from the query. The variables can be declared
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
The DBMS_UTILITY.COMPILE_SCHEMA procedure compiles all procedures, functions and packages in the specified schema. DBAs now don’t have to generate the dynamic scripts to recompile the invalid objects in the schema
PL/SQL supports three parameter-passing modes: IN
At some point, you must have encountered a “Snapshot too old” error when running a huge batch transaction. Then you find that you may have to restart the process all
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