Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Sql Statement doesn't return rows

FormsSep 17 2007 — edited Sep 17 2007
with t as
(select 123.444 n from dual union all
select 123.44 from dual union all
select 123.4 from dual union all
select 123 from dual)
select n from t
where round (n, 1) = n

When I execute the abboe statement, I get Sql Statement doesn't return rows.

Can anyone please advice. I am using Oracle9i Enterprise Edition Release 9.2.0.4.0 .

Thanks,
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 15 2007
Added on Sep 17 2007
1 comment
978 views