Interested to Buy Any Domain ? << Click Here >> for more details...
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
key flexfield structure
HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?
How do you create a credit note against an invoice? : oracle accounts receivable
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
can u give guidance abt packages of plsql
i am working with OC 4.5 i have numbers in table in 10 row with some null values please tell me how to find total? Thanks
what is the link between suppliers and banks in ap module in oracle apps? And also query?
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 types of LIST REPORTS in cognos8BI? and what is the mean and use of METRIC STUDIO in Cognos 8.3BI?
default triggers available for reports
where the dff data will be stored
Difference between negative and positive adjustments : oracle accounts receivable
What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?
Why more redos are generated when the oracle database is in begin backup mode?
Can we modify approve purchase order?if yes what is navigation?
