Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: sql query problem HELP
Sybrand Bakker <postbus_at_sybrandb.demon.nl> wrote:
>One statement is, IMO, not possible, as there is no relationship between the
>2 resultsets.
>One sql script is definitely possible.
>Most people here don't like to do other peoples homework, and your question
>definitely is of the homework type.
>
>
>
>Regards,
>Sybrand Bakker, Senior Oracle DBA
There is something in your signature that makes me think you'll know the answer ;-)
There is a procedure X with an argument yyy which is a condition in a where clause. Also, there is a table Z with a column named yyy. What will happen in the case below? (I was not sure about that, so I renamed argument yyy to yyy1). Would it have the same effect as if there is no "where" clause, or what? Tnx.
Procedure x (var yyy varchar2) begin select * from database where yyy=yyy; end;
-- Vucko p.s. Sorry about bad English. p.p.s. This was not my homework. ;-)Received on Mon Sep 03 2001 - 15:46:31 CDT