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 are the default admin accounts in Oracle 10g ?

512


What are the differences between char and varchar2 in oracle?

567


What are the original export and import utilities?

576


What would you do with an in-doubt distributed transaction?

1476


what is the scenario where you take the database to NoArchivelog mode?

1843






If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?

1805


What is a trigger and what are its types in oracle?

539


Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun

1668


I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.

1866


Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1485


How does Oracle guarantee data integrity of data changes?

1942


How to write text literals in oracle?

619


What are triggers in oracle?

567


How to write a query with a right outer join in oracle?

622


what is reindexing?

1184