6 Replies Latest reply on Mar 30, 2015 11:36 AM by Billy~Verreynne

    How to extract Column Names from Dynamic SQL

    Shaz123

      Hello All,

       

      Is it possible to extract all the Column Names from a Dynamic Query ?

      In my case depending on User selections my Query will get changed (Column Number, Column Name and tables all can vary).

       

      So now is it possible to extract all the columns names from the dynamic query being generated ?

       

      I am using Oracle 11g (11.2.0.4)

       

      Thanks,

      Shaz