Interested to Buy Any Domain ? << Click Here >> for more details...
How can we Update a table with out using UPDATE command?
- 1 Answers
- 5848 Views
- I also Faced
- E-Mail Answers
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.
What is redo log?
How to pass parameters to procedures?
Is oracle an open source?
How to open and close an explicit cursor 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??
How do we display rows from the table without duplicates?
How to create a new table by selecting rows from another table?
Where is the export dump file located?
How to use "while" statements in oracle?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
How will you differentiate between varchar & varchar2?
How can I introduce multiple conditions in like operator?
What is a directory object?
Give the constructs of a package, function or a procedure.
