Answer / nageswararao.k

update <table_name> set
(<colname> <condition>)[where<condition>];

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;

Answer / sudhakar

update <table-name> set column-name<condition> where <condition>
ex:
update dept set desg='manager' where deptid=111;

What is literal?

0 Answers  

---

What is enter substitution variable in oracle?

0 Answers  

---

What is data type in oracle?

0 Answers  

---

If a table column has is UNIQUE and has NOT NULL, is it equivalent to a PRIMARY KEY column?

8 Answers   IBM,

---

What are the limitations oracle database 10g xe?

0 Answers  

---

create one table to capture an employee details with a primary key.

1 Answers   CTS,

---

You have one employee table having 3 entries emp_id, Mgr_id and salary. Mgr_id is also referencing emp_id. so now find out the emp_id which are having the second highest salary, under a particular manager.

3 Answers   Amazon, HCL,

---

What a SELECT FOR UPDATE cursor represent.?

1 Answers  

---

18. Display the clientno and total value for all orders placed by that client. Output the result in the following format: Client <clientno> has placed orders to the value of <total value>

2 Answers   Wipro,

---

what is dynamic SGA and static SGA

0 Answers   Oracle,

---

Is there an oracle sql query that aggregates multiple rows into one row?

0 Answers  

---

According to oracle specification VIEW is a object. OBJECT that means anything stored in the oracle database that has the physical existence.why VIEW doesn't take memory in oracle database, but it is treated as a object ?Please explain ?

2 Answers  

---