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 are the different types of partitions in oracle?

930

Explain the use of analyse option in exp command.

1082

Describe an oracle table?

1005

What are the parameters that we can pass through a stored procedure?

1015

What is difference between truncate and delete?

994

What is ceil and floor in oracle?

1026

How do I escape a reserved word in oracle?

1155

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1895

How do I start tns listener?

999

How to use "while" statements in oracle?

1257

what is the use of system.effective.date variable in oracle?

1070

What is hot backup and logical backup?

1015

Explain the difference between sql and oracle?

1042

What is the exact use of Collections?

2108

Is java required for oracle client?

941