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
- July 2020 (11)
- June 2020 (49)
- 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)
- July 2018 (58)
- June 2018 (61)
- May 2018 (66)
- April 2018 (40)
- March 2018 (61)
- February 2018 (67)
Recent comments
2 years 24 weeks ago
2 years 36 weeks ago
2 years 40 weeks ago
2 years 41 weeks ago
2 years 46 weeks ago
3 years 15 weeks ago
3 years 35 weeks ago
4 years 12 weeks ago
4 years 49 weeks ago
4 years 49 weeks ago