Re: NULLS FIRST (or LAST) in PL/SQL's Embedded SQL

From: Vladimir M. Zakharychev <bob_at_dpsp-yes.com>
Date: Tue, 29 Oct 2002 13:02:25 +0300
Message-ID: <aplmg3$fns$1@babylon.agtel.net>

Until 9i not all SQL constructions were supported in PL/SQL. I believe PL/SQL Developer's Guide documents what's supported. Since 9i, everything supported in SQL is also supported in PL/SQL. As a workaround for pre-9i versions, you need to use Native Dynamic SQL or DBMS_SQL for SQL syntax not available in PL/SQL.

-- 
Vladimir Zakharychev (bob@dpsp-yes.com)                http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.

Received on Tue Oct 29 2002 - 04:02:25 CST