Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
roger wong
Ranch Hand
Posts: 32
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
In oracle

1. Is select one kind of DML?

2. Does a select start a transaction?
 
Janeice DelVecchio
Saloon Keeper
Posts: 1809
12
Eclipse IDE Java Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
1. yes

2. a transaction is everything that occurs between commits... so I guess, sometimes.
 
Deepak Mahalingam
Greenhorn
Posts: 12
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic