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 |
What are the sql clauses supported in the link property sheet ?
How to convert the date format from dd/mm/yyyy to mm/dd/yyyy. (for eg). 22/05/2008 to 05/22/2008. when u use to_char(), it tells the month is invalid. how to resolve this problem.tel with eg.
Explain the use of online redo log files in oracle.
How translate command is different from replace?
Can objects of the same Schema reside in different tablespaces.?
How to assign a tablespace to a users in oracle?
What are the different pseudo commands? Explain in general?
how to store only time in a data base table
How to establish administrator authentication to the server?
How to create lov dynamically at runtime & attach to text field?
Explain the use of show option in imp command.
Please explain drop constraint oracle?