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 bcp? When does it used? : Sql dba

1030

---

how many sql ddl commands are supported by 'mysql'? : Sql dba

1065

---

what are the properties and different types of sub-queries? : Sql dba

1075

---

what is the use of friend function? : Sql dba

1061

---

What version is sql?

1076

---

Why do we use sql constraints? Which constraints we can use while creating database in sql?

1086

---

Does user triggers have entry for trigger with compilation errors?

1091

---

Is microsoft sql free?

1142

---

Is sql pronounced sequel or sql?

1339

---

What is a behavioral trigger?

1024

---

How many sql databases can you have on one server?

1153

---

How do you update a sql procedure?

1092

---

what is a unique key ? : Sql dba

1149

---

What are the steps for performance tuning.

1395

---

Does execute immediate commit?

1291

---