Jul 31 2008 09:17 PM 4872 9 Oracle Mass Update galactus911 How do we do mass updates in Oracle PL SQL? shivigupta Profile Answers by shivigupta Questions by shivigupta Oct 9th, 2012 Codedeclare type id_table IS TABLE of testemp.emp_id%type; v_id_table id_table; begin UPDATE testemp SET subject = d1 WHERE emp_id = 1 returning emp_id bulk collect INTO v_id_table; commit; dbms_output.put_line(count IS:==||v_id_table.count); end; GeekQA123 Profile Answers by GeekQA123 Questions by GeekQA123 Aug 15th, 2012 Use Bulk Update stmt. Answer Question Select Best Answer Aug 30 2005 10:33 PM 4414 24 Suppose there are two fields in table(Employee) say Name and Salary and there are in total 100 records in table. Now my query gives the name of an employee whose salary is 10th among 100 salaries. this query should be solve in SQL not in PL/SQL manjari_ghosh12 Profile Answers by manjari_ghosh12 Questions by manjari_ghosh12 Sep 1st, 2012 CodeSELECT * FROM (SELECT e.*,rownum rnm FROM (SELECT * FROM emp e ORDER BY sal DESC) e) WHERE rnm=10; abhikum.402 Aug 13th, 2012 Select emp_name from (select *,Dense_RANK()over (order by Emp_sal) SalayRank from Emp_a)A where SalayRank=10 Answer Question Select Best Answer
Jul 31 2008 09:17 PM 4872 9 Oracle Mass Update galactus911 How do we do mass updates in Oracle PL SQL? shivigupta Profile Answers by shivigupta Questions by shivigupta Oct 9th, 2012 Codedeclare type id_table IS TABLE of testemp.emp_id%type; v_id_table id_table; begin UPDATE testemp SET subject = d1 WHERE emp_id = 1 returning emp_id bulk collect INTO v_id_table; commit; dbms_output.put_line(count IS:==||v_id_table.count); end; GeekQA123 Profile Answers by GeekQA123 Questions by GeekQA123 Aug 15th, 2012 Use Bulk Update stmt. Answer Question Select Best Answer
shivigupta Profile Answers by shivigupta Questions by shivigupta Oct 9th, 2012 Codedeclare type id_table IS TABLE of testemp.emp_id%type; v_id_table id_table; begin UPDATE testemp SET subject = d1 WHERE emp_id = 1 returning emp_id bulk collect INTO v_id_table; commit; dbms_output.put_line(count IS:==||v_id_table.count); end;
Aug 30 2005 10:33 PM 4414 24 Suppose there are two fields in table(Employee) say Name and Salary and there are in total 100 records in table. Now my query gives the name of an employee whose salary is 10th among 100 salaries. this query should be solve in SQL not in PL/SQL manjari_ghosh12 Profile Answers by manjari_ghosh12 Questions by manjari_ghosh12 Sep 1st, 2012 CodeSELECT * FROM (SELECT e.*,rownum rnm FROM (SELECT * FROM emp e ORDER BY sal DESC) e) WHERE rnm=10; abhikum.402 Aug 13th, 2012 Select emp_name from (select *,Dense_RANK()over (order by Emp_sal) SalayRank from Emp_a)A where SalayRank=10 Answer Question Select Best Answer
manjari_ghosh12 Profile Answers by manjari_ghosh12 Questions by manjari_ghosh12 Sep 1st, 2012 CodeSELECT * FROM (SELECT e.*,rownum rnm FROM (SELECT * FROM emp e ORDER BY sal DESC) e) WHERE rnm=10;
abhikum.402 Aug 13th, 2012 Select emp_name from (select *,Dense_RANK()over (order by Emp_sal) SalayRank from Emp_a)A where SalayRank=10