row is not inserting into table

Question

The table is present in oracle database, I am updating that table with one record. It's executing and when I type select * from that table it's showing that record.

But the problem is when I commit the changes. The table is showing nothing - I am not seeing anythng inside table, it's showing 0 records.

Can you please help me?

insert into recon values(1,'sri',-1,'20090806');

after this if i write

select * from recon;

It's showing that record but after commit it's showing nothing. There is no trigger for that table.

its not a view.

Answer 1

My guess would be that the transaction was not committed properly, initially I thought that it was because of nested transactions (I work in SQLServer) but could be basically because of not properly committed transaction

Answer 2

If you are the admin, Check if other users are logged into the the database and are using that table, unlock the user from that table/database.

Answer 3

It's a global temporary table, after commiting it is emptied.

There are two kind of temp tables, 1 after commit emptied, 2.after ending session emptied.