Interested to Buy Any Domain ? << Click Here >> for more details...
a. Can you delete data from a View.
b. If Yes, can you delete it if there are multiple tables
c. If No, can you delete if there is single source table
which is joining.
- 4 Answers
- 10389 Views
- CGI, IBM, I also Faced
- E-Mail Answers
Answer Posted / haarika valasa
IF view is created based on only one base table we can
perform all DML operations.
If view is created based on multiple table using joins and
goup by functions etc..than we cannot perform directly DML
operations.
Using Instead of Trigger we can perform DML operations on
complex view.
| Is This Answer Correct ? | 24 Yes | 0 No |
Post New Answer View All Answers
What is recursive stored procedure?
what are the performance and scalability characteristics of mysql? : Sql dba
Is natural join and inner join same?
What is the difference between clustered and non-clustered indexes?
Why functions are used in sql?
How can I make sql query run faster?
What is the use of desc in sql?
How many sql databases can you have on one server?
what are enums used for in mysql? : Sql dba
Why are indexes and views important to an organization?
How many types of cursors are available in pl/sql?
How many types of literals are available in pl sql?
What is blind sql injection?
1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...
What is the example of procedure?
