Home » RDBMS Server » Server Administration » Send query values to a table
Send query values to a table [message #374378] Fri, 08 June 2001 13:07 Go to next message
Srikanth Tutukuri
Messages: 3
Registered: June 2001
Junior Member
I am trying to send the results of a query into a table. The sql statement is as follws.

Select OL_ID, OL_NAME into BestSellers from Orders;

where BestSellers is the name of the temporary table. I have not created the table BestSellers before. Do we need to create a table before we can insert data into it or can we send the data from a query result into a temporary table. Can anyone help me on this. Any help is highly appreciated.

Report message to a moderator

Re: Send query values to a table [message #374450 is a reply to message #374378] Wed, 13 June 2001 05:45 Go to previous message
Arvind L
Messages: 27
Registered: June 2001
Junior Member
Here is how u can do it

create table BestSellers as select ol_id,ol_name from orders;

Report message to a moderator

Previous Topic: Limiting results from a select statement
Next Topic: Sequence error??
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 23 14:13:46 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.