What are joins..how many types of joins are there?
- 29 Answers
- 76592 Views
- Amdocs, CSC, TCS, I also Faced
- E-Mail Answers
Answer Posted / m.sivakumar
joins is a that combines the rows from two or more tables
joins are 5 types
1.cross join
2.equi join or inner join
3.outer join
4.self join
5.non_equi join
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
List out the difference between commit, rollback, and savepoint?
How to list all tables in your schema?
Why is oracle so popular?
Where do we use decode and case statements?
In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??
There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??
What is format trigger?
What is the difference between view and materialized view in Oracle?
In oracle there is column command, how will you explain that?
How to find out what oracle odbc drivers are installed?
What is backup in Oracle?
In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??
what is the use of triggers in Java program? I mean where do we use triggers in Java programming?
ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process
What are the predefined tablespaces in a database?
