How to update the simple views?give me example?if the table having 100 records

How to update the simple views?give me example?if the table
having 100 records and created a view on this table. if i can
update the table then how to update the views

Question Posted / venki

2 Answers
6836 Views
Cap Gemini, Syntel, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How to update the simple views?give me example?if the table having 100 records and created a view ..

Answer / muzaffar ali umrani

if you update the table then view will be automatically update, no need to update view.

Is This Answer Correct ?

7 Yes

2 No

How to update the simple views?give me example?if the table having 100 records and created a view ..

Answer / sudipta santra

THIS IS IMMETIRIAL QUESTION.

IF THE VIEW IS SIMPLE VIEW THEN IF U UPDATE TABLE OR DIRECT
UPDATE ON VIEW THE SAME THINGS WILL HAPPEN.

Is This Answer Correct ?

2 Yes

0 No

Post New Answer

More Oracle AllOther Interview Questions

Describe the P2P cycle ?

1 Answers

i am working with OC 4.5 i have numbers in table in 10 row with some null values please tell me how to find total? Thanks

0 Answers HCL,

Can We Restore a Table that accidantly dropped.

8 Answers TCS,

what is correlated subquery

3 Answers

Give two examples of how you might determine the structure of the table DEPT.

2 Answers

Name two files used for network connection to a database.

1 Answers

How do you switch from an init.ora file to a spfile?

1 Answers HCL, Wipro,

which one is currently in used software cmpanies.

0 Answers

What is the mandatory setup in cyclecount ?

0 Answers Oracle,

PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE

0 Answers

types of receipts and detail desription about recipts and tables effected by receipts?

0 Answers

Describe what redo logs are.

1 Answers

For more Oracle AllOther Interview Questions Click Here