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

mentor1936 wrote: 
Hi,



This is my first posting to this forum.

I am using forms 6i and 9i database for testing purpose on windows O/S.


I want to develop a small form application for getting the structure of
any table in a particular schema.



My Application will be based on the following scenario:

In order to achieve what I am wanting, I am planning to use two display
screens in a form's block with a ddl button.

    For Example After populating all the tables of Scott's schema in
screen no: 1, I highlight the Scott's EMP table then I click the ddl
button in order to get the ddl of that table in a screen no: 2.



In this regard I like to ask the following:

1.      What is the sql/technique for getting the ddl of any table in
the database?


dbms_metadata.get_ddl('TABLE', <table_name>);

You can find working demos in Morgan's Library at www.psoug.org.

2.      How should the table name of a particular schema display in a
screen no: 1 so when the control goes to any table in a screen no: 1,
the ddl of that table will be displayed after pressing the ddl button?


That's up to you.

3.      What technique I adopt and how should I implement it in forms
in order to display the ddl of a table in forms screen no: 2 when I
click the ddl Button?


Again ... up to you. Make a decision.

Please give me your ideas and suggestion in order to accomplish what I
am wanting.

Related codes will also be helpful form me.

John 

You'll find the DBMS_METADATA code in Morgan's Library. How you choose
to implement the displays is your class project ... not ours.
--
Daniel A. Morgan
http://www.psoug.org
damorgan@xxxxxxxxxxxxxxxx
(replace x with u to respond)
.