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 |
What is the Query Optimizer. How you optimize your qeury.
What is the difference between recovery and restoring of the oracle database?
How I can load an image into image item on Forms. I want to know about built-ins and procedure. and also code for it.
What is the Symbol use for Inner Join
what is sql*loader parameters and where we will use it.
What is the difference between the SQL*Loader and IMPORT utilities?
Explain accounting for invoice in advance and arrears. : oracle accounts receivable
what is the querry to get first 10 records from the emp table?(emp no is the primary key)
can u give guidance abt packages of plsql
Explain the use of table functions.
wht r the base tables & primary key for BOM& WIP modules
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