[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Re: Temporary Table Creation

Tara,

On Sybase or MS_SQL you can use the following:

create table ##tablename
(col1  etc....

insert into ##tablename
select etc...

or insert into ##tablename
   values ($val1, #val2, &val3 etc...)

Or create it by:

select col1, col2,...
into   ##tablename
from   table1, table2, etc...

In Oracle there is no such thing as a temptable as I
understand.

Arjan

--- Tara K <tkurtz999@HOTMAIL.COM> wrote:

<HR>
<html><DIV>
<P>I need to create a 'temporary table' that is a
clone of an existing PS table. I would appreciate any
input at all..</P>
<P>(Just a touch dusty on the SQR skills!)</P>
<P>Thanks in advance!</P>
<P>Tara Kurtz,&nbsp; HR-ease</P></DIV><br
clear=all><hr>Get more from the Web.  FREE MSN
Explorer download : <a
href="http://explorer.msn.com">http://explorer.msn.com</a><br></p></html>


__________________________________________________
Do You Yahoo!?
Yahoo! Shopping - Thousands of Stores. Millions of Products.
http://shopping.yahoo.com/