Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.vmunix.org!news2.euro.net!zen.net.uk!demorgan.zen.co.uk!194.72.9.35.MISMATCH!news-peer1!btnet-feed5!btnet!news.btopenworld.com!not-for-mail From: "Jonathan Lewis" Newsgroups: comp.databases.oracle.server Subject: Re: Where is a temp tables DDL stored? Date: Sat, 17 Sep 2005 06:59:36 +0000 (UTC) Organization: BT Openworld Lines: 49 Message-ID: References: <1126705798.012355.18740@g49g2000cwa.googlegroups.com> <1126712247.735544@yasure> <1126716382.588532.161250@g43g2000cwa.googlegroups.com> <1126723858.554220.198110@g43g2000cwa.googlegroups.com> <1126729301.961774.27730@o13g2000cwo.googlegroups.com> <3ot6mnF7lievU1@individual.net> <1126904873.419638.129300@g47g2000cwa.googlegroups.com> NNTP-Posting-Host: host86-130-246-220.range86-130.btcentralplus.com X-Trace: nwrdmz02.dmz.ncs.ea.ibs-infra.bt.com 1126940376 6180 86.130.246.220 (17 Sep 2005 06:59:36 GMT) X-Complaints-To: news-complaints@lists.btinternet.com NNTP-Posting-Date: Sat, 17 Sep 2005 06:59:36 +0000 (UTC) X-RFC2646: Format=Flowed; Original X-Newsreader: Microsoft Outlook Express 6.00.2900.2180 X-MSMail-Priority: Normal X-Priority: 3 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:251734 wrote in message news:1126904873.419638.129300@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