I am writing a PL/SQL parser to identify the operations(Select,Insert,Delete) performed on the Table when I run Procedure, Function or Package.
I\'ve been trying to create a PLSQL package that will post into SharePoint through its web services. I\'ve tried doing this using C# and it kind of worked, yet with PLSQL It seems like am having probl
I have a pl/sql procedure with the following signature PROCEDURE pr_log_process_started ( p_process_id IN log_process_status.process_id%TYPE,
When rounding up to 2 decimal places, the value 4.01132141 would be rounded to 4.02 开发者_运维问答because it exceeds 4.01.
Simple one. I´m a bit of a newvbie with PLSql and oracle\'s error messages are never too helpful. I want to do a simple trigger to update a column with the current date i.e. \'modified date\' column
I want to create a stored procedure like this: PROCEDURE P_CUSTOMER_UPDATE ( pADSLTable IN Table, pAccountname IN NVARCHAR2,
Here is my object def: CREATE OR REPLACE TYPE FALCON.contacts AS OBJECT (phoneVARCHAR2(50) ,phoneusageVARCHAR2(25)
guys. Here\'s a simple sample two-dimensional array in PL/SQL, which is working perfectly. declare type a is table of number;
After doingDEFINE_EDITOR=vi . I wrote SQL > edit samp开发者_Go百科le.sql This is being stored in Jagan/Documents by default. But i want this to be stored in Jagan/Documents/plsql. Can anybody t
Here is a boolean expression that does the trick: nvl(:new.location != :old.location, (:new.location is null) != (:old.location is null))
加载中,请稍侯......