Community

An example of dynamic SQL in PL/SQL

By Prashant Gijare – Problem: In a product table, the answer for each product inquiry is stored in a separate column.

Solution: I created a temporary table with one column (prodname) where all product names are individual rows. The product name fetched from this table is fed to dynamic SQL. T

Read More - Register for Free Membership

Tags: