Toad World® Forums

Save Oracle Query Results in Local Database - Data Point 3.5


#1

I would like to save the results of my Oracle query into the local database without using the Import feature of Data Point. Is that possible? If so, how?


#2

Right-click in the grid with your query results and select Sent To > Local Storage

Igor.


#3

Thanks for the reply. I should have also said to not by query results and select Sent To > Local Storage.

The goal is to code it.


#4

I’m sorry but I’m not sure I understand exactly what you mean. Can you please provide more details on your use case? Do you still want to save query results in Automation?

Igor.


#5

INSERT INTO LOCAL_STORAGE.MYDATABASE.MYTABLE ( RECORDNUM, COMPANYNAME)

SELECT RECORDNUM, COMPANYNAME

FROM ORACLE_SCHEMA.TABLE;

COMMIT;

Why won’t something like this work?


#6

I still don’t understand your use case. Editor is not supposed to work this way. But you can easily accomplish such task in Automation using Execute Script activity. See simple Automation script I’ve attached as an example. It queries Toad Sample Database and saves query result in LOCAL_STORAGE.test.test table.

Igor.
Script_1.tas (8.6 KB)


#7

Yes, I get this but was trying to see if it could be done another way. I guess not.

Why can’t you do an insert into on the Local Storage. I keep getting an error when I try this.


#8

Sorry, but the editor is not supposed to work this way.

Igor.