using full outer join or Cartesian join we can get all records from two ta

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

Question Posted / pervez

Answer Posted / pervez

using full outer join or Cartesian join we can get all records
from two tables

Is This Answer Correct ?

8 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What is a temporal data type?

1045

Which data type is a composite type?

987

What is the difference between row level and statement level trigger?

1019

explain the delete statements in sql

1048

Can we delete column in sql?

1091

How to use sql statements in pl/sql?

1116

If a cursor is open, how can we find in a pl/sql block?

1165

Why coalesce is used in sql?

1005

Can I copy :old and :new pseudo-records in/to an oracle stored procedure?

1205

Is crud a cuss word?

1032

Should I use mbr or gpt?

1024

What are the different schemas objects that can be created using pl/sql?

1021

How many types of tables are there?

948

how to escape special characters in sql statements? : Sql dba

1035

What are the parameter modes supported by pl/sql?

1103