Interested to Buy Any Domain ? << Click Here >> for more details...
Please let me know if UNION ALL and Natural Join does the
same operation and are same...
- 7 Answers
- 15087 Views
- iGate, I also Faced
- E-Mail Answers
Answer Posted / g.srinivasulu
Both are not same why because in UNION ALL operator can
retrive the total number of records from the table and
NATUAL JOIN OR EQUI JOIN operator retrive the rows which
are condition must be the same and datatype of the column
names must be same...
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is sql scripting?
What are hotfixes and patches?
What is union?
What is the command used to fetch first 5 characters of the string?
Can we use delete in merge statement?
How do you declare a variable in pl sql?
What is implicit cursor in pl sql?
What are aggregate and scalar functions?
What is pivot in sql?
What is bulk collect in pl sql?
Do we need to rebuild index after truncate?
Where is sql database stored?
Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?
How exception handling is done in advance pl/sql?
Explain the methods used to protect source code of pl/sql.
