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 |
Give the constructs of a package, function or a procedure.
Where do you use decode and case statements?
Explain oracle insert into command?
How to get a list of all background sessions in the database?
Will you be able to store pictures in the database?explain.
What is index-organized table in Oracle?
Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?
What are the execution control statements?
4. Display the order number and client number from the ORDER table. Output the result in the format. Client <clientno> ordered <orderno>
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
A USER HAVING CREATE SESSION PREVILAGE CAN ALTER PASSWORD/CHANGE PASSWORD?
How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.