database, oracle, login, sysdba, command Oracle - Tech-Recipes

Oracle tutorials

Oracle: Using the AFTER INSERT and AFTER UPDATE triggers

contributed by Vishwanath Dalvi on December 12, 2011 under Oracle

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 occurred and an ‘AFTER UPDATE’ trigger after an update event has occurred.

Oracle: How to Create a Copy of Table Data

contributed by Vishwanath Dalvi on December 7, 2011 under Oracle

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.

Oracle: How to Create an Auto Increment Field Using Sequence

contributed by Vishwanath Dalvi on December 5, 2011 under Oracle

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.

Dropping everything from an Oracle database

contributed by u02sgb on October 19, 2004 under Oracle

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

Login to Oracle as sysdba in one command

contributed by jshcenck on November 13, 2003 under Oracle

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