Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 1 Answers
- 6673 Views
- Sonata, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
how to return query output in html format? : Sql dba
how to use in conditions? : Sql dba
What is the need of a partition key?
How to raise user-defined exception with custom sqlerrm ?
What is foreign key and example?
column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.
What is difference between my sql and sql?
What is auto increment?
How to run sql*plus commands in sql developer?
Can we use joins in subquery?
How do you pronounce sql?
Why are aggregate functions called so?
What is a memo field?
Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?
What is forward declaration in pl sql?
