inner join,outerjoin,trigger,stored procedure explain with
code snippets?



inner join,outerjoin,trigger,stored procedure explain with code snippets?..

Answer / vj

Join:It is the combining of two rows from different tables
based on the comparative values in selected columns.

Types of Join : Cross Join, Inner Join or equi join and
Outer Join which comprises of Left join and Right join.

Inner Join : It is used to select certain fields from both
tables and only correct rows will be joined together.
Sytax:SELECT <column_name> FROM <Table1>, <Table2> WHERE
(Table1.column = Table2.column)

Outer Join:
Left join: It returns all the data's from the table
present in left of the join and only those data's from the
right tabel which matches the condition.
Syntax:SELECT <column_name> FROM <Table1> LEFT JOIN
<Table2> ON Table1.column = Table2.column (Conditions like
WHERE and USING)

Right join: It returns all the data's from the table
present in right of the join and only those data's from the
left tabel which matches the condition.
Syntax:SELECT <column_name> FROM <Table1> LEFT JOIN
<Table2> ON Table1.column = Table2.column (Conditions like
WHERE and USING)

Is This Answer Correct ?    17 Yes 2 No

Post New Answer

More J2SE Code Interview Questions

In java, why do we set thread priority, when we know that there is no guarantee by which a thread should be execute?

0 Answers   Google, Microsoft,


write a java program to create a Frame with three scrolls, change the back ground color of the frame using functions with values of scrolls.

0 Answers  


is public static void main() work in java?is "String arg[]" needed as argument?

4 Answers   Tech Mahindra,


Design a program using one-dimensional array that determines the highest value among the eight input values from a user. Display the difference of each value from the highest to the lowest.

1 Answers   RoboSoft,


what is runtime class?

0 Answers   MAQ,






A game that has five levels of play has the score for each level stored in an array. You are to write a program that goes through that array and finds: a) the minimum score, and the level at which it occurred b) the maximum score, and the level at which it occurred c)the average score for all five levels The score data you must use for this program are as follows: Game Level Score 1 450 2 316 3 148 Stack implementations is mandatory.

0 Answers  


we compile any program bu c:/>javac prog.java and run as c:/>java prog Here what's the meaning of c in javac. We have java Interpreter but not compiler.Then why we have to use javac. Please answer this question?

2 Answers  


Why the program getting error if we don't use String args[] in main(), even in the case of not getting any arguments from command line?

1 Answers  


Write a program to convert a decimal number to binary form?

1 Answers   Oracle,


For printing a message we use System.out.println in normal programs. We use String msg="text....."; Can't we use String msg=" " in normal programs and System.out.println("........") in applets. Please answer this question?

0 Answers  


Is it possible to define marker interface in java.If possible then how to define user defined marker interface?

1 Answers   Tech Mahindra,


how to create a (*)pyramid using java codes???

5 Answers   Infosys,


Categories