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

For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?

2028

How to drop a stored function?

1139

How to specify default values in insert statement using oracle?

1111

How to save query output to a local file?

1029

What is the difference between translate and replace?

1067

How to initialize variables with default values?

1249

Explain database link?

1129

How to see the table columns used in an index?

1024

What is the difference between hot backup and cold backup in oracle?

1014

1) Does oracle have any table which contain all the exceptions and it's code internally?

1752

What is a synonym? What are its various types?

1110

How can we force the database to use the user specified rollback segment?

1149

What is a connect identifier?

1042

How do I spool in oracle?

1012

What is oracle database client?

1035