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

What happens if you set the sga too low in oracle?

828

Differentiate between post-database commit and post-form commit?

815

How to compare dates in oracle sql?

880

Can we insert data in view oracle?

771

How to use null as conditions in oracle?

789

How to declare a local variable?

843

An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?

1844

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

821

What is the difference between primary key and unique key and foreign key in oracle?

786

How oracle handles dead locks?

838

How to add a new column to an existing table in oracle?

878

How to establish administrator authentication to the server?

808

What are the original export and import utilities?

793

From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.

845

How to end the current transaction in oracle?

790