Answer Posted / kriti sinha

For in 10 rows in a single column
select level from dual connect by level<=10

for 10 numbers in a single column
select 1||chr(10)||2||chr(10)||3||chr(10)||4||chr(10)
||5||chr(10)||6||chr(10)||7||chr(10)||8||chr(10)||9||chr(10)
||10 from dual;

For 10 rows in 10 columns
select 1,2,3,4,5,6,7,8,9,10 from dual;

How delete all data from all tables in sql?

950

---

What are all the different types of indexes?

1149

---

How can you fetch first 5 characters of the string?

1018

---

How do you write an index?

970

---

List the various privileges that a user can grant to another user?

1044

---

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

2267

---

What is where clause in sql?

1043

---

What are pl/sql cursor exceptions?

1110

---

What is difference between hql and sql?

1085

---

What is thread join () in threading?

1017

---

What is pls_integer in pl sql?

1108

---

what is a field in a database ? : Sql dba

1063

---

What port does sql server use?

1065

---

What are the operators in sql?

1033

---

Is oracel sql developer written in java?

1114

---