Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Terafic
  • Content: Threads
  • Order by date
  1. Terafic

    Joining on secondary indices

    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...
  2. Terafic

    Dynamic Table names in Stored Procedures?

    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
  3. Terafic

    Calling Stored Procedues from a Macro

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

    Executing Dynamic SQL

    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!

Part and Inventory Search

Back
Top