The ‘Oracle’ Archives
Posted December 12, 2011 by

Oracle: Using the AFTER INSERT and AFTER UPDATE triggers

A database trigger is a stored procedure that automatically executes whenever an event occurs. The event may be insert-delete-update operations. Oracle initiates an ‘AFTER INSERT’ trigger after an insert event has been occurred and an ‘AFTER UPDATE’ trigger after an update event has been occurred.

Category Oracle

Posted December 7, 2011 by

Oracle: How to Create a Copy of Table Data

Knowing how to copy existing table data is beneficial to any DBA. This tutorial will demonstrate how to copy an existing table’s data into a new table. Examples with walkthrough explanation are provided.

Category Oracle

Posted December 5, 2011 by

Oracle: How to Create an Auto Increment Field Using Sequence

In Oracle, you can create an auto increment field using ‘sequence’ database object that can be assigned as primary keys. Using Oracle ‘sequence’ object, you can generate new values for a column. An Oracle sequence is an object like a table or a stored procedure. Examples with walkthrough explanations are provided.

Category Oracle

Posted October 19, 2004 by

Dropping everything from an Oracle database

If you don’t want to create your database from scratch it’s sometimes useful to just delete all the objects from it.

Category Oracle

Posted November 13, 2003 by

Login to Oracle as sysdba in one command

Log into the database via sqlplus with sysdba priv’s with a single command. This can be setup with an alias, if you’d like

Category Oracle