ORACLE 11g Connection by Macro

rnepla83 — Fri, 12 Aug 2011 09:25:44 GMT

HI TO ALL....

There are two bookmarks called Set1 and Set2 and i would like to STORE the SetAnalysis result IN AN ORACLE DB 11g.

For example:

- If you wanna visualize the CONSUMER_ID have bought FIAT GRANDE PUNTO press the button 'Set 1'.

Will be {16,17,18,19,20,21,22,23,24,25,26,32,33,34,35}

- If you wanna visualize the CONSUMER_ID have bought FIAT PANDA MY 03 press the button 'Set 2'.

Will be {1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20}

So, in the table called RESULT there are the consumer_id result of the intersection of two Sets {16,17,18,19,20}

Can You build a MACRO in VBA for CONNECT AND STORE the INFORMATION in an ORACLE DB 11g version?

I would like to store the table result called 'RESULT'. So, I would like to invoke the macro called 'store_in_ORACLE'

from the button on the dashboard called 'STORE RESULT IN ORACLE DB'.

Thanks a lot, Paolo.

PS: there is an attachment file.

Re: ORACLE 11g Connection by Macro

Thu, 22 Nov 2012 11:06:27 GMT

Hello!

Did you maybe find a solution?

Br,