Will the ‘View’ get refreshed immediately when you update a database table. If it doesn’t get refreshed immediately, what method you use to refresh it ?

  • Interview Candidate
  • 5
  • 1908

Showing Answers 1 - 5 of 5 Answers

Ravikumar Gandham

  • Jul 10th, 2006
 

I think for this question the answer may be creating a trigger. For views we use Instead trigger to update the view.

  Was this answer useful?  Yes

ravitala

  • Jul 18th, 2006
 

NO, the view do not get refreshed when you update a data base table immediately.We have to recompile, to get them refreshed.There are 2 methods to get that refreshed .Method One:Manual approach:-ALTER VIEW COMPILEMethod Two:Automatic approach:-Select * from

  Was this answer useful?  Yes

ddkdhar

  • Feb 12th, 2007
 

there is a concept called dependencies .please check in oracle websiteif tables is altered then view becomes invalid...............but some conditions it is not invalid for example create table table1 (a number(10)); create view table1_view as select * from table1; select * from table1_view;alter table table1add ( ad number(10));select * from table1_view;do above

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions