Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / akn
Inner join is the most common type of join. Inner joins
return all rows from multiple tables where the join
condition is met.
Outer join returns all rows from one table and only those
rows from a secondary table where the joined fields are
equal (join condition is met).
| Is This Answer Correct ? | 17 Yes | 3 No |
Post New Answer View All Answers
How many types of table in Oracle?
For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?
What is a nested table?
How to compare dates in oracle sql?
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
What is a trigger oracle?
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
What is sequence?
What are the oracle differences between nvl and coalesce
What do you know about normalization? Explain in detail?
How do I spool to a csv formatted file using sqlplus?
Is oracle a language?
What are the various constraints used in oracle?
What is data block in Oracle?
How to insert multiple rows with one insert statement in oracle?
