Explain the usage of WHERE CURRENT OF clause in cursors ?

3 Answers  

---

What is trigger in sql? Explain

0 Answers  

---

Is pl sql a scripting language?

0 Answers  

---

Is like operator in sql case sensitive?

0 Answers  

---

Why is the cursor important?

0 Answers  

---

Is sql a dbms?

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  

---

What is the maximum number of rows in sql table?

0 Answers  

---

What is pl sql package?

0 Answers  

---

What is the difference between sql, mysql and sql server?

0 Answers  

---

What does a pl/sql package consist of?

0 Answers  

---

First round ------------------- - Procedure - Packages - Views - Virtual tables - Can we use dcl with in function? - Joins and few scenarios - Triggers and its type - Pragma, type and its functionality - How to create db link in oracle - Materialized view - How to find duplicate values from table? - Cursor and its functionality - Write a script to display friday and its date from a entire year. - Exception Handling Second round ------------------------ Gave a scenario like. Need to write a function to perform. When user try to change a password. It must not be last five password and a given password can be combination of characters, symbols, upper and lower case.

0 Answers   Prodapt,

---