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


Please Help Members By Posting Answers For Below Questions

Explain the use of record option in exp command.

749


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?

2207


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.

1813


How do I know if oracle client is installed on windows?

691


How to use "for" statements in oracle?

769


What is the difference between post-database commit and post-form commit?

790


How to define default values for formal parameters?

780


What is oracle analytical function?

742


What is difference between sid and service name in oracle?

700


How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?

2957


From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.

815


How to create a new oracle data file?

766


Explain the use of online redo log files in oracle.

776


How to create a new table in your schema?

810


Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

1801