Oracle SQL Developer 1.1 New Features
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.
Filed in Oracle with 6 Comments | Tags: sql-developerlinks for 2006-07-28
-
A collection of search queries which can help identify software security bugs in source code available on the web
-
This package provides fully fledged FTP client functionality from inside PL/SQL
-
Technical whitepaper
-
A nice (and free) screen capture utility
When The Combination of an Oracle Sequence and a PLS_INTEGER is Deadly
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 that stores forecast records (mrp_forecast_dates). In this table there is the column transaction_id that gets populated from a sequence (mrp_forecast_dates_s).
When the current value of the sequence exceeded the number 2,147,483,647 the MRP concurrent programs started to fail with an “ORA-01426: numeric overflow” error. After a lot of research, and an Oracle Service Request, we discovered what the problem was and what was special about the number 2,147,483,647.
Let me reproduce the problem in the following example: (more…)
Filed in Oracle, Tips with 3 Comments | Tags: datatype, pl/sql, sequenceHow to find where an error was raised in PL/SQL
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 code.
In Oracle Database 10g Release 1 and above, you can take advantage of the new function DBMS_UTILITY.FORMAT_ERROR_BACKTRACE. This new function returns a formatted string that displays a stack of programs and line numbers leading back to the line on which the error was originally raised.
links for 2006-07-21
-
Oracle-supplied utilities and home-grown scripts by Dave Moore
-
A list of Oracle default ports for different Oracle products
-
Facts about numbers
-
This page contains the 252 allowed entities in HTML 4 and XHTML 1.0
Oracle Trace Analyzer is TKPROF on Steroids
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 and more. (more…)
Filed in Oracle, Tips with 8 Comments | Tags: statspack, tkprof, trace-analyzer, tuningGet that new Oracle Job
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 finding a new Oracle based position.
The blog is new, but there are already a couple of nice posts:
Filed in Oracle with 5 Comments | Tags: blog, joblinks for 2006-07-14
-
A SQL injection screencast
-
A collection of Oracle articles from DatabaseJournal.com
-
Create high-quality PDF documents from any printable file type
-
A collection of Oracle tutorials from Lewis Cunningham
Bring your old posts to life
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 Tag Warrior
This plugin allows you to add tags either through the Write Post page, on posts using an AJAXy box, or in posts using a special syntax. From the Write Post page, you can also get suggestions for tags using Tagyu or Yahoo.
You can see this plugin in action here on my blog. At the end of each post there is a list of tags that describe what the post is about and also links to posts that share all or some tags with the current post. Clicking on a tag lists all posts tagged with the selected tag. For example, click here to view a list of all posts tagged with sql. There is also the tag archives page that lists all tags in a tag cloud format. Moreover, the tag search page is a quick and easy way to list posts for a tag or a group of tags.
Landing Sites
This plugin checks if a visitor has come from a search engine (like Google or Yahoo for example), and uses their search terms to display links to related content on your blog. This plugin also allows you to display targeted and relevant advertisements only for visitors coming from search engines.
To see it in action, click here to search Google for oracle firefox extension. On the Google search results page click the link to this blog. When you land on the relevant post, you will see the welcome message with the related links and ad on the top of the post. The welcome message is only shown when a visitor reaches the blog from search engines.
Combined with quality content, the two plugins will definitely increase the page views on your blog and help visitors find posts that otherwise are buried deep in your blog archives.
Download:
Filed in WordPress with Comments Off | Tags: plugin, WordPress
