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

Calculate difference between 2 date / times in oracle sql?

559


Explain what are the uses of rollback segment?

574


Explain enable novalidate constraint.

591


Explain joins in oracle?

556


what is the difference between data migration and production migration.

1801






When do you get a .pll extension in oracle?

671


what is meant by magic query

1764


What is a partition in oracle?

538


What is a nvl function? How can it be used?

551


What is archive log in Oracle?

591


Where do we use decode and case statements?

547


Whats the benefit of dbms_stats over analyze?

1487


How can I get column names from a table in oracle?

526


What are the attributes of cursor?

581


Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.

1857