Re: Dynamic SQL

In article <4m2k1a$hpq_at_alijku06.edvz.uni-linz.ac.at>, andreas_at_riscy.edvz.uni-linz.ac.at (Andreas Hausleitner) writes:
|> Hi Oracle(SQL)-Profs,
|>
|> is there a way to create dynamic SQL-Statements. I want to do a select on
|> a table where the 'WHERE' condition is created according to some user
|> input, i. e. that the user can select how the list will be sorted, how it
|> will be grouped, which attributes should be listed in the report ...

Dynamic SQL is available in many different Oracle products. If you are using the precompilers, there are 4 different dynamic SQL methods. From PL/SQL, you can use the DBMS_SQL package. OCI is completely dynamic from the beginning, since you have to construct your SQL statements anyway.

Depending on the tool you are using to create your report, you can use different methods.

|>
|> Thanks for any help,
|>
|> Andreas
|>
|>
|>
|> ----------------------------------------------------------------------
|> Andreas Hausleitner
|> University of Linz / Austria
|> Computing Center
|> Department for Supercomputing FAX : +43 732 2468-688
|> Altenberger Str. 69 Tel.: +43 732 2468-203
|> A-4040 LINZ email: hausleitner_at_edvz.uni-linz.ac.at
|> ----------------------------------------------------------------------
 

-- 
Scott Urman
"The opinions expressed here are my own, and are not necessarily that of
 Oracle Corporation"