I have code stored procedure that returns sysrefcursor as the OUT 开发者_运维知识库parameter.
I have a requirement to execute a perl script from a PL/SQL script. The perl script executes various system com开发者_如何学Pythonmands, and this piece is already developed. The piece I am having trou
create or replace procedure summery_report_date_range (start_date in varchar2 , end_date in varchar2)
I want to drop all users who have \'WIN\' at the start of their name (for example, \'WIN$开发者_Go百科DOWS\'). Is it possible to write something like like the follownig?
If I do the following, everything is fine:开发者_开发问答 declare l_foo clob; begin select regexp_replace(
I am trying to get the non-nullable columns of a table thro开发者_StackOverflowugh a java code.... Can anyone help me?It is not completely clear what you are asking. Do you want to find out, from your
I\'m writing a procedure that reads some PL/SQL code from a repository and then verifies that each procedure/function has the appropriate documentation header. Giving the following PL/SQL code contain
I\'m trying to update a table based on the sum of values from another table.The process I want to follow is:
Right now I am using Oracle utility procedure, UTL_COMPRESS.LZ_COMPRESS(), to compress some data. But the problem is it compresses the thing using GZIP compatible format, which is not als开发者_如何学
I wrote a function to get a number of values in an Oracle view.As functions can\'t return more then one value, I have used an object (with a signature of 8 numbers).This works, but not fine...
加载中,请稍侯......