Answer Posted / 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;

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1704

---

Write a trigger example in oracle?

810

---

What is a table in oracle?

736

---

What is PL/SQL ?

1416

---

What is the parameter mode that can be passed to a procedure?

811

---

Oracle

2155

---

how to make an oracle object

2110

---

How to use "while" statements in oracle?

966

---

Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?

1783

---

What is index-organized table in Oracle?

793

---

Explain the use of grant option in exp command.

778

---

how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?

1756

---

How to run the anonymous block again?

849

---

How to retrieve values from data fields in record variables?

804

---

What is merge statement used for?

779

---