Interested to Buy Any Domain ? << Click Here >> for more details...
can a view be updated?
- 3 Answers
- 9891 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 |
How many file formats are supported to export data?
What is an oracle?
WHT ARE THE AGGREATE FUNCTIONS?
How can windows applications connect to oracle servers?
Which Functions Using Integer ==> String's i.e 2 ==> Two... Like that string's ==> integer values ? It is Possible ?
What are oracle functions?
Create table Employee ( Employee_Id varchar2(8) Constraint emp_id_pk primary key, FirstName varchar2(50), LastName varchar2(50), DeptID Number(5) Constraint dept_id_fk Foreign Key(DeptId) References Department(DeptId) ) Error I am getting: Constraint specification are not allowed here
what is the difference between table and veiw?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
What is Rollback Segment ?
IS it possible to built the oracle database without setting the kernal parameters?
What should be the return type for a cursor variable.Can we use a scalar data type as return type?
Oracle General 
