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 ...
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 ...
Houston Chronicle

Procedures for Embedding HTML in PL/SQL

A clear delegation of work exists between the HTML and PL/SQL in your company's Web pages: PL/SQL code fetches and manipulates data from SQL databases, and HTML code formats the results of PL/SQL ...
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 ...
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 ...
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 ...