can we update a view which is created from two tables
Answer Posted / brajesh
yes,but only of those column from which table primary key
is preserved in view
Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
What does count (*) mean in sql?
How to select unique records from a table?
Can we use having without group by in sql?
How can you view the errors encountered in a trigger?
What is difference between nchar and nvarchar?
What is sql keyword?
What is trigger with example?
what is difference between delete and truncate commands? : Sql dba
How to place comments in pl/sql?
how to convert dates to character strings? : Sql dba
Is a secondary key the same as a foreign key?
ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..
What is the difference between execution of triggers and stored procedures?
What are the different type of joins in sql?
Which column of the user triggers data dictionary view displays the database event that will fire the trigger?