Re: How to iterate through database tables

2009-02-03 Thread Douglas Wilson
On Tue, Feb 3, 2009 at 5:47 AM, Deviloper wrote: > > But some bad guy could showed up and force the poor developer not to use > perl-vars in SQL-Statements for security reasons. > > Is ist possible to use tablenames like normal bind-variables? > Is there a better way to solve this problem? Using

Re: How to iterate through database tables

2009-02-03 Thread Scott Smith
I think his issue is getting list to the server side without concatenating strings. You can't use bind variables as table names or column names. You may be able to write a stored procedure which takes a table name as a variable, does the string concatenation on the server side, and uses Orac

Re: How to iterate through database tables

2009-02-03 Thread pDale
On Tue, Feb 3, 2009 at 8:47 AM, Deviloper wrote: > Hello there! > > lets assume that one has a list of tables @db_tables. (For Example one per > Month) > Lets assume one wants to find some data in the tables. (For Example sold > Items.) > > select sales from $db_tables[0]; # gives all sold items