1 Reply Latest reply: Nov 22, 2012 6:06 AM by Majda Janezic RSS

    ORACLE 11g Connection by Macro

    Paolo Rena

      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.