If you use default settings, and you are not committing manually, you are getting your own personal, private view - until you exit!
Despite the fact that this has caught almost everybody at least once, it's a rather obscure "gotcha" to find on any FAQ or blog. Until now :)
In the SQL\*Plus User's Guide, see "Saving Changes to the Database Automatically", and "Exit" in the SQL*Plus Command Reference. Even then, it's easy to miss.
For version 9, get the doc [here](http://download-west.oracle.com/docs/cd/B10501\_01/server.920/a90842.pdf).
Eddie Awad
· 4 years ago
It's these little things that bite you sometimes, and there are a lot of them.
All Comments
If you use default settings, and you are not committing manually, you are getting your own personal, private view - until you exit!
Despite the fact that this has caught almost everybody at least once, it's a rather obscure "gotcha" to find on any FAQ or blog. Until now :)
In the SQL\*Plus User's Guide, see "Saving Changes to the Database Automatically", and "Exit" in the SQL*Plus Command Reference. Even then, it's easy to miss.
For version 9, get the doc [here](http://download-west.oracle.com/docs/cd/B10501\_01/server.920/a90842.pdf).