Interested to Buy Any Domain ? << Click Here >> for more details...
wirte the syntax of update query?
- 3 Answers
- 5624 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 autonomous transaction?
How to define Data Block size ?
Explain what are the characteristics of data files?
Explain implicit cursor.
How is it different from a normal table?
How to Remove the 3rd highest salary person record from table?
What is the maximum limit on the number of columns in a table?
Which is faster join or subquery in oracle?
how can we write trigger in trigger???????? can we write one trigger on two table???
how to i write the query 'NISHI' TO N I S H I
4 Answers Attra, Metric Stream,
How to retrieve 5th highest sal from emp table?
how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?
Oracle General 
