Cing Sian Dal

May 19, 2021

1 min read

oracle nodejs return empty rows

Check if your rows are already commited in your database.

Use the COMMIT statement to end your current transaction and make permanent all changes performed in the transaction. A transaction is a sequence of SQL statements that Oracle Database treats as a single unit. This statement also erases all savepoints in the transaction and releases transaction locks.

Until you commit a transaction:

  • You can see any changes you have made during the transaction by querying the modified tables, but other users cannot see the changes. After you commit the transaction, the changes are visible to other users’ statements that execute after the commit.
  • You can roll back (undo) any changes made during the transaction with the ROLLBACK statement (see ROLLBACK)

Read more at https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_4010.htm