update <table-name> set column-name<condition> where <condit

wirte the syntax of update query?

Question Posted / sudhakar

Answer Posted / sudhakar

update <table-name> set column-name<condition> where <condition>
ex:
update dept set desg='manager' where deptid=111;

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is the difference between post-database commit and post-form commit?

1286

What are the most common interview questions on ETL Testing for experience?

1189

How to write a left outer join with the where clause in oracle?

1132

How to import one table back from a dump file?

1085

What is the difference between translate and replace?

1118

How to divide query output into groups in oracle?

1032

What is a table in oracle?

1022

How a database is related to tablespaces?

1083

How to delete a user account in oracle?

1021

How would you best determine why your MVIEW couldnt FAST REFRESH?

1932

How to grant create session privilege to a user in oracle?

1052

Can we store pictures in the database and if so, how it can be done?

1089

Can we call procedure inside function in oracle?

1149

How to use like conditions in oracle?

1115

What is dynamic proxy?

1052