I have a procedure in a package create or replace package MyPack type MyArr is table of varchar2(30) index by pls_integer;
I have the test.sql script which is called from unix shell script test.sh.Problem is in test.sql script when i have a exception i do the rollback and exit. When it comes to shell script it will have e
I have simultaneous request to a particular row in a table andPL/SQL statement is used to update the table by reading the data from master row in 开发者_开发知识库the same table and update the current
I\'m trying to perform something in Oracle/PLSQL where I want to select some stuff from the db via a cursor and store it into an array of rows, which I can later process. Searched on google but to no
How do I create PL/SQL function whi开发者_如何学JAVAch waits for update on some row for specified timeout and then returns.
hello i\'m porting a wbsphere application to tomcat, i have to work on two database on the same server and i\'ve integrated tomcat with atomikos transactionessential. This is my first project with jta
In PL/SQL program i have used set pagesize 40; so according to the above line the page break happens afte开发者_如何学编程r 40 lines.
We have times stored in an Oracle varchar(5) field. Times stored using HH24:MI (ie: 22:30, 10:15). How can we run a query that will increase or decrease these times by a certain amount?开发者_StackO
I need your help for handling the exception in my package.I dont know exactly where to write the exception. I am including the function. The problem is ACTY_COUNT is of varchar type .So if user enter
Oracle 10g is the db. The below query fails when extracting the date. SELECTTO_CHAR ( TO_DATE ( SUBSTR (file_name , INSTR (file_name , \'_\', -1, 2)+ 2, 8), \'YYYYMMDD\'), \'开发者_JS百科DD-MM-YYYY
加载中,请稍侯......