I need to figure how much time passed between 2 times. For example: (14:00:00 - 13:15:00) * 24 = .75 I need this to later on convert KW开发者_Python百科 to KWh, but that\'s not the point.
I have a java stored procedure that takes in a clob representing a chunk of javascript and mins it.The structure of the function calling the JSP is as follows:
We are using utl_file in Oracle 10g to copy a blob from a table row to a file on the file system and when we call utl_file.fclose() it takes a long time. It\'s a 10mb file, not very big, and it takes
I didn\'t find much data about the internals of PL/Scope. I\'d like to use it to analyze identifiers in PL/SQL scripts. Does it work only on Oracle 11g instances? Can I reference its dlls to use it o
I am trying to write in a file stored in c:\\ drive named vin1.txt and getting this error .Please suggest!
i hav开发者_如何学运维e two selects a & b and i join them like: select * from ( select n.id_b || \',\' || s.id_b ids, n.name, s.surname
I am trying to use a strong ref cur with dynamic sql statment but it is giving out an error,but when i use weak cursor it works,Please explain what is the reason and please
I found out that Oracle Database 10g and 11g treat the following PL/SQL block differently (I am using scott schema for convenience):
I defined a list of strings, which contains different country codes (like USA,CHINA,HK,JPN, etc.). How can I check, if an input variable is the country code in the list?
we have application where database contains large parts of business logic in triggers, with a update subsequently firing triggers on several other tables. I want to refactor the mess and wanted to sta
加载中,请稍侯......