Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: nadeu26
- Order by date
-
How to select date range from two tables
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...- nadeu26
- Post #27
- Forum: Oracle: All versions
-
Time Diff Between 2 Columns
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...- nadeu26
- Post #5
- Forum: Oracle: All versions
-
Can you make a function in a procedure pl/sql??
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...- nadeu26
- Post #8
- Forum: Oracle: All versions
-
SQL Output
HI you can type before you run your select :break on customer_id.- nadeu26
- Post #4
- Forum: Oracle: All versions
