wirte the syntax of update query?

Answers were Sorted based on User's Feedback



wirte the syntax of update query?..

Answer / nageswararao.k

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

Is This Answer Correct ?    6 Yes 0 No

wirte the syntax of update query?..

Answer / irshad ahmad

SQL> UPDATE table_name SET column1=value,
column2=value2,...
[WHERE condition];
for Example:-
Sql> UPDATE customers SET address = ‘250 Azad Road’ WHERE
customerid = 4;

Is This Answer Correct ?    6 Yes 0 No

wirte the syntax of update query?..

Answer / 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

Post New Answer

More Oracle General Interview Questions

Whether Oracle satisfy more codd rules or db2 satisfy more codd rules? How meny of each can satisfy ? Please answer me. Advance thanks

2 Answers   IBM,


Difference between open_form and call_form in oracle.

0 Answers  


How to change user password in oracle?

0 Answers  


Whether any commands are used for months calculation? If so, what are they?

0 Answers  


An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?

0 Answers  






How to define a data source name (dsn) in odbc manager?

0 Answers  


Why we choose emp number as primarykey?

4 Answers  


What is a SNAPSHOT ?

1 Answers  


i want to know about mr.b.kotravel......who has answered for second maxmium salary from employee table

3 Answers  


Hi all, Can any one give answer for this question. Suppose im having employee table with fields, eno, ename, dept, address1, address2, address3. In address field employee can fill only address1 or address2 or address3... at a time he can fill three address fields. now i want all employee names who filled only one address field.. Plz its urjent can any one give querry.. Thanks in advance.

4 Answers   JPMorgan Chase,


how to get count of tables in particular database in Oracle?

3 Answers  


How do I call oracle stored procedures that take no parameters?

0 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)