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.

Does pdo prevent sql injection?

0 Answers  

---

What is a pl/sql block?

0 Answers  

---

What is normalization sql?

0 Answers  

---

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

0 Answers  

---

write a procedure to print a statement or number not using "dbms_output.put_line" package.write a procedure instead of it using procdure name as "print" ex:- declare a number:=2; begin print(a); end; /* when U type above procedure 2 have to should be printed*/

2 Answers   iFlex,

---

what are the differences among these table level lock modes - IN SHARE MODE, IN SHARE UPDATE MODE, IN EXCLUSIVE MODE ?

3 Answers   HCL,

---

What are the basic techniques of indexing?

0 Answers  

---

I have a table with 1 million records out of which 10,000 records are of unique records, then if I will implement index, then which type of index shall I use and why shall I use?

2 Answers   HSBC,

---

What is cold data?

0 Answers  

---

What is before trigger?

0 Answers  

---

can i use dbms_output.put_line in a function u are telling as return statement

7 Answers  

---

how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba

0 Answers  

---