|
View previous topic :: View next topic
|
| Author |
Message |
shilpadeshmukh
New User
Joined: 08 Jan 2006
Posts: 2
Location: pune
|
|
|
|
hi
i want to know that can i update views |
|
| Back to top |
|
 |
rajesh_1183
Active User
Joined: 24 Nov 2005
Posts: 121
Location: Tadepalligudem
|
|
|
|
i think if the view is made up of from only one table,te view is updatable which are called updatable vews.........
Thaks,
Rajesh |
|
| Back to top |
|
|
batakhani
New User
Joined: 29 Mar 2005
Posts: 2
|
|
|
|
If view is made from one table update is possible.i.e simple view.
If view is from more than one table update is not possible.i.e complex view |
|
| Back to top |
|
|
Rupesh.Kothari
Member of the Month
Joined: 27 Apr 2005
Posts: 463
|
|
|
|
HI,
| Quote: |
hi
i want to know that can i update views |
We can only add Column after creating View.
Regards
Rupesh |
|
| Back to top |
|
|
sihanature
Warnings : 1
New User
Joined: 01 Sep 2005
Posts: 33
|
|
|
|
HI
Not all of them. Some views are updatable e.g. single table view with all the fields or mandatory fields. Examples of non-updatable views are views which are joins, views that contain aggregate functions(such as MIN), and views that have GROUP BY clause.
Regards |
|
| Back to top |
|
|
|
|
