i want to know how to select the table dynamically from a system tab and insert the values to a row of the selected table in a query or a procedure?
for example :
i want to insert the value to a table selected from tab
INSERT INTO (SELECT tname FROM TAB where tname='table name') VALUES('a');
ofcourse didnt work.
here i pass the tablename from frontend.
i want to select the table as i pass the parameter from front end and insert the value for the row in the selected table by passing parameter from front end.
please help me
Click Here to Expand Forum to Full Width