Interested to Buy Any Domain ? << Click Here >> for more details...
wirte the syntax of update query?
- 3 Answers
- 5355 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 data file?
How to load data from external tables to regular tables?
Display Odd/ Even number of records?
What are the roles of dba?
how will I find the first 5 highest salaried employees in each dept in oracle.
What is the difference between an Oracle Schema and an Oracle Instance?
Can we use bind variables in oracle stored procedure?
Maximum how many triggers can be updated in table ?
5 Answers Accenture, Cap Gemini,
How can we find out the duplicate values in an oracle table?
How to view all columns in an existing table?
can a table has a column that has only view data and in other columns we can change data?
Is it possible to enter only time value into a column of a table in sql?
Oracle General 
