On Saturday, September 1, 2012 12:52:49 PM UTC-6, Akshay T wrote: > > Hi Everybody, > I have a requirement where I need to pass multiple > columns,their respective multiple data types and data type size through > parameters & create a test table using execute immediate statement.Can > anybody help me out with this? >
Who gave you this 'requirement'? It's ridiculous, at best, as there is no set limit for the number of columns this table could contain. This would require you to write a string parser in PL/SQL (not that difficult, really, but tedious) then use it to parse either one long string or three smaller strings to supply column names, column types and column sizes then use those values to create yet another string to send through execute immediate. Or it would require you to create types to store the column names, data types and sizes; you would then use those to create 'tables' of values you would query to return the strings to declare the column name, type and size so you could, again, create another dynamic statement to send to execute immediate. I really believe you need to suggest a different approach to this ... problem. David Fitzjarrell -- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en
