Hi, I have a task and it's simple : all NULL values of a table should be updated to not null let say to be 'Value', however the NOT NULL values will remain the same as it is. consider that the table ...
Question
Oraask Latest Questions
Question
albertExplorer
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 ...
Question
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 ...
Question
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 ...
Question
hi, we using message('') in oracle forms to show message what is the equivalent approach to do this in oracle reports 10g?
Question
How to call MySQL Procedure from Oracle using HS Link ? HS link is correct and I can get the tables data just by adding '@' at the end of the table name ,but I can't call the SP same way ...
Question
Hi Everyone, we faced a problem with new version of firefox, it's not support oracle EBS R12 is there any workaround or solution to run the application on firefox ?
Question
What are the PL/SQL Program limits ?
Question
I have two tables one ordinary table and other is log of this table test_table test_tab_log I want to insert new row in the log table for each insert statement executed for basic table even if there is rollback executed. simply every row inserted in the base table ...
Question
please i want list of all standard Oracle Inventory Reports - EBS R12 and if with short describe every report it will be very appreciatedthanks in advance.