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 can we connect an Android App to an Oracle database and use the PL/SQL procedural code?

1134

---

What are the sql commands?

1165

---

How do you remove duplicate records from a table?

936

---

explain mysql aggregate functions. : Sql dba

981

---

What is a procedure in pl sql?

1206

---

If the application is running very slow? At what points you need to go about the database in order to improve the performance?

991

---

Is foreign key mandatory?

998

---

What is difference between ms sql and mysql?

956

---

What is scalar data type in pl sql?

1060

---

Can a select statement fire a trigger?

1152

---

What is left join example?

940

---

How do I order by ascending in sql?

1003

---

what is the difference between group by and order by in sql? : Sql dba

1114

---

What is the use of sql trace?

947

---

What is difference between sql and excel?

1081

---