use full outer join you can get the records

How do you get all records from 2 tables. Which join do you use?

Question Posted / vinay

Answer Posted / vinay

Is This Answer Correct ?

8 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is the use of <> sql?

980

What is dml with example?

1087

Write a sql query to convert all character to uppercase after hypen.

1438

What are the most important ddl statements in sql?

1116

How do you write an index?

965

What packages are available to pl/sql developers?

1058

What's the procedure?

929

What are different clauses used in sql?

1115

State few characteristics of pl/sql?

971

What is the use of procedures?

975

Is pl sql different from sql?

999

What is not in sql?

947

Why do we need a foreign key?

1094

Why trigger is used in sql?

970

What is record type in pl sql?

993