What different of iner joint & outer joint with example
- 4 Answers
- 8863 Views
- I also Faced
- E-Mail Answers
Answer Posted / rizwan khan
inner Join used for Display All Match Data From two or
multible table.
Outer Join :- Display All unmached data.
| Is This Answer Correct ? | 4 Yes | 8 No |
Post New Answer View All Answers
What are the extensions used by oracle reports?
normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi
What is the difference between translate and replace?
How to check database size in Oracle?
What will be the syntax to find current date and time in format "yyyy-mm-dd"?
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
What is query image?
How to use group functions in the select clause using oracle?
What are the advantages of oracle 12c?
What are the differences between lov and list item?
What are the arithmetic operations?
How many types of auditing in Oracle?
How to write date and time interval literals in oracle?
How to assign a table row to a record variable?
What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?
