prepared statment question
Posted by:
joewaster
Date: June 21, 2005 01:06PM
PREPARE stmt_name FROM "SELECT name FROM Country WHERE code = ?";
is there a way to assign an array of values to code?
for example, in the above query is i set the ? to 5 it will find the name with code 5
but what if i have to find the name of unknown number of parameters oc the same
column
code = 5 or code = 6 or code = 7
can prepared statement do something like this?
Subject
Written By
Posted
prepared statment question
June 21, 2005 01:06PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.