Oracle Database Discussions

Dear All,

I have a select statement which I want to execute it thorugh VBA.

But in that Select there is a where condition, for where Condition it should pick the value from a coumn A.

Ex: I have an account holder table like CI_ACCT

I want to execute this through excel VBA, like

SSQL="Select * from CI_ACCT where ACCT_NUMBER = ....

in the above ACCT_NUMBER = should take the value from a sheet where account ids are placed in a coulmn.

If acct id existed then it should say "YES" in the next respective row, or else it should say "NO"

Hope you understand and helps me in this.

Regards,
Prasad