Home/Database/Oracle SQL/Page 6

Oraask Latest Questions

Question
albert
  • 0
albertExplorer
Asked: July 14, 2017In:
  • 0

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 ...

databaseORA-00907ORA-30389sqlSYS.DBMS_ADVANCED_REWRITE
Question
matheo
  • 0
matheoExplorer
Asked: May 1, 2017In:
  • 0

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 ...

Bulk Insertcursordatabaseinsert from selectsql
Question
oracle user
  • 0
oracle userExplorer
Asked: April 30, 2017In:
  • 0

I have a query and I want to use if statement inside where clause like this : [code] SELECT e.first_name, e.last_name, e.status FROM employees e WHERE IF status_flag = STATUS_ACTIVE then e.status = 'A' IF status_flag = STATUS_INACTIVE then e.status = 'T' IF source_flag = SOURCE_FUNCTION then e.business_unit = ...

if statementsqlwhere clause