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...
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
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...
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.