Why truncate is used in sql?

0 Answers  

---

table - new_no old_no 2345 1234 3456 2345 5678 4567 output sud be -new_no 1234 2345 3456 4567 5678

2 Answers  

---

Suppose There is a string A.B....C.......D.........E........F In this string dots (.) are not having fixed count in between of string. I want the output to have string with one dot between. I.e. A.B.C.D.E.F

6 Answers   IBM,

---

Which column of the user triggers data dictionary view displays the database event that will fire the trigger?

0 Answers  

---

What is a database? Explain

0 Answers  

---

What is sql lookup?

0 Answers  

---

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

0 Answers  

---

what is oracle sql,pl/sql with interfaces

2 Answers   TCS,

---

How to find 3rd highest salary of an employee from the employee table in sql?

0 Answers  

---

Do we need to rebuild index after truncate?

0 Answers  

---

Give an example of any procedure.

5 Answers   Accenture, iFlex, Wipro,

---

How do I access sql anywhere database?

0 Answers  

---