join-is used to join two tables which have the same field and same data ty

What is the difference between join and union.

Question Posted / vishnu e s

Answer Posted / vishnu e s

join-is used to join two tables which have the same field
and same data type.
union-is to join two sql querrys....

Is This Answer Correct ?

3 Yes

8 No

Please Help Members By Posting Answers For Below Questions

How to disable a trigger name update_salary?

1194

How to test for null values?

982

Can you have a foreign key without a primary key?

899

Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?

1039

Do we need commit after truncate?

1029

Which is faster view or stored procedure?

886

Which type of cursor is used to execute the dml statement?

893

Explain the difference between cursor declared in procedures and cursors declared in the package specification?

1058

What is sql analyzer?

958

How to add, remove, modify users using sql?

977

What is pls integer?

982

Are there any features that are decommissioned in 11g that are not present in 11g?

2066

what is oltp (online transaction processing)? : Sql dba

1012

Can we insert in sql function?

1024

What is indexes?

999