Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>You might want to browse the <a href="http://download.oracle.com/docs/cd/B19306_01/server.102/b14220/toc.htm" rel="nofollow noreferrer">concept guide</a>, in particular the chapter about <a href="http://download.oracle.com/docs/cd/B19306_01/server.102/b14220/intro.htm#sthref266" rel="nofollow noreferrer">transactions</a>:</p> <blockquote> <p>A transaction is a logical unit of work that comprises one or more SQL statements run by a single user. [...] A transaction begins with the user's first executable SQL statement. A transaction ends when it is explicitly committed or rolled back by that user.</p> </blockquote> <p>You don't have to explicitely start a transaction, it is done automatically. You will have to specify the end of the transaction with a commit (or a rollback).</p> <p>The locking mechanism is a fundamental part of the DB, read about it in the chapter <a href="http://download.oracle.com/docs/cd/B19306_01/server.102/b14220/toc.htm" rel="nofollow noreferrer">Data Concurrency and Consistency</a>.</p> <hr> <h3>Regarding stored procedures</h3> <p>A stored procedure is a set of statements, they are executed in the same transaction as the calling session (*). Usually, transaction control (commit and rollback) belongs to the calling application. The calling app has a wider vision of the process (which may involve several stored procedures) and is therefore in a better position to determine if the data is in a consistent state. While you can commit in a stored procedure, it is not the norm.</p> <p>(*) except if the procedure is declared as an autonomous transaction, in which case the procedure is executed as an independent session (<em>thanks <a href="https://stackoverflow.com/users/272864/be-here-now">be here now</a>, now I see your point</em>).</p>
    singulars
    1. This table or related slice is empty.
    1. POHow do transactions within Oracle stored procedures work? Is there an implicit transaction?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USCommunity
    1. USVincent Malgrat
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POHow do transactions within Oracle stored procedures work? Is there an implicit transaction?
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COI guess you should also mention autonomous transactions here.
      singulars
      1. PO
      1. USbe here now
    2. COWhat happens if my stored procedure contains DML but no commit statement?
      singulars
      1. PO
      1. USAdamStevenson
    3. CO@AdamStevenson - if there is no commit in the procedure, the transaction will be ended by the session that calls it; any locks will be held until the session issues a commit (or rollback). If it doesn't ever explicitly do so then the session will implicitly perform a commit or rollback when it ends, depending on how it is terminated. The transaction may exist before the procedure call to. The procedure is one statement within the transaction.
      singulars
      1. PO
      1. USAlex Poole
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload