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
- 6979 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 are the extensions used by oracle reports?
Explain a data segment?
How will you write a query to get a 5th rank student from a table student_report?
what is mean by prmary key and foreign key and how can we diffrentiate that? Please answer me. Advance thanks.
It's Urgent? How to IMPORT .xls & .txt file into ORACLE?
SELECT * FROM (SELECT TITLE FROM MOVIE ORDER BY RANK DESC) WHERE ROWNUM > 4; when i run the above query .it produces output as NO ROWS SELECTED.why ?plz any one help me
What are the different types of databases?
How to make a Data Backup in oracle ? What is the procedure for creating the dump files in oracle ( any version ) ?
What is meant by a deadlock situation?
what is the use of system.effective.date variable in oracle?
What is meant by joins?
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.
Oracle General 
