some doubts abt sql*plus and sqlworksheet

From: lkw <lkw_at_axiomatique.com>
Date: Tue, 7 Dec 1999 09:45:59 +0800
Message-ID: <82hp3m$87l$1@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 Mon Dec 06 1999 - 19:45:59 CST