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 |
What are the different types of drivers under jdbc?
How many types of JDBC drivers are there and what are they?
Why is jdbc used?
Hi my doubt is that preparedStatement is a interface means which has no implemenation.plz go thru the code below String sql = "SELECT * FROM movies WHERE year_made = ?"; prest = con.prepareStatement(sql); prest.setInt(1,2002); ResultSet rs1 = prest.executeQuery(); Now setInt and executeQuery how it works since it is interface it does not have implementation how it works, how executeQuery returns result from database as executequery method has no implementation even in Statement interface.
4 Answers Cybermate, Hexaware,
Is jdbctemplate thread safe?
Which is best database for java?
Is it possible to connect to multiple databases? Using single statement can we update or extract data from two or three or many databases?
How can I instantiate and load a new CachedRowSet object from a non-JDBC source?
What is a jdbc connection?
What is dburl?
How to create Connection interface object because it is Interface , Interface is not instansiated?
What is odbc and jdbc?