What is an alias command?

0 Answers  

---

full outer join syntax

5 Answers  

---

What is pragma exception and how, when, where us

5 Answers  

---

What is recursive stored procedure?

0 Answers  

---

what is global table

7 Answers   iFlex,

---

Define commit, rollback and savepoint?

0 Answers  

---

How will you a activate/deactivate integrity constraints?

2 Answers  

---

What is execute immediate?

0 Answers  

---

what will be the output: select 1 from emp union all select 2 from emp;

2 Answers   iNautix,

---

In table a 1lakh data is present,in table b 20 thousand data is present, to get unique data from table a and b which join to be considered. whether right outer join or left inner join. 

2 Answers   GE,

---

What are the different parts of a package?

0 Answers  

---

I have the table like this S.No Name ID 01 Xyz 123 I want the result as 01Xyz123 How to write the query to retrieve the entire row data in a single column?

1 Answers  

---