Answer Posted / manoj

select level from dual connect by level<=10

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

---

how to convert character strings to dates? : Sql dba

1095

---

how to present a past time in hours, minutes and seconds? : Sql dba

1070

---

Where the sql database files are stored?

1075

---

what is the stuff function and how does it differ from the replace function? : Sql dba

1107

---

How many types of triggers are there in pl sql?

1119

---

What is dbo in sql?

1019

---

When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?

1172

---

How does sql profiler work?

1065

---

Why do we need pl sql?

1037

---

What is normalization in sql?

1063

---

what are tables and fields? : Sql dba

1103

---

How do I truncate a sql log file?

1132

---

what are null values? : Sql dba

1013

---

how do you login to mysql using unix shell? : Sql dba

1127

---