Interested to Buy Any Domain ? << Click Here >> for more details...
wirte the syntax of update query?
- 3 Answers
- 5323 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 |
Q) How to Find Max Date from each Group? (Asked in Infosys (INFI)Interview)
What is a read write transaction in oracle?
How to count groups returned with the group by clause in oracle?
Why cursor variables are easier to use than cursors?
Explain about integrity constraint?
What is the use of Redo Log Information ?
How to estimate disk space needed for an export job?
6. Display the client name and order date for all orders using the traditional method.
What are the limitations oracle database 10g xe?
What are group functions in oracle?
What is the use of oracle?
I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.
Oracle General 
