can you call insert/update/delete in select statements. If
yes how? If no what is the other way?
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 is a trace file and how is it created in oracle?
What is a data segment ?
What is SQL Tuning Advisor in Oracle?
What is partitioned table in Oracle?
State and explain the different types of data models?
What is the maximum number of CHECK constraints that can be defined on a column ?
Difference between oracle's plus (+) notation and ansi join notation?
How to connect to oracle using service name instead of sid?
What is tns service name?
how to find find & delete duplicate rows from two different tables?
How would you begin to troubleshoot an ORA-3113 error?
How to write a query with an inner join in oracle?