UPDATE TABLE NAME SET COLUMN NAME=NEW VALUE WHERE CONDITION; --(WHERE CON

what is the syntax of UPDATE command?

Question Posted / naweed ahmad

Answer Posted / naweed ahmad

UPDATE TABLE NAME SET COLUMN NAME=NEW VALUE
WHERE CONDITION;
--(WHERE CONDITION IS OPTIONAL)

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How many types of cluster table in Oracle?

984

What is a data dictionary and how can it be created?

1052

How to get execution path reports on query statements?

926

What is the meaning of recursive hints in oracle?

992

How to pass parameters to procedures in oracle?

990

List the parts of a database trigger.

986

How to divide query output into groups in oracle?

942

Can we write dml statement in function in oracle?

1021

How do I recompile a procedure in oracle?

907

What is the difference between hot backup and cold backup in oracle?

951

How to insert a new row into a table in oracle?

1087

What are the various oracle database objects?

1089

Explain an extent?

1047

What are the built-in functions used for sending Parameters to forms ?

3307

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

961