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 |
Can we connect to ORACLE db using Windows Authentication?
What is an index associated with a constraint?
How to loop through a cursor variable?
How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.
19. Display all clients whose name begins with the letter J or contains the letter M anywhere or contains E as the third letter.
how to get second highest sal of emp table
Why cursor variables are easier to use than cursors?
When does a Transaction end ?
sql query to get zero records from a table
How can I get column names from a table in oracle?
Difference between the “verify” and “feedback” command?
Hi friends can u send the oracle 9i full version download link?????????????? please reply ?