Interested to Buy Any Domain ? << Click Here >> for more details...
wirte the syntax of update query?
- 3 Answers
- 5616 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 |
Explain parameter file in oracle.
what is analyze command ? what kind of statistics does it generate?
What is oracle datasource?
a query to select maxmun 3 salaries of employee table
How to get execution statistics reports on query statements?
Query to get max and second max in oracle in one query ?
34 Answers CTS, Keane India Ltd, TCS, Wipro,
How many types of database triggers exist?
What are the numeric comparison operations?
Explain about integrity constraint?
8. Display the client name and order date for all orders using the natural join keywords.
How would you best determine why your MVIEW couldnt FAST REFRESH?
hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards
Oracle General 
