Tag Archives | Database

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 occurred and an ‘AFTER UPDATE’ trigger after an update event has occurred. Let’s see an example for ‘AFTER INSERT’ trigger. Syntax: CREATE or REPLACE […]

Read full story Comments { 0 }

List of Handy MySQL Commands

List of Handy MySQL Commands

Read full story Comments { 0 }

How to Delete Existing WordPress Post Revisions Stored/Saved

How to Delete Existing WordPress Post Revisions Stored Saved

Read full story Comments { 0 }

How to Migrate Data from one Field to Database Table in MySQL

How to Migrate Data from one Field to Database Table in MySQL

Read full story Comments { 0 }

How to Migrate MySQL Data from MySQL to Microsoft SQL 2008

How to Migrate MySQL Data from MySQL to Microsoft SQL 2008

Read full story Comments { 0 }

How to Create an ODBC Connection in Windows x64 Bit

How to Create an ODBC Connection in Windows x64 Bit

Read full story Comments { 0 }

How to Get Current Users and Applications Connected to Microsoft SQL Server

Get Current Users and Applications Connected to Microsoft SQL Server

Read full story Comments { 0 }