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 |
HI ALL, How to Overcome "OutOfMemoryException"? when I am compiling source having more than 1000 LOC throwing this exception. Can any one give correct answer to my question? thx
Is oracle client required for jdbc connection?
What is the role of jdbc drivermanager class?
What is the difference between Union, Unionall ?
java.lang.ClassNotFoundException:oracle.jdbc.driver.OracleDr iver? I get this error at run time.I used oracle10G. I set CLASS PATH:C:\oraclexe\app\oracle\product\10.2.0 \server\jdbc\lib\ojdbc14.jar; I write JDBC PROGRAM like import java.sql.*; class Example { public static void main(String args[]) { try { Class.forName ("oracle.jdbc.driver.OracleDriver"); System.out.println("Driver Loaded"); Connection con=DriverManager.getConnection ("jdbc:oracle:thin:@localhost:1521:xe","system","salmas"); System.out.println("Driver Connected"); Statement st=con.createStatement(); ResultSet rs=st.executeQuery("select * from emp"); while(rs.next()) { System.out.println(rs.getInt(1)); System.out.println(rs.getString(2)); System.out.println(rs.getString(3)); } st.close(); con.close(); } catch(Exception e) { System.out.println(e); } finally { System.out.println("it's finally block executed"); } } }
What is the latest version of JDBC? What are the new features added in that?
How do you insert images into database using jdbc?
What are jdbc and its components?
How java can be connected to a database?
How will you perform truncation using JDBC?
What does the jdbc driver interface do?
What is savepoint in jdbc?