can you call insert/update/delete in select statements. If
yes how? If no what is the other way?
- 2 Answers
- 7138 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 |
can we insert any row to dual table if i got the permission from DBA
without using count(*) and rownum how can we count total record in a table
What is meant by a deadlock situation?
what is the difference between rollback & commit? can a foreign key has null value?
What is backup in Oracle?
DBMS vs. RDBMS
How to lock and unlock a user account in oracle?
What are the differences between char and nchar in oracle?
How do you tell what your machine name is and what is its IP address?
How to define a record variable to store a table row?
What are the values that can be specified for OPTIMIZER MODE Parameter ?
What are main difference between Stored Procedure and Functions.
Oracle General 
