Interested to Buy Any Domain ? << Click Here >> for more details...
can you call insert/update/delete in select statements. If
yes how? If no what is the other way?
- 2 Answers
- 7081 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 |
what is the use of system.effective.date variable in oracle?
How do I recompile a procedure in oracle?
How to create a testing table in oracle?
How to store only time; not date and time?
How view is different from a table?
How to assign query results to variables?
What is the scope of a local variable?
1:-How to write to update command in a procedure in oracle which update two different table at a time 2:-How to write the select command in a procedure in oracle which give multiple records
I have two tables : COuntry,city I want all the cities in each country.Question on Cross Join.
what are the diffeenes between oracle 9i,oracle 10g
Explain what are the different type of segments?
Two triggers one is before insert and other is after insert are firing on a table.If 10 times you insert in a table.Then how many times before trigger and how many types after trigger will fire in pl/sql.
Oracle General 
