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 shutdown your 10g xe server from command line?

1 Answers  

---

How a database is related to tablespaces?

1 Answers  

---

Can cursor variables be stored in PL/SQL tables.If yes how. If not why?

1 Answers  

---

How much memory your 10g xe server is using?

1 Answers  

---

how to join query for one source type is oracle another source type is sql server ?

1 Answers   iGate,

---

does the query needs a hint to access a materialized view?

1 Answers  

---

What is the maximum limit on the number of columns in a table?

1 Answers  

---

what is cartesian product?

2 Answers  

---

Can a formula column referred to columns in higher group ?

1 Answers   Oracle,

---

What is the difference between hot backup and cold backup in oracle?

1 Answers  

---

i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?

1 Answers   Oracle,

---

If a table column has is UNIQUE and has NOT NULL, is it equivalent to a PRIMARY KEY column?

8 Answers   IBM,

---