static void Main(string[] args)
{
        // Open the connection
        OracleConnection connection = new OracleConnection
                ("Server = Ora; User Id = Scott; Password = tiger;");
        connection.Open();
            
        // Create the Select command retrieving all data from the Dept table.
        OracleCommand selectCommand = new OracleCommand("select * from dept", connection);

        // Create an OracleDependency object and set it to track the result set returned by selectCommand.
        OracleDependency dependency = new OracleDependency(selectCommand);
        
        // Setting object-based change notification registration
        dependency.QueryBasedNotification = false;

        // When the IsNotifiedOnce property is true, only the first change 
        // of the traced result set will generate a notification.
        // Otherwise, notifications will be sent on each change 
        // during the selectCommand.Notification.Timeout period.
        selectCommand.Notification.IsNotifiedOnce = true;
        // Specifies whether notifications will contain information on rows changed.
        selectCommand.Notification.RowLevelDetails = true;

        // Set the event handler to the OnChange event.
        dependency.OnChange += new OnChangeEventHandler(OnDeptChange);
                        
        // When the select command is executed at the first time, a notification 
        // on changes of the corresponding result set is registered on the server.
        selectCommand.ExecuteReader();

        // Set and execute an insert command. The Dept table data will be changed, 
        // and a notification will be sent, causing the OnChange event of the 'dependency' object.
        OracleCommand insertCommand = new OracleCommand
                ("insert into dept values (100, 'New department', 'Some location')", connection);
        insertCommand.ExecuteNonQuery();

        // Pause the current thread to process the event.
        Thread.Sleep(10000);

}

// A simple event handler to handle the OnChange event.
// Prints the change notification details.
static void OnDeptChange(Object sender, OracleNotificationEventArgs args)
{
        DataTable dt = args.Details;

        Console.WriteLine("The following database objects were changed:");
        foreach (string resource in args.ResourceNames)
                Console.WriteLine(resource);

        Console.WriteLine("\n Details:");
        Console.Write(new string('*', 80));
        for (int rows = 0; rows < dt.Rows.Count; rows++)
        {
                Console.WriteLine("Resource name: " + dt.Rows[rows].ItemArray[0]);
                string type = Enum.GetName(typeof(OracleNotificationInfo), dt.Rows[rows].ItemArray[1]);
                Console.WriteLine("Change type: " + type);
                Console.Write(new string('*', 80));
        }
}