i am trying to insert some rows 开发者_如何学编程and update some rows inside a pl/sqlloop. howeverall i get to see is the pl/sql procedure is successfully completed.
I have some PL/SQL code that I think might have a memory leak. Everytime I run it it seems to run slower and slower than the time before, even though now I am decreasing the input size. The code that
I have an SQL script that connects to another database using \"create database link\", and copies some data.
what is the best solution to write a oracle package for record persistence? I\'ve always written something like this:
I currently need to make a table that holds the unique sets of attributes for another table. That is, I have a table that looks like this:
I have several different packages, one for each logical part of my application.Some packages are getting huge but I would like to keep all the procedures/functi开发者_StackOverflow社区ons grouped in s
Could you please let me kno开发者_JAVA技巧w how to call a shell script from PLSQL program?You have a couple of options available:
I have a date and I\'d like to print the offset from that date. 开发者_StackOverflowI can do this:
okay, I am beating myself up over this. I am need to load a array in people last namestored in a table. Then sort the last names and print them out in alphabetical order. This must be done using the b
Please suppose you have the following st开发者_JS百科atement stored in a VARCHAR2: UPDATE PLUTO SET FIELD1=\'\',FIELD2=\'\',FIELD3=\'TIGER\',FIELD4=\'\',FIELD5=\'SCOTT\';
加载中,请稍侯......