February 28, 2011

FOR UPDATE cursors

We can use FOR UPDATE cursors in select statement for auditing purpose:

E.g: select * from per_all_people_f for update;

Here in this case..a employee details has been changed and the updation will be done by a scheduled concurrent program. So we can check the colums which are in wait for updation form this query

Check the below link for more info...
http://www.java2s.com/Tutorial/Oracle/0500__Cursor/UsingWHERECURRENTOF.htm

at
Labels:

No comments:

Post a Comment

Thanks for your comments submitted.,will review and Post soon! by admin.

Subscribe to: Post Comments (Atom)

COALESCE-SQL

Coalesce- return the null values from the expression. It works similar to a case statement where if expression 1 is false then goes to expr...

  • FND_CANONICAL
    In HRMS we do use date with timestamp for EIT ans SIT segments. To change the format od the date we can use fnd_date . canonical_to_date ...
  • HRMS API with tables
    Converstion API Table Organization hr_organization_api.create_hr_organization hr_all_organization...
  • Wip Move Transaction Migration
    WIP Migration: Create a job in Work in Process 1.        Create a job with item which is billable on and define routing sequence for the ...