UPDATE <TABLE_NAME> SET COLUMN1=VALUE1,COLUMN2=VALUE2,COLUMN3=VALUE

what is the syntax of update command?

Question Posted / shahnaz

Answer Posted / shahnaz

UPDATE <TABLE_NAME> SET
COLUMN1=VALUE1,COLUMN2=VALUE2,COLUMN3=VALUE3.... WHERE
<CONDITION>

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How does one get the view definition of fixed views/tables?

1069

What are named parameters?

1142

Is the After report trigger fired if the report execution fails ?

2950

What is a nested table and how is it different from a normal table?

1101

What is the usage of control file in oracle?

1141

How to write numeric literals in oracle?

1233

How to create id with auto_increment on oracle?

1035

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

2202

What are temporal data types in oracle?

1164

Give the various rollback segment states.

1085

How to define an oracle cursor variable?

1090

What is the difference between PFILE and SPFILE in Oracle?

1106

what is dynamic SGA and static SGA

4481

What is meant by recursive hints in oracle?

1127

How do I connect to oracle database?

1196