1. IT COMBINES BOTH THE TABLES. 2. NOTE -> SELECT FIELDS SHOULD BE SAME NO OF COLUMNS THEN ONLY IT RUNS OTHERWISE IT THROWS ERROR. 3. ONLY DIFF BETWEEN UNION AND UNION ALL IS UNION ELIMINATE THE ...
PL/SQL stands for Procedural Language extension of SQL. PL/SQL is a combination of SQL along with the procedural features of programming languages. It was developed by Oracle Corporation in the early ...