wirte the syntax of update query?
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 partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
What are virtual columns?
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
What is PL/SQL ?
What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.
Please explain oracle data types with examples?
How to start an oracle instance?
Explain cascading triggers.
What is a schema in oracle?
How to sort the query output in oracle?
What do you know about normalization? Explain in detail?
What is tns name?