:: Home Page
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   Errors
   Testimonials Refer this Site  Refer This Site to Your Friends  Site Map  Contact Us      
Categories >> Software >> Databases >> SQL PLSQL


Question How can we Get the Updated Rows? ie, There is 100s of Rows i
updated the Rows who have salary 5000. then i want to select
the Updated Rows. How can we achieve it?
 Question Asked In Companies :: Fidelity, KCP,     < I also faced this Question! >
 Question Submitted By :: praveengnr
  Answer Posted By  
create table t1 as select * from emp where 1=2;

create or replace trigger t1
after update on emp
for eachrow
insert into t1

after create trigger
then u updated.

Is This Answer Correct ?    4 Yes 5 No

View All Answers
Please Help Members By Posting Answers For Below Questions
 Question Views   Select
What are wait events. Describe the wait event tables. 1887
Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi 723
Maximum how many triggers can we use in trigger and How to find out how many records it fetched. 190
If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000???? 2289
what is the difference difference between procedure and packages 3064
What is the use of time stamp in select statement? 209
table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 1146
Describe the Index, Types of index, At what situation we have used? Which one s better than others? 509
What is window clause? 261
1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao... 581
Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 612
How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000 41
Could you please provide oca (oracle 10g) dumps for my certification ? 2311
I want to execute a piece of code before calling a procedure. How to achieve it? 4
What packages(if any) has oracle provided for use by developers? 2425
E-Mail New Answers        Answer Selected Questions