Interested to Buy Any Domain ? << Click Here >> for more details...
How can we Update a table with out using UPDATE command?
- 1 Answers
- 5938 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
What do you understand by a database object?
How do I call oracle stored procedures that take no parameters?
1) Does oracle have any table which contain all the exceptions and it's code internally?
How are extents allocated to a segment?
What is the minimum client footprint required to connect c# to an oracle database?
What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
How do you bind variables in oracle?
What are the uses of linked server and explain it in detail?
What is meant by joins?
what is the difference between data migration and production migration.
Explain the use of Merge statement in oracle 11g
What is an Oracle index?
What are the major difference between truncate and delete?
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.
Point out the difference between user tables and data dictionary?
