How can we Update a table with out using UPDATE command?
Answer Posted / myway
Use merge command. If the rows already exist then it will
update it with new data if not it would insert the new data.
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
Explain cascading triggers.
How to convert characters to numbers in oracle?
Assuming that you are an End User How to find that in the payment Batch some of the Invoice was Missing To pay How to find That??
Does facebook use oracle?
In which language oracle has been developed?
What is oracle host variable?
How do I manually create a database in oracle?
Explain the use of owner option in exp command.
How to write a left outer join with the where clause in oracle?
What are the different types of synonyms?
What are the oracle differences between nvl and coalesce
Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?
How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?
What happens to the current transaction if the session is ended?
What is the recommended interval at which to run statspack snapshots, and why?