Results 1 to 3 of 3

Thread: Write an SQL query

  1. #1
    Expert Member
    Join Date
    Oct 2006
    Answers
    209

    Write an SQL query

    Write an SQL query to fetch only new and changed rows?

    Note :This is the question asked by a visitor Sravan. I am posting this in proper forum.


  2. #2
    Expert Member
    Join Date
    Sep 2006
    Answers
    130

    Re: Write an SQL query

    I know the reply is bit late, but even then it might help others who have the same doubt :-)

    Rather than using a query, u can go for database triggers.
    Using the OLD & NEW qualifiers of Row Triggers, the record before & after the modification can be fetched.
    Here is an sample,
    insert into aud_emp(employee_id, old_salary, new_salary)
    values (emp_id, :OLD.salary, :NEW.salary);

    *** Mangai Varma ***


  3. #3
    Junior Member
    Join Date
    Sep 2008
    Answers
    18

    Re: Write an SQL query

    if u want fetch only new or changed row.it can be possible with search condition,
    like
    SQL>select * from emp where ename='johns';


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact