Update table name set <column name>= New value where <condition&

what is the syntax of UPDATE command?

Question Posted / jyoti ranjan samal

Answer Posted / jyoti ranjan samal

Update table name
set <column name>= New value
where <condition>

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Please explain joins in oracle?

1045

Is there any function in oracle similar like group_concat of mysql?

1035

How to view existing locks on the database?

1030

Where are the settings stored for each instance in oracle?

1093

Explain the use of parfile option in exp command.

1049

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?

2806

How many anonymous blocks can be defined?

1161

What do you mean by group by clause?

1022

Difference between hot backup vs. Cold backup?

969

What are the different types of record groups in oracle? Explain each of them

1006

How to see the table columns used in an index?

996

What are the tools for Oracle ?

1040

What is oracle rownum?

930

What are the different types of trigger and explain its various uses and functions?

1064

What is a trace file and how is it created in oracle?

1025