wood burning stoves 2.0*
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: 1659
    
  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?
 
Similar Threads
Database Autocommit
understanding load
Getting lock on DB from two different JVM
does developer bother setting Isolation Levels
Scenario where one should use Read committed or Serializable as Isolation level?