Answer Posted / guneetinder singh

update query depends upon no. of column two tables contain.

declare
salary number:=&salary;
procedure guneet(s in number) as
begin
update emp set sal = sal+s;
update gesture set sal1 = sal1+s;
end guneet;
begin
guneet(salary);
end;

--------------------------------------------------------------
declare
procedure multiple() as
begin
select * from emp;
end multiple;
begin
guneet();
end;

What is the use of aggregate functions in oracle?

987

---

I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance

2269

---

How do I know if oracle is installed on windows?

889

---

What is oracle in java?

923

---

Give syntax for SQL and ORACLE joins.

1058

---

What are the roles of dba?

1032

---

How to assign a tablespace to a users in oracle?

1006

---

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

1947

---

State the difference between a primary key and foreign key?

896

---

What is a nvl function? How can it be used?

970

---

What is a user account in oracle?

1074

---

How many types of synonyms in Oracle?

1078

---

HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.

1384

---

What is Java Pool in Oracle?

1104

---

How to do paging with oracle?

958

---