Which one of the following is a reason that an INSERT
statement might cause an error instead of executing
correctly?
1. The INSERT statement was attempting to insert a record
into a view that was created from more than one table.
2. The INSERT statement was attempting to insert a record
using a combination of constants and values from an
existing table.
3. The INSERT statement was attempting to insert a record
with a non-NULL value into a table that has that column
defined as NULL.
4. The INSERT statement was attempting to insert a record
into a table by selecting a record from that same table.
5. The INSERT statement was attempting to insert a record
into a view rather than a table.
Answer / tulsi
1. The INSERT statement was attempting to insert a record
into a view that was created from more than one table.
we cannot modify more than one base table through a join
view.
Is This Answer Correct ? | 9 Yes | 1 No |
how can we know the number of days between two given dates using mysql? : Sql dba
ex: take one schema in that t1,t2,.....tn tables and you don't no the table name also. write a procedure if enter columns name then display the maching columns .otherwise display the unmatch columns.
What are inbuilt functions in sql?
What is pls integer?
what is sp_pkeys? : Transact sql
What are sql functions? Describe in brief different types of sql functions?
How do you delete duplicates in sql query using rowid?
why we go for package? what are the advantages of using instead of seperate procuderes or functions
Where are my tempfiles, I don't see them in v$datafile or dba_data_file?
What is trigger price?
Can pl sql procedure have a return statement?
what is explain plan?