wirte the syntax of update query?

Answer Posted / nageswararao.k

update <table_name> set
(<colname> <condition>)[where<condition>];

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to view existing locks on the database?

541


How do we get field details of a table?

540


How to pass parameters to procedures in oracle?

566


What is the purpose of tables, private synonyms and public synonyms in Oracle?

583


List the parts of a database trigger.

563






What is difference between cartesian join and cross join?

582


What is a nvl function?

557


What is SQL Tuning Advisor in Oracle?

625


Explain user account with reference to oracle.

524


What happens if variable names collide with table/column names?

578


Which environment variables are absolutely critical in order to run the OUI?

1642


How can we find out the duplicate values in an oracle table?

600


What is oracle update statement with inner join ?

575


Explain what are the characteristics of data files?

620


What is the difference between postgresql and oracle?

500