Hi ,
I think it's about the number of objects
in 'all_objects'. allthough it dosen't make any sense because of the stmt. 'where min_date+(rownum-1) <= max_date'
I tried the same query with the same data , it retreived 6238 records, from 18-jun-03 until 15-jul-20
SQL> select count(*) from...
there's one left parethesis missing at first line
select floor ( ((date1-date2)*24*60*60)/3600)||'HOURS'||floor((((date1-date2)*24*60*60) -
floor(((date1-date2)*24*60*60)/3600)*3600)/60)||'MINUTES'||round((((date1-date2)*24*60*60) -
floor(((date1-date2)*24*60*60)/3600)*3600...
SQL> SET SERVEROUTPUT ON
SQL> DECLARE
2 FUNCTION POS (I_POS IN NUMBER) RETURN NUMBER IS
3 BEGIN
4 RETURN I_POS *300;
5 END;
6 BEGIN
7 dbms_output.put_line(POS(&N));
8 END;
9 /
Enter value for n: 4.32
old 7: dbms_output.put_line(POS(&N));
new 7...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.