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
now iam working as an hr executive in hyderabad i would like to learn oracle hrms kindly suggest me some good institutes in hyderabd
what is difference between inner join & nested query or subqueries
Explain the payment term in ar. : oracle accounts receivable
can we use lexical perameter in oracle plsql if yes how
as a technical developer in oracle applications which type errors feced in your experience sofar
as a technical developer in oracle applications which type errors feced in your experience sofar
What do you mean by hz_ in customer tables? : oracle accounts receivable
which one is currently in used software cmpanies.
Hi, IN oracle apps HRMS, if the employee changes his department, and when a conconurrent program is run for calulating the pay, The latest Dept id is not diaplayed, howeber the previous deptid is considered. Please can someone tell me where is the program going wrong, which side?
HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?
how to replace not in with not exist?
What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?
I would like to study certification course in Data base adminidtrator then where would i go to study this course?
How to move the data from one flatfile to multiple staging tables?give me some examples? for example in po interface one flat file is there and multiple staging tables are there how can move it?please give me answer for this question?
we have 10 concurrent programs under one request group out of 10 ccps all users submitting only 9 programs from srs window remaining one ccp for specific user how can it possible send me answer asap.
