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 |
Is there any link between pr form(purchse requisition)and po form(purchase order)
What is the use of transaction flexfield in autoinvoice? : oracle accounts receivable
what are the interface and api table for receipts conversion in oracle receivables? : oracle accounts receivable
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
Difference between negative and positive adjustments : oracle accounts receivable
What view would you use to look at the size of a data file?
can we use lexical perameter in oracle plsql if yes how
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?
How do you use trigger to create mutating state of table
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?
What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?
Name two files used for network connection to a database.