wirte the syntax of update query?
- 3 Answers
- 4781 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 meant by raw datatype?
How to list all indexes in your schema?
What is the effect of setting the value 'FIRST_ROWS' for OPTIMIZER_GOAL parameter of the ALTER SESSION command ?
What is a data lock in oracle?
What is the difference between an Oracle Schema and an Oracle Instance?
What is the relationship among database, tablespace and data file?
How can we find the size of a database?
2. Display the post code and the total number of purchase orders placed with creditors in that post code.
What is set verify off in oracle?
Can you create a synonym without having a table?
Why we choose emp number as primarykey?
What are the four Oracle system processes that must always be up and running for the database to be useable?
Oracle General 
