Search Community
Articles
Playlists
Chola - Search - Videos
Chola - Search - Channel
Forums
Attachments

Performing logical deletes in Oracle ADF

Advertisements

Upcoming Events

No events found.

CholaVideoChart

Chola User Videos Slider

Loading the player...
 Uploaded By: Sudhakar Mani. Added on:05 March 2011.

In this video:

Description

Hi, In some use cases it is required not to physically delete the row from database but instead update a FLAG eg delete_FLAG = 'Y' in order to hide rows from user. So, if you don't familiar with the framework then you might take a long route to do the task which could easily be done by declarative steps. In this video we will do the following. 1. We will add history columns in entities. 2. we will have a view criteria to display only DELETE_FLAG = 'N' rows. 3. On deletion in detail table we will delete logically. 4. We will update the History columns of Master entity as modified by and modified_date. Download the sample code baigsorcl.blogspot.com More tutorials at baigsorcl.blogspot.com