Answer / Rupesh Kumar

The UNION operator combines rows from two or more SELECT statements and returns the result as a single table. It can be used when you need to combine the results of multiple queries, but the structure (number of columns and their names) must be identical.

what are the differences among rownum, rank and dense_rank? : Sql dba

1 Answers  

---

What is the difference between CHAR and VARCHAR2? If VARCHAR2 serves the uses of CHAR why CHAR is still used and not been discarded yet?

9 Answers   Oracle,

---

What is a database link?

3 Answers  

---

Explain the types of joins in sql?

1 Answers  

---

What are the Restrictions on Cursor Variables?

2 Answers  

---

How to display the current date in sql?

1 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 expressions?

1 Answers  

---

Why do we need pl sql?

1 Answers  

---

What is clause?

1 Answers  

---

What are the commands used in sql?

1 Answers  

---

diff b/w function and procedure?

9 Answers   iFlex,

---