Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / s. senthil kumar
There are Two Types of joins:
I. Inner Join
II. Outer Join
I: Inner join:a) Equi join, b) Non Equi join c) self join
II: Outer join: a) Left outer join, b) right outer join,
c) Full outer join
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What are the benefits of ordbms?
How to assign values to variables?
Give the different types of rollback segments.
What are the database administrators utilities available?
Explain the difference between a procedure and a function?
How to start a specific oracle instance?
How would you change old and new values in an insert, delete and update triggers?
How to sort the query output in oracle?
I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.
How to bring a tablespace offline?
Can you tell me how to add new column in existing views?how?How is possible?
In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?
How to do a full database export?
Difference between inner join vs where ?
How to best split csv strings in oracle 9i?
