SET command changes the system variables affecting the report environment.
Is it helpful?
Add CommentView Comments
Ques 42. SPOOL
SPOOL command creates a print file of the report.
Is it helpful?
Add CommentView Comments
Ques 43. JOIN
JOIN is the form of SELECT command that combines info from two or more tables. Types of Joins are Simple (Equijoin & Non-Equijoin), Outer & Self join. Equijoin returns rows from two or more tables joined together based upon a equality condition in the WHERE clause. Non-Equijoin returns rows from two or more tables based upon a relationship other than the equality condition in the WHERE clause. Outer Join combines two or more tables returning those rows from one table that have no direct match in the other table. Self Join joins a table to itself as though it were two separate tables.
Is it helpful?
Add CommentView Comments
Ques 44. Union
Union is the product of two or more tables.
Is it helpful?
Add CommentView Comments
Ques 45. Intersect
Intersect is the product of two tables listing only the matching rows.