Answer Posted / svj

Using SQL Cursor Attribute,'SQL%ROWCOUNT' which gives
no.of rows affected by the most recentSQL statement (an
integer value), one can know no.of records got updated.

For Example :

VARIABLE rows_updated VARCHAR(30)
DECALRE
v_dept_no departments.department_id%TYPE := 20
BEGIN
UPDATE employees
SET salary = salary + 1000
WHERE department_id = v_dept_no;
: rows_updated := (SQL%ROWCOUNT || 'rows updated.');
END;
/
PRINT rows_updated

Write a trigger example in oracle?

978

---

What is a trigger and what are its types?

1112

---

What are operators in oracle?

1008

---

what is Single Byte Overhead...?

2497

---

What is the relation of a user account and a schema?

1060

---

How do I know if oracle client is installed on windows?

951

---

What is java oracle used for?

963

---

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.

1368

---

What is a trigger oracle?

1037

---

What are the predefined tablespaces in a database?

1006

---

What is oracle sid?

886

---

How to view the data files in the current database?

1038

---

What is data block in Oracle?

1047

---

Explain oracle left join with an example?

952

---

What is an oracle tablespace?

981

---