(Bob Watkins) PL/SQL has a rich CASE functionality. The selector CASE statement lets you test the value of an expression (much as the DECODE function does), and it also lets you execute one or more statements for the first matching value. The searched CASE statement lets you test multiple expression

(Andrew Clarke) Over on the Pythian blog Babette Turner-Underwood discusses Oracle’s multitable insert syntax. She’s been using in on a data conversion project. The advantage of INSERT ALL is that it allows us to insert several different VALUES clauses in a single statement.

(Mamun Zaman) In this article we will mainly focus on basic database development using Oracle. We will learn how to create new tables, alter them, insert data into the database, update data, retrieve data, delete data and drop tables. We have lots to do, so let’s get started.

(JP Vijaykumar) 02:00 AM Boss: Reclaim every byte of free space from other tablespaces in the database/ server that are not 100% full and allocate to EMP_TBSP01 tablespace, which is 100% full.

(Michael McLaughlin) Managing secure access to Web pages and applications is a common problem. You want to enable those you trust to access data while preventing unauthorized ones from gaining access to it. In most cases, identity management is the solution to this problem.

(Eddie Awad) Oracle PL/SQL has a neat and little known feature called forward declaration. In this post I’m going to do a quick review of what forward declaration is, how it can be used and a situation in which forward declarations are absolutely required, mutual recursion.

(Laurent Schneider) I am data-modeling those days. Each table has it own description table (yes, it is Java). To keep it simple, FRUIT[id,description] and MEAT[id,description] (35 of them right now). There must be one table which contains all descriptions in it GLOBAL[type,id,description]. I wish

(Dimitar Madjarov) This article actually is an heir of my first article from this topic about programming with Oracle and C#. The first article is available for reading on next web address “Processing with C#, Oracle transactions and Oracle exceptions”. In my first article I describe an alternative

(MD) Multitable insert is a feature I’ve read about many times, but I’ve never taken the time to read up on it or play with the way this SQL statement works. I figure making a post about it will give me the reason I need to learn more about it.

(Terry Sutton) Many of us have been using Oracle’s Extended SQL Trace, also known as a 10046 trace, for years. An Extended SQL Trace can provide the most detailed information about exactly what an Oracle session is doing, including which SQL statements the session is executing, how many logical and