whats the difference between join command and Cartesian
product using example?
- 1 Answers
- 4918 Views
- I also Faced
- E-Mail Answers
Answer / anitha kori
In cartecian product , there is no condition to filter the data.
In joins there is a condition to filter the data.
| Is This Answer Correct ? | 0 Yes | 2 No |
what is correlated subquery
How would you determine who has added a row to a table?
while creating requisitions i am unable to see the list of organisation can anyone help me out ?
What is the sql query to find the employee who has Nth maximum salary?
I am working in Oracle Clinical 4.5.1 Please explain a bit.How to create Views in OC
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?
Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable
what ASIS BUSINESS PROCESS IN ORACLE FINANCE
How would you determine what sessions are connected and what resources they are waiting for?
In my table i'm having the duplicate records with sequence number and my requirement is when in new record is coming i want to delete existing old record(onlyone i.e maintaing the partial duplicate date )and add new record
Explain the difference between a data block, an extent and a segment.
Are These Dff's Flexible?
Oracle General 
