- SQL*Plus comes along with default DDL/DML/DCL package with Oracle
products. While SqlWorkSheet come along with Enterprise Manager. Certain
functionality are not available with SqlPlus. Though it is handy tool than
SQL*Plus.
- You have to commit/rollback after each/bunch of transactions. If you
delete from the current session and try to see the record in table with same
session, you will not be able to see it. But, open other session and check
that record.
- If system is under Autocommit mode, will commit that record. SQL*Plus
will commits all transaction by default while exiting an application.
If system crashes, your transaction will resides in redo logs entries.
You have to apply it after reinitiate of instance.
"lkw" <lkw_at_axiomatique.com> wrote in message
news:82hp3m$87l$1_at_newton3.pacific.net.sg...
: hi everybody,
:
: hope that u all can help me to clear some doubts.
:
: 1.may i know what is the different between sql*plus and sqlworksheet? can
we
: just ignore one?
:
: 2.do we need to do 'commit' for the 'delete' statement to take effect? but
: weird thing happened is that i don do any commit after deleting a record
: from a table, the record still gone and i use select statement and can't
see
: the record inside the table.
:
: 3.if i do a insert statement without commit, and then i close sql*plus or
: sqlworksheet. what will happen? will the record being inserted? what if
the
: system crashes?
:
: thanks in advance!!
:
: lkw.
:
:
:
:
Received on Tue Dec 07 1999 - 11:51:50 CST
