Interested to Buy Any Domain ? << Click Here >> for more details...
How can we Update a table with out using UPDATE command?
- 1 Answers
- 5944 Views
- I also Faced
- E-Mail Answers
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 is Single Byte Overhead...?
What are the uses of linked server and explain it in detail?
Difference between sub query and nested query ?
19 Answers Keane India Ltd, TCS,
How to create a server parameter file?
Please explain joins in oracle?
What is literal?
What is the effect of setting the 'RULE' for OPTIMIER_GOAL parameter of the ALTER SESSION Command ?
Can a Tablespace hold objects from different Schemes ?
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?
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
Describe Referential Integrity ?
Can we create more than one index on particular column?
Oracle General 
