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!

Register Log in
  • 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: palmela17
  • Order by date
  1. palmela17

    Date Difference in HOURS

    Step1: create or replace FUNCTION time_diff (x DATE, y DATE) RETURN varchar2 IS BEGIN return substr (LPAD (ABS (ROUND ( (x - y) * 24)) , 2, '0')||':'|| LPAD (ABS ( round( ( ( ( x - y ) * 24 ) - round ( ( x - y ) * 24 ) ) * 60 ) ) , 2, '0' ),1,5); END; Step2: select time_diff (x, y) from...
  2. palmela17

    tnsnames.ora

    try: SQL> connect username/password@jam also give hostname of the machine instead of ip address in the concerned files. best of luck

Part and Inventory Search

Back
Top