Guys can you give a good comparison regarding Oracle/PL SQL and Java in terms of their strengths and weaknesses when handling monetary computations.
In my function below开发者_开发知识库 I am trying to understand why it only returns BLAH if I pass in 01356666 and then a null value for anything else passed in.My expectation was that it would return
PL SQL moves older versions of data from a transaction table to a history table of same structure and archive fora certain period -
I read some example of how to use DBMS_CHANGE_NOTIFICATION for an asynchronous trigger. I need to create a trigger for table CONTENT only if STATUS = 1709003.
SELECT A.ID, A.COLUMN_B, A.COLUMN_C FROM A WHERE A.COLUMN_A IN ( SELECT A.COLUMN_A FROM B INNER JOIN A ON B.\"COLUMN_A\" = A.\"COLUMN_A\"
I\'m having difficulty with Oracle 10g syntax for a correlated UPDATE.I am processing this code in a PL/SQL procedure.
I am using ODP.Net and run the PL/SQL Command to merge the table in the Oracle 10G database. My command is as follow:
So i am working on an installer where the installer connects to a database and creates tables and populates them.
Is it possible to distinguish between code, strings and comments by using regular expressions? I\'m trying to build a formatter for PLSQL-Code in C# and I can\'t manage to solve the problem, that stri
I encountered the following PL/SQL code(variables modified) at work: PROCEDURE test(i_w IN a.w%type,o_result IN OUT resu_cur_type) IS
加载中,请稍侯......