Interested to Buy Any Domain ? << Click Here >> for more details...
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
What view(s) do you use to associate a users SQLPLUS session with his o/s process?
What is define in oracle?
What is recovery manager in Oracle?
What is blob datatype?
How to define a sub function?
what are the advantages of running a database in archive log mode?
How many types of cluster table in Oracle?
What are the data types in oracle?
What is save point in oracle database?
Will you be able to store pictures in the database?
How to load data from external tables to regular tables?
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
What privilege is needed for a user to create views in oracle?
Explain the function of optimizer in oracle?
How to define default values for formal parameters?
