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

How to connect to a remote server?

573


What is a procedure in oracle?

624


What is varray?

595


Explain temporal data types in oracle

625


Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables

1592






What is a sub query and what are the different types of subqueries?

634


What is an oracle user account?

597


What is meant by an index?

639


Can we connect to ORACLE db using Windows Authentication?

733


What are the database administrators utilities available?

590


Select all the employees who were hired in last 2 years and who works in dept where max managers are working.

2464


How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.

1629


How to use "startup" command to start default instance?

550


Give syntax for SQL and ORACLE joins.

644


Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?

946