Just FYI - what Denny's solution is going to give you is the create
table statement for a specific table. What my solution is going to
give you is all the tables, columns and column types for all the
tables in your Oracle schema. With Denny's solution you'd have to
parse through the text to get the column definitions - but Denny's
would be very helpful if you needed to recreate the table in another
DB.
On 8/11/06, Lars Gronholt <[EMAIL PROTECTED]> wrote:
> Thanks all :)
>
> think either of those will sort my problem - will confirm on Monday!
>
> >This looks cool too (for oracle):
> >
> >select dbms_metadata.get_ddl('TABLE','THE_TABLE_NAME') from dual
> >:D
> >
> >On 8/11/06, Deanna Schneider <[EMAIL PROTECTED]> wrote:
> >>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:249563
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
