How can we Update a table with out using UPDATE command?

Question Posted / amulbaby

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

More Oracle General Interview Questions

From the database level, how can you tell under which time zone a database is operating?

what is difference between table and view? where to use views? thanks in advance!

How to set a transaction to be read only in oracle?

What is an oracle wallet?

Ho to insert no. of records at a time..i mean i want to insert 100 records at a time into a table

What the is the diff between local index and global index. give some example.

How would you change old and new values in an insert, delete and update triggers?

What is a cluster?

what's query optimization and without use of IN AND Exist can we get another way data from query

How do we switch from init.ora file to asp file?

What is cluster Key ?

How to create a new user account in oracle?

For more Oracle General Interview Questions Click Here