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;

What is sql dialect?

1047

---

what are the different type of normalization? : Sql dba

980

---

Explain the components of sql?

1001

---

What are the benefits of pl/sql packages?

1048

---

Why do we use view in sql?

918

---

What is mdf ldf and ndf?

942

---

How does cross join work in sql?

967

---

What is clause?

1080

---

What is sql entity?

1040

---

What is mutating trigger?

982

---

How do you get column names only for a table (sql server)?

1109

---

Is sql microsoft?

990

---

Which is better trigger or stored procedure?

900

---

How many disk partitions should I have?

953

---

What is an inner join sql?

966

---