| sweta |
Posted: Jan 19, 2008 02:53:24 AM |
Total Post: 2
Joined: Jul, 2007
|
hi,
MY Query is 'Merge is DML statement or not?'.If yes than after Executing merge statement when i perform rollback my data is not discarded.It is still there in the table.So what is the problem?pls reply me as soon as possible. |
|
|
 Mohammed Taj |
| Posted: Jan 19, 2008 03:03:58 AM |  |
|
Total Post: 746
Joined: Jul, 2007
|
Yes, Merge is DML statement.
you know what is merge command do?
merge is combination of "insert" or "update" DML command.
so whenever without commit when you perform rollback data must rollback.
DML statement is
1. select
2. insert
3. update
4. delete
5. merge
|
|
|
|
|
| jayesh |
| Posted: Jan 19, 2008 09:33:02 AM | |
|
Total Post: 60
Joined: Jan, 2008
|
yes merge is dml statement and this command is introduced with oracle 9i.
|
|
|
|
|
| shantanu |
| Posted: Jan 19, 2008 12:39:17 PM | |
|
Total Post: 42
Joined: May, 2007
|
Yes it is a DML command and often called UPSERT command for its functionality. Other DML commands are INSERT, UPDATE, DELETE.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
