I\'m trying to update a package in Oracle, coming from SQL Server this has been confusing. I have written a batch file that runs the .spec file first and the .body file second, but even running it ma
I\'m trying to use Oracle LogMiner (DBMS_LOGMNR package) for implementation of audit trails functionality based on redo logs. But each time when I query V$LOGMNR_CONTENTS it creates several big (up to
My requirement is to read a file and fetch some data from each line. for eg:suppose my file conatain this data:
Hey guys, I\'m wondering how you create a job scheduler in Oracle APEX? I\'m making a system which manages calls, each call has a severity level. After an hour, the severity level should be escalated
I need to change a functions signature to have a parameter (p_param) of type CLOB, the previous type was nvarchar2.This caused me trouble when existing code was using || to concat.
I have the following cursor (something like it anyways) that I am using to copy entries for a table that is part of a many to many relationship. I need the new IDs that are generated during the INSER开
FUNCTION encounter_for_dataset(p_check_answer_master_id IN check_list_answer_master.check_answer_master_id%TYPE) RETURN NUMBER
I need your kind help to resolve this question. I state that I am not able to use regolar expressions with Oracle PL/SQL, but I promise that I\'ll study them ASAP!
I have set of values in a cursor. For example: CURSOR c_stock_option IS SELECT empid, \'1\' AS ISenrolled
I\'m going nuts with this issue. I can\'t get the result from the following multiplication: X^t * X X is an m * n matrix with m = 36 rows and n = 3 columns which is represented by an utl_nla_array_
加载中,请稍侯......