Hi Stephane,
Review your logic. A row full of NULLs has no signification. If your statement is
embedded into either some PL/SQL code or a 3rd generation language, Oracle will
generate a 'no data found' error, and this is what you need to trap.
I want to run it in SQL, not in PL/SQL.
I Un
Attila,
Review your logic. A row full of NULLs has no signification. If your statement is
embedded into either some PL/SQL code or a 3rd generation language, Oracle will
generate a 'no data found' error, and this is what you need to trap.
For instance in PL/SQL
begin
select c1, c2,
Hi All,
I'm a new member on this list. I'm not too familiar with ORA, but I have some
experience in other RDBMS's.
I had run into the following problem.
My task is to write a query, which returns with an empty (full of NULLs) row, if the
condition is false.
I'm thinking in outer joins.
I made
Title: RE: outer join problem
Try inline views. They will solve your problem.
Lisa Koivu
"I can't believe I work here."
Fairfield Resorts, Inc.
954-935-4117
-Original Message-
From: Harvinder Singh [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, September 06,
Harvinder,
in this particular case, I don't see the need to perform multiple outer
joins.
why not change it to:
t_recur.id_prop = t_pl_map.id_pi_template(+) and
t_discount.id_prop = t_recur.id_prop and
t_aggregate.id_prop = t_recur.id_prop and
This allows the outer join to the t_pl_map table,
Why are you trying to join three different tables to values which may not
exists? Are those three tables related to each other outside of what you
show here? If not, and this statement worked, you would end up with a
matrix join between those three tables. Is that what you are looking for?
May be???:
select xyz from t1 a, t1 b, t1 c, t2 d, t3 e, t4 f where
d.id_prop = a.id_pi_template(+) and
e.id_prop = b.id_pi_template(+) and
f.id_prop = c.id_pi_template(+) and
a.rowid = b.rowid and a.row_id = c.rowid and ...
Jan Pruner
Dne ?t 6. zá?í 2001 19:26 jste napsal(a):
> Hi,
>
>
Hi,
In one of our queries a table is participating in 3 outer joins ..but oracle
only allows one outer join per table
how can we achieve to have more than 1 outer join for a particular table :
for example like :
t_recur.id_prop = t_pl_map.id_pi_template(+) and
t_discount.id_prop = t_pl_ma