CODEWITHSUNDEEP
sqldatabaseoracle-databaseinsert
Suresh Rajagopal
Suresh Rajagopal

Reputation: 183

oracle sql developer tool - data not available after commit

Inserted data in the table. If I execute select query, I can see the data inserted. But once I execute commit, then execute select query on the same window, no record found.

It is looks strange. Don't know what is the issue.

Upvotes: 2

Views: 1210

Answers (1)

Suresh Rajagopal
Suresh Rajagopal

Reputation: 183

I found the reason. It is a Global Temporary Table, where the table is created as ON COMMIT DELETE ROWS.

Upvotes: 1

Related Questions