Von professionellen Übersetzern, Unternehmen, Websites und kostenlos verfügbaren Übersetzungsdatenbanken.
a transaction is defined as all the changes on a given connection since the last commit / rollback, autocommit was turned off or when the connection was established.
この関数はoracleのトランザクションをコミットします。トランザクショ ンは、直近のコミット/ロールバック、またはオートコミットがオフになっ た時点、または接続が確立された時点から指定した接続に加えられた全 ての変更として定義されます。
?php print "html pre"; $db = ""; $c1 = ocilogon("scott" ,"tiger",$db); $c2 = ocilogon("scott" ,"tiger",$db); function create_table($conn) {$stmt = ociparse($conn ,"create table scott.hallo (test varchar2(64))"); ociexecute($stmt); echo $conn. "created table\n\n";} function drop_table($conn) {$stmt = ociparse($conn ,"drop table scott.hallo"); ociexecute($stmt); echo $conn." dropped table\n\n";} function insert_data($conn) {$stmt = ociparse($conn ,"insert into scott.hallo values('$conn '_bar_ _bar_' '_bar_ _bar_ to_char(sysdate ,'dd-mon-yy hh24:mi:ss'))"); ociexecute($stmt,oci_default); echo $conn. "inserted hallo\n\n";} function delete_data($conn) {$stmt = ociparse($conn ,"delete from scott.hallo"); ociexecute($stmt,oci_default); echo $conn." deleted hallo\n\n";} function commit($conn) {ocicommit($conn); echo $conn. "committed\n\n";} function rollback($conn) {ocirollback($conn); echo $conn." rollback\n\n";} function select_data($conn) {$stmt = ociparse($conn ,"select * from scott.hallo"); ociexecute($stmt,oci_default); echo $conn ."----selecting\n\n"; while (ocifetch($stmt)) echo $conn. "".ociresult($stmt ,"test")." \n\n"; echo $conn ."----done\n\n";} create_table($c1); insert_data($c1); / / insert a row using c1 insert_data($c2); / / insert a row using c2 select_data($c1); / / results of both inserts are returned select_data($c2); rollback($c1); / / rollback using c1 select_data($c1); / / both inserts have been rolled back select_data($c2); insert_data($c2); / / insert a row using c2 commit($c2); / / commit using c2 select_data($c1); / / result of c2 insert is returned delete_data($c1); / / delete all rows in table using c1 select_data($c1); / / no rows returned select_data($c2); / / no rows returned commit($c1); / / commit using c1 select_data($c1); / / no rows returned select_data($c2); / / no rows returned drop_table($c1); print "/ pre / html";?
例 1ocilogon