How to get the ddl of any table on Forms Screen?
484461Jan 20 2006 — edited Jan 23 2006Hi,
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