What are joins..how many types of joins are there?
Answer Posted / guruswamy
join is combaining two or more tables.
there are three types.they are
1).simple join
2).self join
3).3.outer joins
| Is This Answer Correct ? | 15 Yes | 21 No |
Post New Answer View All Answers
What is a proxy object?
Is there a combination of "like" and "in" in sql?
How does the on-delete-cascade statement work?
Explain constraining triggers.
Which is better Oracle or MS SQL? Why?
How to get last row id?
Explain oracle data types with examples?
how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?
Can multiple cursors being opened at the same time?
Can you tell me how to add new column in existing views?how?How is possible?
Explain what are the type of synonyms?
What are the data types in oracle?
What is the string concatenation operator in oracle?
What is an external table?
How would you change old and new values in an insert, delete and update triggers?