Interested to Buy Any Domain ? << Click Here >> for more details...
can a view be updated?
- 3 Answers
- 9776 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / yogesh babu
yes it can be updated ....but there are certain
restrictions in it.
For eg:
1.a view created from nonupdatable view cant be updated
2.when it is having having , groupby,orderby it cant be
updated.etc
| Is This Answer Correct ? | 9 Yes | 1 No |
Answer / kumar
View can be updated ...but some restrictions are there.
Let us think we are using one or more tables to create a
view and if the view contains all the NOT NULL constraint
columns of the tables, then only we can update the view or
else we can't.
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / chandana
Yes,Views can be updated but there are some conditions.
-> Depending on type of view ie
Simple views can be updated
Complex views may or may not be updated.
One cannot Perform DML Operations on Complex view
if it contains
1. Group by clause
2. Group functions
3. Distinct
4. Pseudocolumn rownum
One cannot modify the view if it has
1. Group by clause
2. Group functions
3. Distinct
4. Pseudocolumn rownum
5. Columns by expressions
One cannot insert data into views if it has
1. Group by clause
2. Group functions
3. Distinct
4. Pseudocolumn rownum
5. Columns by expressions
6. NOT NULL columns in base table that are not selected in
view
| Is This Answer Correct ? | 3 Yes | 3 No |
What is analyze command used for?
is there a tool to trace queries, like profiler for sql server?
how to do daily transactions with out sql* loader control file regesterd in apps?
Can Multiple instances be run on Single Machine???
What is the use of file param in imp command?
Please help me how to write a Query to change the primary key constraint from 1 attribute to another attribute in a table
Can the default values be assigned to actual parameters?
Anyone have the Latest Oracle Dumbs?While u have please forard to narain1411@gmail.com
What operating systems are supported by oracle database 10g xe?
in account table account type amount ac1 credit 300 ac2 debit 5000 ac3 credit 3000 ac1 debit 4000 ac3 debit 2000 ac2 credit 4000 write a query how to get sum of credit & sum of debit
Explain the difference between a procedure and a function? What do you understand by those terms?
How to convert characters to dates in oracle?
Oracle General 
