Search
Navigation
Top 60 Oracle Blogs
January 2007
Measuring cpu time in 10g
An addition to DBMS_UTILITY now enables us to measure CPU time easily. June 2004
Aggregating data with the returning clause
In 10g, data returned by the RETURNING clause can be aggregated. June 2004
Replacef
A function to simplify string building and debugging by replacing multiple placeholders from a collection of inputs. January 2007
Put_line
A simple wrapper to DBMS_OUTPUT.PUT_LINE to workaround the 255 byte limit (not needed from 10.2 onwards). April 2002
Call stack parser
A small package of functions for parsing the PL/SQL call stack. Includes an implementation of "WHOAMI" and "CALLER". September 2003
Replacef
A function to simplify string building and debugging by replacing multiple placeholders from a collection of inputs. January 2007
Is_number
Two common, simple and effective IS_NUMBER functions for SQL and PL/SQL. October 2006
Showplan utility
Simple SQL*Plus utilities to output the real execution plans used by running or cached SQL statements. Available for 9i Release 2 and 10g. October 2006
.png){kind=small}
TweetsPopular content
Today's:
Monthly archive
- January 2021 (36)
- December 2020 (45)
- November 2020 (58)
- October 2020 (45)
- September 2020 (38)
- August 2020 (54)
- July 2020 (38)
- June 2020 (50)
- May 2020 (50)
- April 2020 (64)
- March 2020 (62)
- February 2020 (59)
- January 2020 (90)
- December 2019 (48)
- November 2019 (47)
- October 2019 (64)
- September 2019 (40)
- August 2019 (42)
- July 2019 (45)
- June 2019 (37)
- May 2019 (43)
- April 2019 (49)
- March 2019 (61)
- February 2019 (25)
- January 2019 (35)
- December 2018 (39)
- November 2018 (55)
- October 2018 (75)
- September 2018 (38)
- August 2018 (89)
Recent comments
2 years 52 weeks ago
3 years 12 weeks ago
3 years 16 weeks ago
3 years 17 weeks ago
3 years 21 weeks ago
3 years 42 weeks ago
4 years 11 weeks ago
4 years 40 weeks ago
5 years 25 weeks ago
5 years 25 weeks ago