Interested to Buy Any Domain ? << Click Here >> for more details...
wirte the syntax of update query?
- 3 Answers
- 5359 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / nageswararao.k
update <table_name> set
(<colname> <condition>)[where<condition>];
| Is This Answer Correct ? | 6 Yes | 0 No |
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 |
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 |
What is a nvl function?
how many types of index?
What are the differences between a sys and system user and what are the extra privileges available to the sys user?
How do you ensure database security?
what is the scripts in data base?
How to write a query with an inner join in oracle?
What do you mean by merge in oracle?
How to end the current transaction in oracle?
what is the difference between joins and set operators.i am always confusing with two,can u pls kindly help me .
hai, I am searching job on Oracle10g and PL/sql,Unix... can any one send me resume format. an suggest me how to prepare.. ann books..
What is background process in Oracle?
Can you create a synonym without having a table?
Oracle General 
