Re: static/dynamic/embedded SQL distinctions

From: HansF <News.Hans_at_telus.net>
Date: Mon, 22 Aug 2005 21:15:36 GMT
Message-Id: <pan.2005.08.22.21.19.41.395660@telus.net>

On Mon, 22 Aug 2005 12:02:02 -0700, jrefactors interested us by writing:

> I want to distinguish between static SQL, dynamic SQL, and embedded
> SQL, but couldn't find too much useful resources in the web.

LOL ... Did you check the Oracle documentation at http://docs.oracle.com

From the Oracle9i doc set:

Embedded SQL ... from the Concepts manual

http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10743/sqlplsql.htm#i18523

Dynamic SQL and Static SQL from the "Application Developer's Guide - Fundamentals" in the Chapter 6, titled "What Is Dynamic SQL?"

http://download-west.oracle.com/docs/cd/B14117_01/appdev.101/b10795/adfns_dy.htm#1006233

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** I no longer assist with top-posted newsgroup queries ***

Received on Mon Aug 22 2005 - 16:15:36 CDT