Hi, Can someone tell me what is the difference between Views and Materialized Views in Oracle? Thanks.
Question
Oraask Latest Questions
Question
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
Hi, Please i am trying to use dbms_assert package in a SQL statement and I want to understand exactly how dbms_assert protects against SQL injection ? thanks.
Question
Hi, I have set of values and I want to order by as follows : we scan left to right . for example for values like '25 AB' ,'30 MT'. 25 comes before 30. [code] create table test_table(COL1 varchar2(240)); insert into test_table values ('50000'); insert into test_table ...
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
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
matheoExplorer
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 ...
Question
hello, I need query to get all packages , procedures and functions in my oracle database thanks in advance