Answer / Pradeep Kumar Verma

{"bind reference": "A mechanism in PL/SQL that allows a variable to refer to another variable, a cursor or a collection.", "creation": "Bind references are typically declared using the ':=' operator. For example: :new_var := old_var; This assigns the value of old_var to new_var.", "example": "DECLARE p VARCHAR2(10); BEGIN :p := 'Hello'; DBMS_OUTPUT.PUT_LINE(:p); END;"}

What is a function in oracle pl sql?

1 Answers  

---

When do we create bitmap indexes

2 Answers   CTS,

---

What is the cause of mutating table error and how can we solve it?

1 Answers  

---

How can I delete duplicate rows?

1 Answers  

---

What is %type in sql?

1 Answers  

---

There is a sequence with min value 100. I want to alter this sequence to min value as 101. If the table has already data in the sequence column as 100,101,102... Is it possible to do so ?

4 Answers   IBM,

---

What is pl sql quora?

1 Answers  

---

using subquery how can i calculate working days in a month?

3 Answers   Spice Telecom,

---

Hi Everyone, How to get fist and last record from a table in oracle? Thanks in advance

13 Answers   IBM,

---

Is join an inner join?

1 Answers  

---

Why is pl sql needed?

1 Answers  

---

How do we use distinct statement? What is its use?

1 Answers  

---