Sign Up to our social questions and Answers to ask questions, answer people’s questions, and connect with other people.
Login to our social questions & Answers to ask questions, answer people’s questions & connect with other people.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Please briefly explain why you feel this question should be reported.
Please briefly explain why you feel this answer should be reported.
Please briefly explain why you feel this user should be reported.
Hi, I faces two ORA error while using SYS.DBMS_ADVANCED_REWRITE this my program and error raised : [code] DECLARE l_src LONG; l_dest LONG; BEGIN l_src := 'select a.empno, a.ename, a.sal, sum(b.sal) ' || 'from emp a, emp b ' || 'WHERE a.sal > b.sal ' || 'OR ' || '( a.sal= b.sal ' || 'and a.rowid ...
Hi, I need Query to get detailes for a specific report Like (stauts , start date , End Date , who's run ? ,...) in EBS R12?
Hello , i need to cancel Concurrent Requests in back-end. Thanks,
Hi, I need to create a Schema like APPS Schema in Oracle Application R12 but read only. Thanks, Mina
suppose we have created new directory on database server and give it required privileges like : [code]CREATE OR REPLACE DIRECTORY TEST_DIR AS '/usr/tmp'; GRANT READ, WRITE ON DIRECTORY TEST_DIR TO MYUSER;[/code] Now i want to know if oracle has capable to read and ...
I have created materialized view successfully but when i am trying to add filter condition on that materialized view along with refresh fast clause i'm getting this error: ORA-12015: cannot create a fast refresh materialized view from a complex query this my ...
When trying to run WEB (PIA) Server, I'm getting the following error: A fatal error has been detected by the Java Runtime Environment: EXCEPTION_ACCESS_VIOLATION (0xc0000005) at pc=0x7ef8664b, pid=352, tid=1924 JRE version: 7.0_02-b13 Java VM: Java HotSpot(TM) Client VM (22.0-b10 mixed mode windows-x86 ) Problematic frame: C ...
which approach is do better performance do bulk insert by using insert from select or Cursor for loop ? for example : [code] DECLARE CURSOR Test_C IS SELECT * FROM test_table1; BEGIN FOR Test_C_REC IN Test_C LOOP INSERT INTO test_table2(col1, col2, col3) VALUES (Test_C.col1, Test_C.col2, Test_C.col3); END LOOP; END; [/code] or a simple select, like: [code] INSERT INTO ...
hello, I need query to get all packages , procedures and functions in my oracle database thanks in advance
