Re: Pro*C dynamic sql

Hi,

[Quoted] I am the original poster of the previosu message. I am sorry, please do not respond to the email address of my original message. For some unknown reason, my preferences weren't set with the correct pop account. please anwser to this address instead : legarema_at_uqtr.uquebec.ca

Thanks and sorry again,

-oracle 8
-Pro*C 2.2

Hi,

Here is my problem :

-the program should be able to list a table from a criteria
given by the user (at runtime).

The criteria could be :

"name=smith"
"street=broadway"
...

[Quoted] so, i need an sql statement that looks like :

select name, street, ... from mytable where criteria;

how could I do that ?

[Quoted] Thanks a lot and have a nice day, Received on Tue Oct 26 1999 - 23:00:42 CEST