Interested to Buy Any Domain ? << Click Here >> for more details...
can you call insert/update/delete in select statements. If
yes how? If no what is the other way?
- 2 Answers
- 6959 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / merly
I dont think so it is possible but we can use a select
statement in insert/update/delete(ie reverse is possible)
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / anonymous
you could use a select for update from a pl/sql or jdbc program
| Is This Answer Correct ? | 0 Yes | 1 No |
what are the database links ?
When does a Transaction end ?
Two triggers one is before insert and other is after insert are firing on a table.If 10 times you insert in a table.Then how many times before trigger and how many types after trigger will fire in pl/sql.
We need to compare two successive records of a table based on a field. For example, if the table is CUSTOMER, and the filed is Account_ID, To compare Account_IDs of record1 and record2 of CUSTOMER table, what can be the query ?
Briefly explain what is literal? Give an example where it can be used?
Explain an extent?
What is a OUTER JOIN?
what is Materialized view? What is a snapshot? what are the similarities and differences between Materialized views and snapshots?
what is grid in Oracle 10g...
How to loop through data rows in the implicit cursor?
What are the types of Database Links ?
Who i will insert 1 lacks record in a Database table
Oracle General 
