skip to main
|
skip to sidebar
Grind
Wednesday, April 4, 2007
savepoints
Savepoints work something like this ...
dml a
savepoint a;
dml b
rollback to savepoint a;
commit;
dml a will be commited, but not dml b.
Unsure when a good time to use it, but it does work a treat.
Newer Post
Older Post
Home
Labels
architecture
(2)
bug
(1)
certification
(1)
character set
(2)
constaints
(1)
database links
(2)
dba
(2)
ddl
(1)
discoverer
(1)
Discussion
(3)
dml
(1)
dynamic sql
(1)
exceptions
(1)
execute immediate
(1)
faq
(1)
flashback
(2)
hardware
(2)
hints
(3)
keyboard
(2)
locks
(1)
mac
(2)
materialized views
(1)
partitions
(3)
performace
(3)
performance
(1)
plsql
(4)
recovery
(2)
redo
(1)
sizing
(1)
SQL
(8)
star
(1)
storage
(1)
table
(1)
tables
(1)
tablespaces
(2)
temp tablespace
(1)
transformation
(1)
tuning
(1)
UNDO
(4)
unix
(1)
upgrade
(1)
waits
(1)
wrapper
(1)
xplan
(2)
Blog Archive
▼
2007
(41)
►
September
(3)
►
August
(7)
►
June
(3)
►
May
(3)
▼
April
(12)
Tracing ...
XPLAN PLAN
dynamic sql - dml
blocking sessions
savepoints
truncate partitions
add new partitions
outer joins
execute immediate exceptions
adding quotes in dynamic sql
hiding CODE
database upgrade
►
March
(13)
me