(Agust Egilsson) Following best practices, Oracle releases PL/SQL and Java application-programming interfaces (APIs) well before there is a point-and-click tool or builder available taking advantage of a newly released API. This practice enables developers to incorporate new functionality into their

(Humphrey Cheung) Your company’s cleaning staff could be illegally moonlighting as your Oracle database administrator. Alexander Kornbrust, founder and CEO of Red Database Security, says hackers could easily exploit vulnerabilities in Oracle database and gain administrator access. Speaking at the De

(Steve Callan) Finally, after countless hours of scouring the Internet, you have come across a job posting for a junior Oracle DBA position, which includes the words you have been waiting for all this time: 0-2 years experience (zero being the operative word or number here). Armed with your fresh, j

(Sam R. Alapati) In the first three chapters, I set the stage for working with Oracle. It’s time now to learn about the fundamental structures of Oracle Database 10g. Oracle uses a set of logical structures called data blocks, extents, segments, and tablespaces as its building blocks. Oracle’s physi

(René Nyffenegger) Reading a trace file is usually a three step process. First, the trace file is created with an SQL statement such as alter session set sql_trace=true. Then, the name of the trace file along with the directory that stores it, is located. Finally, the trace file is opened in an edit

This tutorial teaches you –how to use Views in Queries along with Restrictions on DML operations for Views. –how to update a join View along with rules for updatable join views. –how to use DML Statements on Join Views –how to Update Views that Involve Outer Joins

(Jaromir D.B. Nemec) I first read about this feature from Jonathan Gennicks newsletter. The syntax used there was a “beta version”; instead of ANSI approved “PARTITION BY” a “WITHIN GROUP” clause was used. But on the first view it was clear: this is a great “gap filling” feature.

(Jim Czuprynski) Oracle 10g Release 2 (10gR2) has improved significantly the methodology for tracking performance metrics within the database. This article – the last in this series – demonstrates how to implement adaptive thresholds and use their metrics to effectively detect significant performanc

(MrNajeeb) We all know that a good application is that one which the user can use easily, simply and have his jobs done quickly, I thought it will be great to have all this done by one tool and small code using a DataGrid.

(Noel Yuhanna) A lesser-known but powerful application development tool that comes freely bundled with an Oracle DBMS is Oracle Application Express. Over the past year, the adoption of Oracle Application Express has increased twofold mainly because it is easy to use, saves money when consolidating s