I am working on an application that created by oracle forms(6i). I try to use timer in one of my forms every thing was fine during testing and I move my form to production.
I have column (CLOB data type) with XML data in it. How to read data from that column and insert into myTable? This XML represent one report divided by Location. Every location has analytic data and t
Like any programming language you can use a simple =+ to append to a variable string, but how do you do that within an Oracle PlSql block?
I want to get the results in ref_cursor, but I am not able to do that. Please suggest me how to get the results in ref_cursor using Execute immediate
Any have any good code for converting a IPv6 address string into an integer?Converting IPv4 seems to be fairly easy, with the one format.However, IPv6 has several different formats to show an address:
Initial data: have a paragraph of query which in the sake of reasoning can be simplified to next SELECT MAX((CASE
I\'m trying to debug a SELECT inside a procedure, and I\'m trying to this using a anonymous block. I would like that SQL Developer simply return the last SELECT statement, but I get the error:
I have a TIME dimension in my DW and I want to add a camp to fill in with the season of the year. I want to do something like this:
I\'m trying to obtain the full path of the server\'s desktop using a plsql script. running the script on the server itself.
I am trying to use the lag function so I can compare one column to the last without using a cursor. However the column I need to compare against has to go by an alias as I am using 3 unions).
加载中,请稍侯......