Interested to Buy Any Domain ? << Click Here >> for more details...
wirte the syntax of update query?
- 3 Answers
- 5501 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 OUTER JOIN?
What is a cluster Key ?
if you update view? where we store the data?
How to list all indexes in your schema?
How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?
where we have to use ON clause and where we have to use USING clause in JOINS
What are the types of trigger in oracle?
What is a Database instance ? Explain?
What is the oracle implicit cursor?
What is a tns file?
What would you do with an in-doubt distributed transaction?
State and explain about oracle instance?
Oracle General 
