Home » SQL & PL/SQL » SQL & PL/SQL » downloading records
downloading records [message #303843] Mon, 03 March 2008 00:36 Go to next message
user71408
Messages: 585
Registered: November 2007
Location: NE
Senior Member

Hi All,
Is there any query to download the reocrds from one table to other table. If there is any query pls send me the solution for this.I just want to use query only..Not Pl/sql block.
So can any one pls send me the solution for this...

Thanks in advance..

Re: downloading records [message #303848 is a reply to message #303843] Mon, 03 March 2008 00:42 Go to previous messageGo to next message
dhananjay
Messages: 635
Registered: March 2002
Location: Mumbai
Senior Member
by downloading you mean to say copy data from one to another table.
#1. are the table located in the same schema,
then just use
insert into dest_table....select <col_names> from source_table...


#2. different database,
then create a dblink and same step as #1.

regards,
Re: downloading records [message #303850 is a reply to message #303848] Mon, 03 March 2008 00:45 Go to previous messageGo to next message
user71408
Messages: 585
Registered: November 2007
Location: NE
Senior Member

not like that...
I have 3 tables 'A","B',"C". I have uploaded the reocrds from A to B. Now I want to download the Uploaded records from B to C.
all r in the same schema.. how to write a query for this...

Thank u
Re: downloading records [message #303852 is a reply to message #303843] Mon, 03 March 2008 00:47 Go to previous messageGo to next message
mshrkshl
Messages: 247
Registered: September 2006
Location: New Delhi
Senior Member
please post what you have done including your tables.


regards,
Re: downloading records [message #303856 is a reply to message #303850] Mon, 03 March 2008 00:52 Go to previous messageGo to next message
dhananjay
Messages: 635
Registered: March 2002
Location: Mumbai
Senior Member
Quote:
I have 3 tables 'A","B',"C". I have uploaded the reocrds from A to B. Now I want to download the Uploaded records from B to C.
all r in the same schema.. how to write a query for this...

did you read my post(#1).by the way i don't understand if, finally you have to load the data to table C then, why A-->B-->C?why not A-->C?And if you could load the data from A to B then ,what is the problem you are facing while loading from B to C?

regards,

[Updated on: Mon, 03 March 2008 00:54]

Report message to a moderator

Re: downloading records [message #303878 is a reply to message #303856] Mon, 03 March 2008 01:50 Go to previous messageGo to next message
user71408
Messages: 585
Registered: November 2007
Location: NE
Senior Member

In any way I want to upload the data i.e either from A->B or
B->C. So could u please give me the solution for this.
Re: downloading records [message #303879 is a reply to message #303878] Mon, 03 March 2008 01:54 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Why not "insert select"?

Regards
Michel
Re: downloading records [message #303962 is a reply to message #303843] Mon, 03 March 2008 07:56 Go to previous message
joy_division
Messages: 4643
Registered: February 2005
Location: East Coast USA
Senior Member
Why do you keep mentioning downloading and uploading? What program or procedure have you done to accomplish this task?
Previous Topic: Converting from number to words
Next Topic: stopping Oracle seeing a field name as a function
Goto Forum:
  


Current Time: Thu Dec 08 20:11:02 CST 2016

Total time taken to generate the page: 0.17758 seconds