Home » SQL & PL/SQL » SQL & PL/SQL » transfer sql results to temp table
transfer sql results to temp table [message #21122] Mon, 15 July 2002 01:07 Go to next message
meena
Messages: 36
Registered: December 2000
Member
How can I tranfer results of sql statement into temprory table. I could do this in informix as
'select * from table into temp a'
I need yr help in oracle.

thanks in advance

meena

Report message to a moderator

Re: transfer sql results to temp table [message #21123 is a reply to message #21122] Mon, 15 July 2002 01:25 Go to previous message
Rohit Mehrotra
Messages: 9
Registered: July 2002
Junior Member
You Can Use
create table temp as select * from table

Rohit

Report message to a moderator

Previous Topic: Viewing Index
Next Topic: Re: Error while connecting to oracle
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 18 15:32:15 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.