You Asked
--->We have one table in the 10 records there ,then update the salary column and insert one new record and
alter the new column.Then rollback keywords command use .Then what is the output ? How many rows are
retrieved.
and Connor said...
If you did an "alter table" you have done a commit.
All Oracle DDL does a commit before AND after the ddl is executed (so even the DDL fails, you have still done commit).
So if you
- started with 10
- updated 1
- added 1
- did "alter table add column"
- rollback
You will 11 rows *and* still have the new column
Is this answer out of date? If it is, please let us know via a Comment