Answer Posted / 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 |
Post New Answer View All Answers
Explain the difference between sql and oracle?
How to find out what oracle odbc drivers are installed?
How to insert a new row into a table in oracle?
What is the max number of columns in an oracle table?
What is data file?
Select all the employees who were hired in last 2 years and who works in dept where max managers are working.
How to pass a parameter to a cursor in oracle?
What privilege is needed for a user to create views in oracle?
What is the database name in oracle?
Design database draw er diagram for a certain scenario ?
How to view all columns in an existing table?
How can we find out the current date and time in oracle?
What are the different windows events activated at runtime ?
Explain the blob datatype?
What is the difference between truncate & delete command?
