2017–what grabbed your attention

2 comments

1. 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?

   https://technology.amis.nl/2006/05/24/dynamic-sql-pivoting-stealing-antons-thunder/

   Reply

2. 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.