skip to main
|
skip to sidebar
Oracle Database Administration
Database Tips
Thursday, October 25, 2007
Find out last sql statement issued from the same session
select sql_text from v$sql
where hash_value = ( select prev_hash_value from v$session
where sid = (select sid from v$mystat where rownum = 1))
/
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
Oracle Database Topics
load test data
MV
Oracle Scripts
RAC
RMAN
SQL
Blog Archive
►
2024
(2)
►
September
(2)
►
2020
(3)
►
December
(1)
►
November
(1)
►
September
(1)
►
2019
(1)
►
May
(1)
►
2017
(1)
►
October
(1)
►
2016
(2)
►
August
(2)
►
2015
(4)
►
July
(2)
►
February
(1)
►
January
(1)
►
2014
(5)
►
August
(1)
►
February
(2)
►
January
(2)
►
2013
(28)
►
October
(4)
►
September
(4)
►
August
(2)
►
July
(1)
►
June
(1)
►
May
(3)
►
April
(2)
►
March
(6)
►
February
(4)
►
January
(1)
►
2012
(4)
►
July
(2)
►
March
(1)
►
January
(1)
►
2011
(14)
►
September
(3)
►
July
(2)
►
June
(3)
►
May
(3)
►
April
(1)
►
March
(1)
►
February
(1)
►
2010
(18)
►
November
(3)
►
October
(2)
►
September
(3)
►
August
(4)
►
May
(2)
►
April
(2)
►
March
(1)
►
January
(1)
►
2009
(17)
►
November
(2)
►
October
(4)
►
September
(7)
►
July
(2)
►
April
(1)
►
February
(1)
►
2008
(7)
►
November
(1)
►
September
(1)
►
June
(2)
►
May
(1)
►
February
(1)
►
January
(1)
▼
2007
(23)
►
December
(5)
►
November
(3)
▼
October
(4)
Update rows using replace in SQL*Plus
Manual installation of Oracle Text 10g
CPIO Command
Find out last sql statement issued from the same s...
►
September
(10)
►
July
(1)
About Me
rkhanna
View my complete profile
No comments:
Post a Comment