update <table-name> set column-name<condition> where <condit

wirte the syntax of update query?

Question Posted / sudhakar

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

Please Help Members By Posting Answers For Below Questions

Explain the use of parfile option in exp command.

1063

What is open database communication (odbc) in oracle?

1001

can anyody please send me the dump for Oracle 10g certifications for DBA path?

2118

How to check your oracle database 10g xe installation?

983

Give the constructs of a package, function or a procedure.

1032

why should i declare foreign key constraint as self relation instead of binary relation in tables ?

2041

What exactly do quotation marks around the table name do?

957

Why does for update in oracle 8 cause an ora-01002 error?

998

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

4519

Can we write insert statement in function in oracle?

1081

types of indexes and the rationale behind choosing a particular index for a situation.

2505

How to recover a dropped table in oracle?

1036

How to define an anonymous procedure without variables?

1095

List out the components of logical database structure of oracle database.

1031

How to use values from other tables in update statements using oracle?

1076