RE: QUERY PROBLEM

> -----Original Message-----
> From: Harvinder Singh [mailto:Harvinder.Singh_at_MetraTech.com]
>
> We need to write a query like this:
>
> declare
> dd number;
> begin
> select * from t_acc where id_acc=dd;
> end;
> /

Get the result back to where? What kind of client application? Is the query returning only one row or multiple rows?

Here are two ways of doing it in SQL*Plus:

SQL> define def_var = "X"
SQL> select * from dual where dummy = '&def_var' ; ancien   1 : select * from dual where dummy = '&def_var' nouveau   1 : select * from dual where dummy = 'X'

D
-
X

SQL> variable bind_var varchar2 (1)
SQL> execute :bind_var := 'X'

Procédure PL/SQL terminée avec succès.

SQL> select * from dual where dummy = :bind_var ;

D
-
X Received on Fri Oct 19 2001 - 14:17:14 CDT