Answer Posted / swastik

SELECT
LPAD('*',ROWNUM,'*') Stars
FROM ALL_OBJECTS
WHERE ROWNUM <= 5

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

1537

---

Can we call a function containing dml statements in a select query?

917

---

What is the usage of distinct keyword?

1017

---

What are the two parts of design view?

973

---

What is a full join?

911

---

What is the difference between sql and mysql?

1051

---

Is left join inner or outer by default?

972

---

How much does sql cost?

930

---

what are the advantages of using stored procedures? : Sql dba

1058

---

What is a sql driver?

939

---

how to decrement dates by 1 in mysql? : Sql dba

967

---

What is pl sql in oracle?

989

---

How do I make sql search faster?

936

---

a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution

2200

---

How can I see all tables in sql?

986

---