Featured Article(s) Increasing Performance Using the Oracle 11g PL/SQL Function Result Cache Oracle 11g has a new performance enhancing feature called the PL/SQL Function Result Cache. This feature retains the results of a PL/SQL function call in memory enhancing performance by not continually re-executing the function. This article describes the new PL/SQL Function Result Cache Not Sure What You Need […]
Other News
Oracle/PLSQL: Cursor Attributes
While dealing with cursors, you may need to determine the status of your cursor. The following is a list of the cursor attributes that you can use.
SOA Governance Brings Order to Services Chaos
(Rikki Kirzner) The growing popularity and advantages of Service-Oriented-Architecture (SOA) implementations are often accompanied by a continuous struggle to manage, and not lose control over, an ever increasing number of services and other reusable assets. As a result, organizations are plagued wi
Build an Entity Resolver to Redirect a SAX Parser
(Leonard Anghel) This tip shows you how to bulid an entity resolver to “change” a public indentifier into a system identifier. The idea is to override the resolveEntity method of the EntityResolver interface:
Working with binary large objects (BLOBs)
(Amr Ashush) You can define a BLOB as a large photo, document, audio, etc., saved in binary formats that you want to save in a database.
Manage MySQL remotely with phpMyAdmin
(Federico Kereki) Odds are, if you design Web sites with a database back end, you’ve worked with MySQL. You can manage this database from the command line, but it’s not very user-friendly. Using the graphical tool phpMyAdmin helps, but not all Web hosting providers offer it or allow you to install i
Using the Built-In Time Dimension and Time Intelligence in SQL Server Analysis
(Ray Barley) We are building an Analysis Services cube and trying to understand how to create a time dimension and take advantage of the built-in time intelligence features that provide many useful calculations such as period-to-date, period-over-period growth, etc. Can you provide a detailed expla
The Origins of SYSDUMMYU
(Troy Coleman) Sometimes developers need to retrieve data from a DB2 special register or invoke a DB2 built-in function against a program host variable. However, DB2 requires that a table be referenced in order to process these statements.
Exam 70-443 Practice Test from uCertify.com
(Gregory A. Larsen) Employers these days are saying there is a lack of good candidates for available job openings. How employers rate employees is different from company to company, but one thing for sure is they are looking at the degrees and certificates a potential candidate holds. One way to dem
Generating Atom Feed from SQL Data
(Ivan Pepelnjak) Atom technology (not the one discussed by nuclear physicists) was created in 2003 to address the shortcomings of the then-prevalent RDF Site Summary (RSS; also known as Really Simple Syndication) family of incompatible formats. It gained widespread adoption when Google decided to us