Interested to Buy Any Domain ? << Click Here >> for more details...
WHAT IS CARTESIAN PRODUCT?
- 2 Answers
- 8192 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
Answer / surya
Once the data is display in M*N format from two different
tables which has m rows in one table and n rows in another
table.We can called as cartesian product.
| Is This Answer Correct ? | 3 Yes | 0 No |
what is shared memory?
What is an Oracle database Full Backup?
Give two examples of referential integrity constraints.
My requirement is like in database some defects are present and i need to clean them.To be brief for example every employee should have active assigments.So for those records which are not having status as active or null ,i need to update the roecords using API with the correct value. Client will provide a flat file for the records whch are defected.So i need to run the API for those records (flat file)and update the data in database. So my question is how to handle this requirement.Is there any existing API for this purpose?If yes then please send me the NAME. How to update the records in the database using flatfile. Any pointer will be appreciated.Thanks in advance.
Name two files used for network connection to a database.
What is the technical flow associated with P2P or Procure to Pay cycle like the tables, APIs, concurrent programs involved in this cycle. Only technical please.
What is the difference between recovery and restoring of the oracle database?
What is auto invoicing? Explain : oracle accounts receivable
How do you resize a data file?
which one is currently in used software cmpanies.
How would you determine what sessions are connected and what resources they are waiting for?
i am pursuing mca and i want to do oracle apps technical in hydrabad, plz guide me tne best institue in hydrabad those have excellent knowledge in oracle apps.
Oracle General 
