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
Answers were Sorted based on User's Feedback
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 |
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 |
Give two methods you could use to determine what DDL changes have been made.
How client makes connection with server in client/server architecture?
How do you switch from an init.ora file to a spfile?
How do you create a credit note against an invoice? : oracle accounts receivable
how can we send a concurrent program output to the clients through mail or fax give me example.
where the dff data will be stored
What is chargeback invoice? How do we create it? : oracle accounts receivable
A scenario for amount correction & how to use amount correction functionality in AP invoices
how to write a query without using where? Example- select * from employee where empno=10 I need to write this query without where clause.
Olap tools
what is the difference b/w oracle8i and oracle9i
What command would you use to create a backup control file?