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;

What is oracle sid?

0 Answers  

---

How many memory layers are in the shared pool?

1 Answers  

---

How to write a query with a left outer join in oracle?

0 Answers  

---

How to restrict the duplicate records in table valuesets

2 Answers   IBM,

---

how can we write trigger in trigger???????? can we write one trigger on two table???

2 Answers   Value Labs,

---

What is set operator oracle?

0 Answers  

---

How can you Enforce Referential Integrity in snapshots ?

1 Answers  

---

How do I manually uninstall oracle client?

0 Answers  

---

What is Network Database link ?

1 Answers  

---

Difference between NO DATA FOUND and %NOTFOUND?

1 Answers  

---

What is Read-Only Transaction ?

3 Answers  

---

9)When information has to be stored w.r.t employees and their respective departments, which of the following is the Correct formulation of entries? A)Employee and department would together be represented as an entity. B)This is too less information to decide on entities. C)An employee would be one entity and a department would be another. D)Such a scenario cannot be modelled in RDBMS

2 Answers   Mind Tree,

---