Answer / saiprasanna

in ansi style the join condn can be given bu using "ON-clause"
or by using "USING-clause".
"USING" clause can be used if common column name is same other
wise "ON" clause is used.
ex:-select e.ename,d.dname from emp e join dept d on e.deptno
=d.deptno;
select e.ename,d.dname from emp e join dept d using(deptno);

Answer / vipul.solanki

It gives same result.when colum name is same then we can use
Using clause

with use USING :

SELECT * FROM MENU_MASTER MM JOIN MENU_ROLE_METRIX MRM
USING(NMENUNO);

with use ON :

SELECT * FROM MENU_MASTER MM JOIN MENU_ROLE_METRIX MRM ON
MM.NMENUNO = MRM.NMENUNO;

How to retrieve first and last records from a table?

7 Answers   DELL, QSmart,

---

How to create a table index?

0 Answers  

---

How to create a stored program unit?

0 Answers  

---

How to create a new user account in oracle?

0 Answers  

---

What does `(+)` do in a where clause?

1 Answers  

---

What are Schema Objects ?

2 Answers  

---

What the is the diff between local index and global index. give some example.

0 Answers   TCS,

---

difference between procedures and function?

7 Answers   IBM,

---

What are the differences between date and timestamp in oracle?

0 Answers  

---

What is difference between a formal and an actual parameter?

1 Answers  

---

what are the different types of cursors? explain?

4 Answers  

---

What does sharding mean?

0 Answers  

---