USE DATABASE Questions

1

oracle calculated item
hi ihave alist of variables some of them calculated from others i recieved them from certain source in certain date and i have alist of indicatores which are calculated from the variables (for the same date,& source) but every indicator has diffrent equation & the user need to modify the equation f needed and define [...]

Answer Question   |  January 14, 2008  1:12 PM
Database Management Systems, DB2, Oracle, Oracle 6i, USE DATABASE
asked by:
115 pts.

USE DATABASE
How can I write a stored procedure which can switch to new databases using something like “use DBASENAME”, but without knowing the dbase names before the procedure runs? The example below was my attempt to do this using SP_EXECUTESQL. The reason for this is so that I can call stored procedures within my stored procedure [...]

Answer Question   |  December 2, 2007  1:40 PM
Database, SQL, Stored Procedures, USE DATABASE
asked by:
0 pts.

1