Use merge command. If the rows already exist then it will update it with

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

Question Posted / myway

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

Please Help Members By Posting Answers For Below Questions

What is a sub query? Describe its types?

970

What is a tns service name?

955

What is transport network substrate (tns) in oracle?

1001

What are the ansi data types supported in oracle?

906

Calculate difference between 2 date / times in oracle sql?

995

How to count groups returned with the group by clause in oracle?

1019

What privilege is needed for a user to create indexes in oracle?

975

List the types of joins used in writing subqueries?

952

How to use subqueries with the exists operator in oracle?

979

Query to retrieve record for a many to many relationship ?

2468

How many types of table in Oracle?

1075

How to write date and time interval literals in oracle?

985

What is a table index?

1024

What is a cognitive schema?

915

Can we store images in oracle database?

954