Oracle SQL Developer 1.1 New Features
Monday, July 31st, 2006
Sue mentioned two SQL Developer 1.1 new features today. 1) Sort on column headers, available on any grid of data. 2) Display a single record on a form layout. Cool.
Archive for July, 2006
links for 2006-07-28
Friday, July 28th, 2006
Bugle
A collection of search queries which can help identify software security bugs in source code available on the web
(tags: google security code bug)
[…]
When The Combination of an Oracle Sequence and a PLS_INTEGER is Deadly
Thursday, July 27th, 2006
The following is a true story. We had our Oracle MRP system down for a couple of days because of a simple, yet hidden bug that went unnoticed for years until it hit us couple of days ago (somehow the image of a terrorist cell comes to mind).
In Oracle Applications (11.03) there is a table […]
How to find where an error was raised in PL/SQL
Tuesday, July 25th, 2006
To eliminate errors in your Oracle PL/SQL programs, it is very important to find the line number on which the error had occurred. The question is how to find that line number.
Before Oracle Database 10g Release 1, the only way to know the line number is to let the exception go unhandled in your PL/SQL […]
links for 2006-07-21
Friday, July 21st, 2006
Oracle Utilities
Oracle-supplied utilities and home-grown scripts by Dave Moore
(tags: oracle utility script)
[…]
Search Oracle Documentation Google Style
Thursday, July 20th, 2006
Last month, Oracle removed the authentication requirement from its documentation libraries. Since then, OTN membership is no longer required for accessing the Oracle documentation.
Yesterday, Justin announced that a new way for searching the documentation has just gone live.
For example, to see the new Oracle Docs search in action, here is the search result for “merge”.
Check […]
Oracle Trace Analyzer is TKPROF on Steroids
Tuesday, July 18th, 2006
When you generate a raw Oracle SQL Trace file you are faced with the arduous task of analyzing this trace file. Of course, TKPROF has always been there to help you with this analysis. This post is not about TKPROF, it is about another, lesser known, utility called Trace Analyzer, that is everything TKPROF is […]
Get that new Oracle Job
Sunday, July 16th, 2006
Get that new Oracle Job is the latest blog added to OraNA.
Fiona Brown, the blog author and an ex-Oracle consultant, describes her blog as a one that “focuses on all you need to get that new Oracle job. It includes tips, advise and useful links”.
Fiona will be using her blog to discuss the topic of […]
links for 2006-07-14
Friday, July 14th, 2006
0-DAY - SIMPLE SQL INJECTION
A SQL injection screencast
(tags: sql security screencast hacking)
[…]
Bring your old posts to life
Thursday, July 13th, 2006
By using the following two plugins, I was able to increase the page views on my blog by almost fifty percent. If you have a WordPress blog and don’t use these two plugins, you’re missing on features that can make your blog more useful and help your readers find your old posts a lot easier.
Ultimate […]
links for 2006-07-28
Friday, July 28th, 2006
Bugle A collection of search queries which can help identify software security bugs in source code available on the web (tags: google security code bug) […]
When The Combination of an Oracle Sequence and a PLS_INTEGER is Deadly
Thursday, July 27th, 2006
The following is a true story. We had our Oracle MRP system down for a couple of days because of a simple, yet hidden bug that went unnoticed for years until it hit us couple of days ago (somehow the image of a terrorist cell comes to mind).
In Oracle Applications (11.03) there is a table […]
How to find where an error was raised in PL/SQL
Tuesday, July 25th, 2006
To eliminate errors in your Oracle PL/SQL programs, it is very important to find the line number on which the error had occurred. The question is how to find that line number.
Before Oracle Database 10g Release 1, the only way to know the line number is to let the exception go unhandled in your PL/SQL […]
links for 2006-07-21
Friday, July 21st, 2006
Oracle Utilities Oracle-supplied utilities and home-grown scripts by Dave Moore (tags: oracle utility script) […]
Search Oracle Documentation Google Style
Thursday, July 20th, 2006
Last month, Oracle removed the authentication requirement from its documentation libraries. Since then, OTN membership is no longer required for accessing the Oracle documentation.
Yesterday, Justin announced that a new way for searching the documentation has just gone live.
For example, to see the new Oracle Docs search in action, here is the search result for “merge”.
Check […]
Oracle Trace Analyzer is TKPROF on Steroids
Tuesday, July 18th, 2006
When you generate a raw Oracle SQL Trace file you are faced with the arduous task of analyzing this trace file. Of course, TKPROF has always been there to help you with this analysis. This post is not about TKPROF, it is about another, lesser known, utility called Trace Analyzer, that is everything TKPROF is […]
Get that new Oracle Job
Sunday, July 16th, 2006
Get that new Oracle Job is the latest blog added to OraNA.
Fiona Brown, the blog author and an ex-Oracle consultant, describes her blog as a one that “focuses on all you need to get that new Oracle job. It includes tips, advise and useful links”.
Fiona will be using her blog to discuss the topic of […]
links for 2006-07-14
Friday, July 14th, 2006
0-DAY - SIMPLE SQL INJECTION A SQL injection screencast (tags: sql security screencast hacking) […]
Bring your old posts to life
Thursday, July 13th, 2006
By using the following two plugins, I was able to increase the page views on my blog by almost fifty percent. If you have a WordPress blog and don’t use these two plugins, you’re missing on features that can make your blog more useful and help your readers find your old posts a lot easier.
Ultimate […]
