> As part of my porting from paradox to sql7, I need to port the code that
> creates several tempory tables, however, I'm not quite sure how to go about
> it, initially I thought I could just do:
>
> INSERT * INTO some_temp_table FROM some_table WHERE 1 = 0
in ORACLE you can
CREATE TABLE some_temp_table AS SELECT * FROM some_table WHERE 1=0;
Creates an identical table with no rows...
Not very nice for your application to thrash the Database definition though... You'd
be wanting
to keep things pretty static to better allow tweaking for performance....
--
Aaron Scott-Boddendijk
Jump Productions
(07) 838-3371 Voice
(07) 838-3372 Fax
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
