Pro*C dynamic sql

Hi,

Here is my problem :

[Quoted] [Quoted] -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"
...

so, i need an sql statement that looks like :

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

how could I do that ?

Thanks a lot and have a nice day, Received on Tue Oct 26 1999 - 22:54:30 CEST