Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: How to get the ddl of a table in forms?

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

From: HansF <News.Hans_at_telus.net>
Date: Sun, 22 Jan 2006 14:05:40 GMT
Message-ID: <pan.2006.01.22.14.05.39.947899@telus.net>


On Sun, 22 Jan 2006 02:01:12 -0800, mentor1936 wrote:

> Hi Hans,
>
> If you want that some one can get benifit from your code, please resend
> it completely.
> I will appreaciate if you re send it completely rather than post it
> incompletely.
>
> John

Actually, the intended benefit was to give you an idea of how the SQL statement could be formed, if you insist on doing it the hard way. I assumed you were a good-enough coder to take it from that basic example.

I had no plan to fully reproduce something that I stopped using over 15 years, and 5 versions, ago. There are better solutions available these days (such as DBMS_METADATA.get_ddl) for those who are willing to maintain current versions of the database.

As others said - why reinvent the wheel?

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** Top posting [replies] guarantees I won't respond. ***
Received on Sun Jan 22 2006 - 08:05:40 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US