what is the syntax of UPDATE command?

Answer Posted / naweed ahmad

UPDATE TABLE NAME SET COLUMN NAME=NEW VALUE
WHERE CONDITION;
--(WHERE CONDITION IS OPTIONAL)

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is oracle open database communication (odbc)?

753


why dont we assign not null constraint as table level constraint.

2497


What is max rowid in oracle?

777


I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?

2218


Explain what are clusters?

841


How to test null values?

846


Differentiate between translate and replace?

810


What is set verify off in oracle?

824


What is meant by an index?

813


How does oracle handle read consistency?

883


Explain the characteristics of oracle dba?

870


What is the difference between formal parameters and actual parameters?

740


How to find out what oracle odbc drivers are installed?

808


Explain the use of indexes option in exp command.

774


Explain the use of tables option in exp command.

829