Answer Posted / 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 bcp? When does it used? : Sql dba

1065

---

What is your daily office routine?

2353

---

what is dbms? : Sql dba

1070

---

Can we rollback truncate?

1083

---

how to escape special characters in sql statements? : Sql dba

1124

---

If a cursor is open, how can we find in a pl/sql block?

1252

---

what are all the common sql function? : Sql dba

1141

---

What is the current version of sql?

1106

---

How do I remove duplicates in two columns?

1202

---

what is schema? : Sql dba

1163

---

how to start mysql server? : Sql dba

1279

---

define sql insert statement ? : Sql dba

1110

---

Do we need to rebuild index after truncate?

1155

---

Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

2102

---

Does group by remove duplicates?

1121

---