Xref: alice comp.databases.oracle.tools:34562
Path: alice!news-feed.fnsi.net!newspump.monmouth.com!newspeer.monmouth.com!news.maxwell.syr.edu!sunqbc.risq.qc.ca!news.uquebec.ca!not-for-mail
From: longtin@uqtr.uquebec.ca
Newsgroups: comp.databases.oracle.tools
Subject: Pro*C dynamic sql
Date: Tue, 26 Oct 1999 16:54:30 -0400
Organization: =?iso-8859-1?Q?Universit=E9?= du 
 =?iso-8859-1?Q?Qu=E9bec=20=E0=20Trois=2DRivi=E8res?=
Lines: 23
Message-ID: <38161506.83383698@uqtr.uquebec.ca>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Mailer: Mozilla 4.7 [fr] (Win98; I)
X-Accept-Language: fr-CA,en-US

-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"
...

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,