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 gkittelson 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: *

  1. TravisLee

    Dynamic dblink

    I am trying to run the following statement, which attempts to dynamically pass the dblink name, in a procedure: select nvl(max(report_key), 0) into v_max_report_key from cym_reports||v_sn; Where v_sn is initialized above to be '@dblink' using the statement - select '@'||CDS_SERVICE_NAME...
  2. TravisLee

    convert decimal to hex

    I found a package that does the conversion. Thanks.
  3. TravisLee

    convert decimal to hex

    Does anyone know of way to convert decimal to hex? I need to convert an ip address stored as a decimal to hex, break the hex into octets and convert each octet back into a decimal. Thanks
  4. TravisLee

    PL/SQL problem

    Thanks eveyone. The 8.1.5 bug was it.
  5. TravisLee

    PL/SQL problem

    Does anyone know why this query successfully returns the correct data in SQL Plus, but when I attempt to compile it in a function it blows up on the order by? 1 select dst_count, ip_dst 2 from (select count(ip_dst) as dst_count,ip_dst 3 from iphdr 4 group by ip_dst 5 order by...

Part and Inventory Search

Back
Top