ZDNet

Choose a method for passing arrays to the Oracle Provider for OLEDB

The Oracle Provider for OLEDB has some nice methods for retrieving an array from a PL/SQL procedure call and making it appear to be a Recordset object. It's a bit trickier to go in the other direction ...
Ars Technica

[SQL] Handle SELECT INTO #TempTable In IF/ELSE Statement

Well, if you happen to be using Sql Server you can do that sort of thing in T-Sql. In Oracle, you can also accomplish the same thing using pl/sql. Either way i'd do it in a stored ...
InfoWorld

Compuware unveils debugging tool for Oracle

COMPUWARE ON TUESDAY announced availability of DevPartnerDB Debugger for Oracle for Microsoft Visual Studio .Net, a development tool for debugging Oracle stored procedures from within the Microsoft ...
SiliconIndia

Oracle PL SQL Tutorial

PL/SQL stands for Procedural Language extension of SQL. PL/SQL is a combination of SQL along with the procedural features of programming languages. It was developed by Oracle Corporation in the early ...
ZDNet

Oracle architectural design tips

As an Oracle performance-tuning expert, I frequently visit Oracle shops to improve system performance. Although Oracle offers many performance-tuning techniques, you can’t tune away a poor database ...
TechRepublic

Determine when to use stored procedures vs. SQL in the code

Determine when to use stored procedures vs. SQL in the code Your email has been sent Tony Patton discusses the merits of stored procedures versus placing SQL directly in the code. Find out which one ...