Search results for query: *

I am trying to join two tables, 3 million and 21 million rows on the secondary indices of both tables. I keep running out of spool space. Looking at the EXAPLIN, I see both tables go into spool before the join. Is there any way to force the smaller table into spool (and redistribute) while not...

Can the table name be passed into a stored procedure as a parameter? I have mutiple identical tables and am trying to read them using one stored procedure with the table name passed into the procedures as a parameter. thanks

Is it possible to call a Stored Procedues from a Macro and vice-versa ?

Thanks for the reply... What i am trying to do is create a SQL string using macros or stored procedures that incorporates paramter values as WHERE operators TABLE names and WHERE values. Once the SQL string is created and stored in a table, what facility can we use to execute it, without using...

Hi Can anyone give me some hints on how execute dynamic sql using SQL, Macros or Stored Procedures. I am generating SQL dynaically using SELECT, which I can store in a Table or pass as a string. But I have no idea how I can execute this SQL. thanks in advance Terafic!