wirte the syntax of update query?

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?

1841


How to select some columns from a table in oracle?

559


You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

1466


Can objects of the same schema reside in different tablespace?

598


How do we get field detail of a table?

639






Can multiple columns be used in group by in oracle?

556


Why is oracle used?

563


What is the data pump export utility?

657


What is a partition in oracle?

555


Explain about functional dependency and its relation with table design?

562


How to start a new transaction in oracle?

597


In which language oracle has been developed?

661


Explain the use of indexes option in imp command.

578


How to create an oracle testing table?

607


How to generate query output in html format?

575