wirte the syntax of update query?
- 3 Answers
- 4509 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 |
how to retrive xml data for using sql query?
How to use subqueries with the exists operator in oracle?
What is the order of defining local variables and sub procedures/functions?
What is a read write transaction in oracle?
what is Materialized view? What is a snapshot? what are the similarities and differences between Materialized views and snapshots?
Explain an extent?
Youre getting high busy buffer waits - how can you find whats causing it?
What is the string concatenation operator in oracle?
What is materialized view in Oracle?
What is self-referential integrity constraint ?
Two triggers one is before insert and other is after insert are firing on a table.If 10 times you insert in a table.Then how many times before trigger and how many types after trigger will fire in pl/sql.
How to omit columns with default values in insert statement in oracle?
Oracle General 
