GeeCON Prague 2014*
The moose likes Oracle/OAS and the fly likes Question: in oracle is select one kind of DML? & Does a select start a transaction? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "Question: in oracle is select one kind of DML? & Does a select start a transaction?" Watch "Question: in oracle is select one kind of DML? & Does a select start a transaction?" New topic
Author

Question: in oracle is select one kind of DML? & Does a select start a transaction?

roger wong
Ranch Hand

Joined: Oct 21, 2009
Posts: 31
In oracle

1. Is select one kind of DML?

2. Does a select start a transaction?
Janeice DelVecchio
Saloon Keeper

Joined: Sep 14, 2009
Posts: 1669
    
  11

1. yes

2. a transaction is everything that occurs between commits... so I guess, sometimes.


When you do things right, people won't be sure you've done anything at all.
Deepak Mahalingam
Greenhorn

Joined: Jul 09, 2010
Posts: 12
It depends on which tye of 'select' you are talking about.
If it is 'select * from ' then it is not a DML because it does not 'Modify' any data. But 'select .. into' format is considered a DML.
since it is not a transaction, you do not need a commit to get the results. We need not use a transaction commit when we use a select statement.
Hope that helps.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Question: in oracle is select one kind of DML? & Does a select start a transaction?