Syntax Question
From: Dereck L. Dietz <dietzdl_at_ameritech.net>
Date: Sat, 9 Feb 2008 13:12:18 -0500
Message-ID: <O3mrj.8386$Rg1.2605@nlpi068.nbdc.sbc.com>
Date: Sat, 9 Feb 2008 13:12:18 -0500
Message-ID: <O3mrj.8386$Rg1.2605@nlpi068.nbdc.sbc.com>
Oracle 10.2.0.3.0
Windows Server 2003
Sorry for this question but our database is currently unavailable so I can't try it myself.
Is the following syntax valid for loading a nested table in bulk from a table function?
SELECT *
BULK COLLECT INTO nt_claims_rec
FROM TABLE(get_claims() );
Thanks. Received on Sat Feb 09 2008 - 12:12:18 CST