GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Oracle  >  Oracle Forms 4.0
Go To First  |  Previous Question  |  Next Question 
 Oracle Forms 4.0  |  Question 69 of 92    Print  
What are the triggers associated with master detail relationships ?

  
Total Answers and Comments: 6 Last Update: July 18, 2008     Asked by: Shweta_faqs 
  
 Sponsored Links

 
 Best Rated Answer
Submitted by: Neethi
 

* Non-Isolated (default)

On-Check delete Master

On Populate Details

On Clear Details

*Isolated

On Clear Details

On Populate Details

*Cascade

Per-Delete

On Clear details

On Populate Details



Above answer was rated as good by the following members:
table12345
February 18, 2006 04:27:57   #1  
Shyamal Kumar        

RE: What are the triggers associated with master detai...
Following are the triggers associated with Master Detail relationship.On populate detailsOn check delete masterPre delete
 
Is this answer useful? Yes | No
May 20, 2006 04:58:07   #2  
narasimha        

RE: What are the triggers associated with master detai...

THEREE TRIGGERS ARE ASSOCIATED WITH THE MASTER DETAIL RELATIONSHIP.

THEY ARE:

ON_CHECK_DELETE_MASTER

ON_PAPULATE_DETAILS

ON_CLEAR-DETAILS.


 
Is this answer useful? Yes | No
August 16, 2006 09:16:55   #3  
srinivas        

RE: What are the triggers associated with master detai...

The default triggers associated with Mater detail relationship are

1. On_check_delete_master

2. On_clear_details

3. On_populate_details


 
Is this answer useful? Yes | No
September 13, 2006 02:17:41   #4  
prachi        

RE: What are the triggers associated with master detai...
4. pre-delete
 
Is this answer useful? Yes | No
January 17, 2007 12:19:59   #5  
Neethi        

RE: What are the triggers associated with master detai...

* Non-Isolated (default)

On-Check delete Master

On Populate Details

On Clear Details

*Isolated

On Clear Details

On Populate Details

*Cascade

Per-Delete

On Clear details

On Populate Details


 
Is this answer useful? Yes | NoAnswer is useful 1   Answer is not useful 0Overall Rating: +1    
July 17, 2008 23:46:55   #6  
Ziaullah Member Since: July 2008   Contribution: 2    

RE: What are the triggers associated with master detail relationships ?

NON-ISOLATED (default)

a) on check delete master

b) on clear details

c) on populate details

ISOLATED

a) on clear details

b) on populate details

CASCADE
a) per-delete

b) on clear details

c) on populate details


 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape