Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Is there any easy way to make use of this function?
On 26 May 2006 11:21:10 -0700, dennis.pong_at_gmail.com wrote:
>So, my question is, how would I go about using this function above
>incorporating with create table (+ nested select statements, which I
>didn't paste here) ?
Just do it
>Is it true that I am not allowed to call user-defined functions with a
>select statement ?
This is NOT true. On older version you may need to use PRAGMAs in your function, but this doesn't apply to 9i and higher. This is one of the reasons why you *always* need to specify your exact version when posting.
-- Sybrand Bakker, Senior Oracle DBAReceived on Fri May 26 2006 - 15:00:25 CDT