Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
Business Intelligence Foundation
Business Intelligence Standard Edition One
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Apr 17, 2012 8:35 AM by
How to insert the data into temp table
Mar 21, 2012 4:33 AM
Can any one please tell me the way that how to insert the data into a Temp table, is there a way in pl/sql?.
This content has been marked as final.
Show 1 reply
Re: How to insert the data into temp table
Apr 17, 2012 8:35 AM
in response to
you can do it with pl/sql developer,
firstly prepare your data with same column order at excel, select all data and right click, copy data.
select * from temp_table for update, F8
unlock the table,
select first cell, rigth click, paste data,