Answer / m.m

1 will be printed as many times as the number of rows in
emp table
followed by 2 begin printed as many times as the number of
rows in emp table
OP:
1
----------
1
1
1
1
1
1
1
1
1
1
1

1
----------
1
1
1
2
2
2
2
2
2
2
2

1
----------
2
2
2
2
2
2

28 rows selected.

Answer / ankush

it returns the number 1 same number columns as well as
union with the value 2 again with the same number of
columns the table emp have.

How much does sql cost?

0 Answers  

---

Is it possible to sort a column using a column alias?

0 Answers  

---

I want to display the employees who have joined in last two months. (It should be executed randomly means If I execute the query in March it should display Jan and Feb joined employees. Same query if i execute in Feb, 2007 it should display dec, 2006 and jan 2007 joined employees.

15 Answers   Wipro,

---

What is different between union and minus?

7 Answers   Accenture, TCS,

---

What is recursive stored procedure?

0 Answers  

---

Is pl sql and postgresql same?

0 Answers  

---

How to run sql functions in pl/sql?

0 Answers  

---

What is the difference between database trigger and stored procedure?

0 Answers  

---

using comand prompt how can import table data and table space with example

2 Answers  

---

How to get help at the sql prompt?

0 Answers  

---

Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?

0 Answers  

---

Do triggers have restrictions on the usage of large datatypes, such as long and long raw?

0 Answers  

---