Re: Where is a temp tables DDL stored?

<mikharakiri_nospaum_at_yahoo.com> wrote in message news:1126904873.419638.129300_at_g47g2000cwa.googlegroups.com...
> To extend this idea further, I always wondered why the concept of DDL
> is needed at all? Consider
>
> -- create 100 tables TEST1...TEST100
> insert into user_tables -- or, more concervatively, tab$
> as select 'TEST'||rownum table_name, ...
> from dual connect by rownum < 100
>
> insert into user_tab_columns -- or, more concervatively, col$
> ...
>
> commit;
>

I think you only have to take the view that DDL is a convenient shorthand for something that could be, but doesn't need to be, entered in a tedious fashion.

If you've been to Chris Date's seminars on database fundamentals etc. he often makes the point about some 'linguistic' feature begin 'just a short hand for ...'

-- 
Regards

Jonathan Lewis

http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html
Cost Based Oracle - Volume 1: Fundamentals
On-shelf date: Nov 2005

http://www.jlcomp.demon.co.uk/faq/ind_faq.html
The Co-operative Oracle Users' FAQ

http://www.jlcomp.demon.co.uk/appearances.html
Public Appearances - schedule updated 4th Sept 2005