How to write a query with a full outer join in oracle?

Answer Posted / guest

select * from t1 full outer join t2

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?

1558


How to rename an existing table?

613


Can we store images in oracle database?

555


Explain self joins in oracle?

564


Hi friends can u send the oracle 9i full version download link?????????????? please reply ?

1442






How many types of table in Oracle?

623


What is a subquery in oracle?

580


how to join query for one source type is oracle another source type is sql server ?

1995


How to create a new oracle data file?

563


How do you store pictures in a database?

563


What is the quickest way to export a table to a flat file?

577


How to empty your oracle recycle bin?

575


What would you do with an in-doubt distributed transaction?

1474


I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.

1704


Compare and contrast between sql and sql server and explain its various functions?

540