Home >Database >Mysql Tutorial >Oracle批量update和delete

Oracle批量update和delete

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
2016-06-07 16:55:291200browse

下面一段示例说明了Oracle的基本操作insert、update、delete产生的undo的大小和记录条数。 --insert操作无论是1条或者多条,一

下面一段示例说明了Oracle的基本操作insert、update、delete产生的undo的大小和记录条数。

  --insert操作无论是1条或者多条,一次产生一条undo数据

  SQL> create table a (b number, c varchar2(30));

  Table created

  SQL> insert into a values (1,'zhangsan');

  1 row inserted

  SQL>

  SQL> select used_ublk,used_urec from v$session s, v$transaction t

  2 where s.audsid=sys_context('userenv', 'sessionid') and s.taddr = t.addr;

  USED_UBLK USED_UREC

  ---------- ----------

  1 1

  SQL> insert into a select rownum,rownum from dual connect by rownum

  50 rows inserted

  SQL>

  SQL> select used_ublk,used_urec from v$session s, v$transaction t

  2 where s.audsid=sys_context('userenv', 'sessionid') and s.taddr = t.addr;

  USED_UBLK USED_UREC

  ---------- ----------

linux

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn