What is primary key and foreign key?

0 Answers  

---

What are packages in pl sql and also explain its advantages?

0 Answers  

---

Which clause of an UPDATE statement allows you to affect only certain rows of a table? 1. The WHERE clause 2. The SET clause 3. The ROWS AFFECTED clause 4. The ORDER BY clause

6 Answers   HCL,

---

What will you get by the cursor attribute sql%rowcount?

0 Answers  

---

What is the starting oracle error number?

0 Answers  

---

---

how do you restrict number of rows for a particular value in a column.For example:there is a table called fruits,having apples,bananas ,papayas.I dont want to have more than 100 apples in that table ,so how can u restrict number of rows for apple to hundred?

6 Answers  

---

why use cursors?

5 Answers   Oracle,

---

3. Select sum(a) sum_1,max(a) max_1 ,count(a) count_1 from ( ( select 1 a from dual union all Select to_number(‘2011’) a from dual union all select 1 a from dual) union select 2 b from dual);

1 Answers   Fintellix,

---

Explain the difference in execution of triggers and stored procedures?

0 Answers  

---

What is the main difference between sql and pl/sql?

0 Answers  

---

Write the alter statement to enable all the triggers on the t.students table.

0 Answers  

---

What is a primary key example?

0 Answers  

---