what is the syntax of UPDATE command?

Answer Posted / jyoti ranjan samal

Update table name
set <column name>= New value
where <condition>

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can sub procedure/function be called recursively?

748


Why does for update in oracle 8 cause an ora-01002 error?

748


Explain the use of consistent option in exp command.

734


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

818


Explain how you would restore a database using RMAN to Point in Time?

1884


How to export data to a csv file?

840


How index is implemented in oracle database?

771


How to use "in out" parameter properly?

797


What is the use of file param in imp command?

889


How to delete a column in an existing table in oracle?

811


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

759


Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.

1075


Can we convert a date to char in oracle and if so, what would be the syntax?

771


Explain the dml?

765


State some uses of redo log files?

764