| getting missing numbers in report [message #315432] |
Mon, 21 April 2008 08:33  |
RAY_HT
Messages: 155
Registered: May 2005
Location: Giza
|
Senior Member |
|
|
dear All
i need to retrive missing vouchers in report.
i wrote this statment and it's working in sqlplus
with
minmax as ( SELECT 1 minval, 1 maxval FROM dual ),
numbers as (
select minval+level-1 num
from minmax
connect by level <= maxval-minval+1
select num
into x from numbers
minus
select shipv_no from shipping_voucher
order by 1;
i need to put it in report , how can i do that
when i add it as sql-group or ref-cursor it is not allowed
any advice ??
|
|
|
|
| Re: getting missing numbers in report [message #315463 is a reply to message #315432] |
Mon, 21 April 2008 10:00  |
skooman
Messages: 913
Registered: March 2005
Location: Netherlands
|
Senior Member |
|
|
I'm not sure what you mean. You say:
| Quote: | when i add it as sql-group or ref-cursor it is not allowed
|
I can't see any ref cursor in the code you posted.
Furthermore, using "into" implies PL/SQL whereas the rest of your code is SQL. And you use
although you don't define numbers earlier on, you do define a "minmax" with as query, but you don't refer to it further on.
Could you perhaps try to explain in words what you are trying to accomplish?
|
|
|
|
| Re: getting missing numbers in report [message #315465 is a reply to message #315432] |
Mon, 21 April 2008 10:06 |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
Would you mind to read the OraFAQ Forum Guide and learn how to PROPERLY ask a question?
Missing vouchers? What vouchers? Where can they be found? Where are CREATE TABLE along with sample INSERT INTO statements? When do you plan to format your code (using the [code] tags)?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
