SQL> UPDATE table_name SET column1=value, column2=value2,...

wirte the syntax of update query?

Question Posted / irshad ahmad

3 Answers
5345 Views
IBM, I also Faced
E-Mail Answers

Answer Posted / irshad ahmad

SQL> UPDATE table_name SET column1=value,
column2=value2,...
[WHERE condition];
for Example:-
Sql> UPDATE customers SET address = ‘250 Azad Road’ WHERE
customerid = 4;

Is This Answer Correct ?

6 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is a private synonym?

1537

How to sort output in descending order in oracle?

994

How remove data files before opening a database?

1012

How to select some columns from a table in oracle?

1013

How do I reset a sequence in oracle?

1060

What is the sid in oracle?

909

What is a subquery?

1064

Can group functions be used in the order by clause in oracle?

947

What is a database schema in oracle?

1064

State the various uses of dbcc command?

994

What do you mean by merge in oracle?

944

Name the various constraints used in oracle?

980

Design database draw er diagram for a certain scenario ?

4536

What is the difference between Delete, Truncate and Drop in Oracle?

1077

What is the difference between sharding and replication?

971