Re: Setting bind variables or defines from applications?

From: William Robertson <william.robertson_at_bigfoot.com>
Date: 22 Apr 2006 08:30:22 -0700
Message-ID: <1145719822.396312.194310@u72g2000cwu.googlegroups.com>

dean wrote:
> So basically there is no good way to do it, based on our current
> architecture. We will continue to provide (or create at rt) multiple
> stored procs that differ solely on a table name.
> ...

How about creating a view as

SELECT 't1' AS thing_type, col1, col2, col3 FROM table1 UNION ALL
SELECT 't2' AS thing_type, col1, col2, col3 FROM table2 UNION ALL
SELECT 't3' AS thing_type, col1, col2, col3 FROM table3

Then query the view as if it were a partitioned table, using "WHERE thing_type = [literal]". Received on Sat Apr 22 2006 - 10:30:22 CDT