How can we Update a table with out using UPDATE command?
Answer / 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 |
What are the execution control statements in oracle?
What is an oracle wallet?
How do I find the database name in oracle?
what r tyhe major differences between oracle 9i & 10g?
How to use "in" parameter properly?
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
Who developed oracle & when?
How can I convert single byte kana characters into multi byte kana characters and vice-versa.
What is the effect of setting the value "CHOOSE" for OPTIMIZER_GOAL, parameter of the ALTER SESSION Command ?
How to retrieve 5th highest sal from emp table?
What happens if you set the sga too low in oracle?