Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to get the ddl of any table on Forms Screen?

484461Jan 20 2006 — edited Jan 23 2006
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?
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?

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?

Please give me your ideas and suggestion in order to accomplish what I am wanting.
Related codes will also be helpful form me.

May GOD bring this year with full of happiness to those people who will assist me regarding my task.

John
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 20 2006
Added on Jan 20 2006
10 comments
1,068 views