Updating another table in the database using the RowId returned from database events

Handling the RowID returned as part of DB events through the listener:

class DCNDemoListener implements DatabaseChangeListener
    {
      DBChangeNotification demo;
      DCNDemoListener(DBChangeNotification dem)
      {
        demo = dem;
      }
      public void  onDatabaseChangeNotification(DatabaseChangeEvent e)
      {
        System.out.println(e.toString());
      }
    }

Example: The following are the values ​​returned from the database in DML operations

ROW: operation = UPDATE, ROWID = AAASjgAABAAAVAPAAA

Using the above ROWID, I want to update / insert into another table in the database. How should I do it? Do I need to first store the RowId in the cache or is there any other way to insert / update via queries

+4
source share
1 answer

Insert into another table using SQL:

2 (column1, column2,....) ( column1, column2,.... 1, rowid = retrived_rowid);

# rowids , - , / . ODP.net .

, rowid - .

0

Source: https://habr.com/ru/post/1569911/


All Articles