update <table_name> set (<colname> <condition>)[where&

wirte the syntax of update query?

Question Posted / nageswararao.k

Answer Posted / nageswararao.k

update <table_name> set
(<colname> <condition>)[where<condition>];

Is This Answer Correct ?

6 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Please explain joins in oracle?

1022

Use of an integrity constraint is better to validate data. Explain

998

Which is better Oracle or MS SQL? Why?

6294

Respected sir, Please send me technical questions related to oracle apps..

1779

Explain the use of rows option in exp command.

1044

How to define a data source name (dsn) in odbc manager?

984

How to store pictures on to the database?

934

What is oracle open database communication (odbc)?

982

How to convert a date to char in oracle? Give one example.

1015

What is procedure overloading in oracle?

1010

Explain enable novalidate constraint.

1048

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

2071

When do we use group by clause in a sql query?

1003

What is ceil and floor in oracle?

1025

Can you drop an index associated with a unique or primary key constraint?

981