whats the difference between join command and Cartesian
product using example?



whats the difference between join command and Cartesian product using example?..

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

Post New Answer

More Oracle AllOther Interview Questions

Is there any link between pr form(purchse requisition)and po form(purchase order)

1 Answers   L&T,


What is the use of transaction flexfield in autoinvoice? : oracle accounts receivable

1 Answers  


what are the interface and api table for receipts conversion in oracle receivables? : oracle accounts receivable

1 Answers  


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

2 Answers   Syntel,


Difference between negative and positive adjustments : oracle accounts receivable

1 Answers  


What view would you use to look at the size of a data file?

1 Answers  


can we use lexical perameter in oracle plsql if yes how

1 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?

1 Answers  


How do you use trigger to create mutating state of table

2 Answers   TCS,


A Table has 10,000 records,How can i get latest 10 dates from the table.so that i can only store those 10 records in to my Resultset Object,to reduce load on my app?

7 Answers   TCS,


What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?

2 Answers  


Name two files used for network connection to a database.

1 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1803)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)