Learning is not a spectator sport

2 responses to “2017–what grabbed your attention”

1. 

   Arju Arafin

   December 24, 2017 at 4:30 pm

   hello,

   I have a question about the DYNAMIC SQL PIVOT.
   I want to use the following procedure of ANTON’s, but need to pass bind variable in run time like following.

   select * from table( pivot( ‘select col1, col2, col3 from tab1 join tab2 on tab1.id = tab2.id where tab1.col4 = :param1 and tab2.col5 = 0’));

   Can you please help?

   Dynamic SQL Pivoting – Stealing Anton’s Thunder

   Reply
2. 

   Iudith Mentzel

   December 30, 2017 at 10:31 pm

   Hello Arju,

   Just one idea, that maybe could work for you:

   Maybe you can define a context, containing the values of your bind variables, and then replace
   the bind variables reference by SYS_CONTEXT calls, with fix context variable names
   in the query that you pass to the PIVOT function.

   Best Regards,
   Iudith Mentzel

   Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.