Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Difference between PreparedStatement and StoredProcedure ?
dean (deanbrown3d_at_yahoo.com) wrote:
: Dynamic SQL is the only simple way to get a sql statement to update or
: select from a changeable table name; in other words if you don't know
: at compile time if you will be selecting from table A instead of table
: B.
And if you put that in a stored procedure then it resides in the database where it is more easily code reviewed, tracked, and monitored. Received on Fri Mar 16 2007 - 19:14:23 CDT