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 the difference between nested subquery and correlated subquery?

983

---

What are the various levels of constraints?

1058

---

What does partition by mean in sql?

907

---

Which table is left in join?

913

---

What is trigger with example?

1010

---

How many primary keys can a table have?

949

---

Do we need to rebuild index after truncate?

972

---

Why schema is used in sql?

983

---

Which table is left in left join?

951

---

Does view store data in sql?

897

---

What is a scalar value in sql?

1010

---

What is t-sql? : Transact sql

925

---

table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

4092

---

What is integrity in sql?

979

---

Where are my tempfiles, I don't see them in v$datafile or dba_data_file?

943

---