Answer Posted / shivaleela
Cartesian product:- It is a type of join in which the
number of rows in the result table is the product of the
number of rows in each table.It is also called as CROSS JOIN
Eg:-
SELECT * FROM A,B
or (can be writen as)
SELECT * FROM A CROSS JOIN B
if A has 10 records n B has 8 records than the output of
above query will b 80 records(10*8=80 RECORDS).
Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
What are the different tools available for hot backups in Oracle? Is it preferable to take it manually all the time or it depends on the size of the database?
What are the interface tables used for ar invoices, customers, receipts for conversion process? : oracle accounts receivable
PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE
Explain the difference between $ORACLE_HOME and $ORACLE_BASE.
how can we add a field to the oracle standard forms through Form Persanlization or custom.pll
What are different types of transactions in ar? : oracle accounts receivable
what is semphore explian it?
WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?
What is Restricted Mode of Instance Startup in Oracle?
how to replace not in with not exist?
what are the types of LIST REPORTS in cognos8BI? and what is the mean and use of METRIC STUDIO in Cognos 8.3BI?
What is an Oracle database Partial Backup?
Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.
please send me oracle pl/sql exp resume. and also faqs...
WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?