what is the syntax of UPDATE command?

Answer Posted / rajini

As per my knowledge first and third one is correct.That is

UPDATE <table name> SET <column name>=<new value> WHERE
<condition>;

Is This Answer Correct ?    9 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is backup in Oracle?

577


What is an index associated with a constraint?

557


Explain the use of record option in exp command.

543


How to create tables for odbc connection testing?

499


What are the different pseudo commands? Explain in general?

547






What is oracle instant client?

575


i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)

1809


How can I convert single byte kana characters into multi byte kana characters and vice-versa.

1941


what is Single Byte Overhead...?

2070


what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?

1854


What are the differences between primary key and unique key?

517


What are the different types of failures that occur in Oracle database?

606


How to define an explicit cursor in oracle?

605


How to write a query with a left outer join in oracle?

609


Why use resource manager in Oracle?

671