What is an outer join?
Answers were Sorted based on User's Feedback
Answer / love kumar
outer join is an extension of Natural join used to deal
with missing statements in a relation.
There are three typs of outer join
1. left outer join
2. right outer join
3. full outer join
| Is This Answer Correct ? | 12 Yes | 0 No |
Answer / dsr
Hi,
Outer Join: a and b are both tables and some relation
applied a U b
| Is This Answer Correct ? | 2 Yes | 4 No |
How to invoke Oracle Stored Procedure with Database Objects as IN/OUT?
How does JDBC API helps us in achieving loose coupling between Java Program and JDBC Drivers API?
What causes no suitable driver error?
What is the significance of DataBaseMetaData.tableIndexStatistics? How to obtain and use it?
What is a connection string used for?
How can I use the JDBC API to access a desktop database like Microsoft Access over the network?
How to achieve JDBC Connection Pooling using JDBC DataSource and JNDI in Apache Tomcat Server?
What are the different types of resultset?
How can I retrieve a String or other object type without creating a new object each time?
write a query to select name from one table which has id,name and salary from another table which has id, sal where the salary is the second maximum
3 Answers Bosch, HireCraft, Infosys,
What are the jdbc statements?
how you will execute the many tables data