Re: Dynamic sql (built on the fly)

From: AleX <ashteren_at_netwiz.net>
Date: Wed, 30 Jun 1999 09:45:30 -0700
Message-ID: <377A49AA.5DA8A289@netwiz.net>

huh wrote:

> Jonathan,
>
> Would you mind sending (or pointing)
> us a simple example?
>
> BTW: Do I need to install dbms_sql package
> or is it ensured that this package is installed?
> How can I find what packages have already
> been installed on our server?

well, you can query dba_objects for packages... or if you have a graphical tool (aka schema manager) check the schema for user sys

>
> What about the V$xxx objects? Do I need to run
> any scripts or is it ensured that these views
> are installed? How can I find what is installed?
>
> --
> Thank you for keeping >anti-spam< habit:
> not including my address in your reply.
Received on Wed Jun 30 1999 - 11:45:30 CDT