Answer Posted / anil_abbireddy

database link establishes a link between two databases
there are 3 type os database links
1. private
2. public
3. network

What is pragma in sql?

1125

---

Which one is better subquery or joins?

1114

---

What is cursor status?

1235

---

What is a memo field?

1015

---

what is a relationship and what are they? : Sql dba

1162

---

i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this

1630

---

If the application is running very slow? At what points you need to go about the database in order to improve the performance?

1049

---

what are all the different normalizations? : Sql dba

1114

---

Explain autonomous transaction.

1218

---

What is localdb mssqllocaldb?

1106

---

What is sql partition?

1161

---

How to display the current date in sql?

1127

---

Does mysql support pl sql?

1228

---

What is the basic structure of an sql?

1154

---

Which data type is a composite type?

1035

---