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 create a stored program unit?
How can we Update a table with out using UPDATE command?
5. Display full details for the creditor/s who has received the single largest payment. Do not use a table join or set operator anywhere in your query.
How data locks are respected in oracle?
How do I find the database name in oracle?
What is a static data dictionary in oracle?
How to restrict the duplicate records in table valuesets
How to store only time; not date and time?
What is the difference between SQL and SQL Server?
what is the syntax of DROP command?
Does oracle charge for java?
How to Remove the 3rd highest salary person record from table?