Re: How to get the ddl of a table in forms?

On 21 Jan 2006 02:17:34 -0800, "mentor1936" <mentor1936_at_hotmail.com> wrote:

>
>I appreciated the way you forward your information to me.
>But we would rather go with the SQL/data dictionary views that will
>also be worked with previous versions like 8i.
>Instead of using DBMS_METADATA is there other technique available for
>getting the ddl of any table in a schema.
>
>Also how should I populate the ddl of a table on forms screen after
>pressing the ddl button?
>Could some one send me a little piece of form's code in order to
>achieve what I am wanting on form's screen?
>
>
>John

Sorry to say so, but I think you are wasting your time. There are already so many packages available (both commercial and free) that do include schema browers, that developing yet another one is probably more expensive than buying such a package. And as the structure of the dictionary is readily available in both the database AND the documentation, you can't expect from a volunteer forum that we are going to do your work.

--
Sybrand Bakker, Senior Oracle DBA