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 |
How to delete an existing row from a table in oracle?
why can't we assign not null constraint as table level constraint
What are steps required to ENTER DATA INTO DWH?
How to get last row id?
Why do we need integrity constraints in a database?
How to rename a column in an existing table?
How would you best determine why your MVIEW couldnt FAST REFRESH?
How to apply filtering criteria at group level in oracle?
What is meant by recursive hints ?
Anybody can tell me, how do we find second largest emp salary from emp table.. Thanks in advance ...
10 Answers Cognizant, ID, NTTF Nettur Technical Training Foundation, Sony, Verizon,
What is key preserved table?
A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.