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

Can group functions be used in the order by clause in oracle?

1041

What do you mean by redo log file mirroring?

1066

How many categories of data types?

1038

What is a package ? What are the advantages of package ?

1136

Where do we use decode and case statements?

1058

What is a dead lock in oracle?

1175

What is sequence?

1136

What is an oracle data file?

1153

What is a private synonym?

1642

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

1281

How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?

3244

What is transport network substrate (tns) in oracle?

1091

What is blob datatype?

1191

What is max rowid in oracle?

1079

what is the difference between functional dependecy and multilevel dependency?

2514