Re: PL/SQL Questions

[Quoted] What happens to be your Oracle version? Until 9.2, not every valid SQL statement was also valid in PL/SQL. Subqueries as columns (select (select ...) alias ...) is one such case for 8i. You need to use Dynamic SQL (EXECUTE IMMEDIATE) or DBMS_SQL for valid SQL statements PL/SQL engine can't swallow, or you need to construct a DML statement, which will be valid in both SQL and PL/SQL. With 9.2 this is no longer a problem - PL/SQL 9.2 understands everything SQL does as they use the same engine.

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