Dynamic SQL fetch sql Statements from tables

Database

Dynamic SQL fetch sql Statements from tables

Hi

I came across a issue where i have to use dynamic SQL for fetching rows from a table which contains sql statements for corresponding process denoted by number.
Each number corresponds to an SQL str procs or statements that is for a specific function.

Could anyone give me details on how to start with the procedure or resources for this topic or some examples.

maya

1 REPLY
Enthusiast

Re: Dynamic SQL fetch sql Statements from tables

Provide more info please.

Give a table/tables with some example records and write the goal You want to achieve

cheers