what is the syntax of UPDATE command?

Answer Posted / shalya

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

Is This Answer Correct ?    23 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to list all user accounts in oracle?

603


How data locks are respected in oracle?

566


How can you merge two tables in oracle?

562


Name the various constraints used in oracle?

560


How to pass parameters to procedures in oracle?

565






How to use windows user to connect to the server?

527


How to filter out duplications in the returning rows using oracle?

633


What is the implicit cursor in oracle?

557


What happens to indexes if you drop a table?

686


How to install oracle database 10g xe?

556


How translate command is different from replace?

542


What is redo log?

617


if you ctreate table identity

1839


What is a connect identifier?

536


How to create a new table by selecting rows from another table?

546