When to use inner join and left join?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL PLSQL Interview Questions

What is the difference between CHAR and VARCHAR2? If VARCHAR2 serves the uses of CHAR why CHAR is still used and not been discarded yet?

9 Answers   Oracle,


Is it possible for a table to have more than one foreign key?

0 Answers  


What is the use of double ampersand (&&) in sql queries? Give an example

0 Answers  


if table named a is there and 4 records are there then how to swap (1 and 3) and (2 and 4) records at a time

1 Answers  


What is view explain with example?

0 Answers  






3. Select sum(a) sum_1,max(a) max_1 ,count(a) count_1 from ( ( select 1 a from dual union all Select to_number(‘2011’) a from dual union all select 1 a from dual) union select 2 b from dual);

1 Answers   Fintellix,


what is the forward decleration in packages?

1 Answers  


Is sql a oracle?

0 Answers  


What is magic table?

6 Answers  


what is rollback? : Sql dba

0 Answers  


What are different types of sql commands?

0 Answers  


What is raid? How does it help storage of databases?

0 Answers  


Categories