CODEWITHSUNDEEP
oracle-database
joelc
joelc

Reputation: 2751

Oracle 12c query results in sqlplus but not SQL Developer

I have a single instance called sp_admin with several tables. One of them is called 'tenant_api_user'. From sqlplus, I can select * from any of the tables, including tenant_api_user (or select count(*) etc) and the results are fine. However, when I run queries against this one specific table in SQL Developer, it always returns zero records.

When I run the select * from tenant_api_user; from SQL Developer, it returns 0 records instantly - no waiting. That same query from sqlplus returns the only record in the table. When I try to update a record that is visible from sqlplus, SQL Developer says 0 rows updated.

Has anyone experienced this kind of behavior before? It seems to be isolated to just this table. SQL Developer doesn't behave this way with any other table.

Upvotes: 0

Views: 1290

Answers (1)

MT0
MT0

Reputation: 167774

If you have entered the data in one session and you have not run a commit statement then you will not be able to see the data in another session until it has been committed.

Upvotes: 2

Related Questions