how can i avoid creating individual procedures which return data from different tables having differ
Hi,
thanks in advance for any kind of possible help.
i need a procedure which can pick table name at runtime, identify the structure and columns in that table and display the data for one particular row column wise.
like below i created a procedure to get it from one table, i want to make it generic as i have to run this on 350 tables and that to periodically. one master table will give me info on what all tables i need to fetch for one particular record. it will give me classname and then i can map that classname to couple of tables and then this generic procedure need to display me data from all these tables. the data will be in the form of 'Column-name=data'
0