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
Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?
How to execute a stored procedure in oracle?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
How do I uninstall oracle client from windows?
How to list all user accounts in oracle?
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?
Why does Oracle not permit the use of PCTUSED with indexes?
What are the various types of snapshots ?
Difference between hot backup vs. Cold backup?
What are the benefits of ordbms?
How to define an oracle sub procedure?
Explain the use of control file?
What privilege is needed for a user to create tables in oracle?
Is postgres faster than oracle?
What is catalog in Oracle?