Interested to Buy Any Domain ? << Click Here >> for more details...
What is a OUTER JOIN?
- 1 Answers
- 2805 Views
- I also Faced
- E-Mail Answers
Answer / parthasarathi
outer join is used to fetch unmatched records along with matched records..
there are 3 kinds of outer joins available.
1.Left outer join :- used to fetch unmatched records at left side table.
2.right outer join :- used to fetch unmatched records at right side table.
3.Full outer join :- used to fetch unmatched records at both side tables.
| Is This Answer Correct ? | 3 Yes | 0 No |
When do you get a .pll extension in oracle?
what is kernel?
How do I find my oracle client driver version?
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
can any one help me with import/export options in oracle............
sql query to get zero records from a table
How to update a table row with a record?
How to delete multiple rows from a table in oracle?
What is a SNAPSHOT ?
What is Rollback Segment ?
How do I manually uninstall oracle client?
t1 col1 col2 nishi 5000 lucky 6700 akash 7000 i want that a query that when i insert 7000 it will show me data already present and data will not insert. if data is not present it will insert.
Oracle General 
