can you call insert/update/delete in select statements. If
yes how? If no what is the other way?
Answer Posted / anonymous
you could use a select for update from a pl/sql or jdbc program
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Explain the use of record option in exp command.
I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?
21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.
How do I know if oracle client is installed on windows?
How to use "for" statements in oracle?
What is the difference between post-database commit and post-form commit?
How to define default values for formal parameters?
What is oracle analytical function?
What is difference between sid and service name in oracle?
How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?
From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.
How to create a new oracle data file?
Explain the use of online redo log files in oracle.
How to create a new table in your schema?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?