(Msg. 1) Posted: Fri Dec 12, 2008 2:13 am
Post subject: What will happen after commit statement ? Archived from groups: comp>databases>oracle>misc (more info?)
if I call a plsql is there a commit? - Hi, excuse me for the simplicity of the question but I'm a beginner.. I have seen somethings similar in this forum. If i have a procedure plsql that calls an other one like this: CREATE OR REPLACE PROCEDURE p1 as begin p2(); p3(); .... end; After p...
Oracle Auto Commit during transaction. - Hi, If I send an Update like this: UPDATE MyTable SET Field1 = value WHERE Field2 = value2; there is a way that Oracle make a commit every X records updated? Note: this update can alter thousand of records at the same time. Thank you.
in statement not working - Hi, I am seeing an odd problem with part of a stored procedure I am building. Values are passed via and Access interface. All values are processed properly except for one little annoying thing for which our DBAs have no explanation. I pass a string from....
what wrong with this statement? - when i input the following statement error occur: select pubid,pubname,TITLE from (publisher natural inner join journal) group by (pubid) having count(pubid)>1; error: select pubid,pubname,TITLE from (publisher natural inner join journal) group...
Help with SQL statement - Can anyone help me with the following ? I have a table players, with columns: - player_name - player_village - village_population - X-coordinate - Y-coordinate A player can have 1 or more villages (it's for a computer game). Each village has a..
You can post new topics in this forum You can reply to topics in this forum You can edit your posts in this forum You can delete your posts in this forum You can vote in polls in this forum
FAQ
Search
Profile
Private Messages
Log in
