what is the syntax of update command?

Answer Posted / shahnaz

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

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


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