what is difference between cartesian join & cross join even
they give same result?

Answer Posted / prem

cross join gives some duplicate results but the cartesian
join give accurate result

Is This Answer Correct ?    5 Yes 12 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the differences between date and timestamp in oracle?

554


What is oracle open database communication (odbc)?

561


Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables

1583


What is a trigger oracle?

565


How to use subqueries with the in operator using oracle?

614






What is Data Dictionary Cache in Oracle?

664


How to start instance with a minimal initialization parameter file?

539


Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.

860


ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process

1749


What is the data pump import utility?

585


Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun

1666


What is a procedure in oracle?

618


how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?

1533


What are the attributes of the cursor?

561


What is an oracle user account?

582