Learn SQL Database Programming

Differences between temporary tables in other RDBMSes

The differences between each RDBMS are outlined as follows:

• Oracle: You need to specify either a GLOBAL or PRIVATE temporary table when creating a temporary table. You also need the AS keyword after the temporary table name, as shown in the following query:

CREATE GLOBAL TEMPORARY TABLE tempplayerinfo AS  SELECT p.playerid, birthyear, a.yearid, a.teamid, G_defense AS defensegames, H AS numberofhits FROM appearances a  JOIN people p  ON p.playerid = a.playerid JOIN batting b  ON a.playerid = b.playerid AND a.yearid = b.yearid AND a.teamid = b.teamid WHERE b.yearid = 2017 AND H <> 0

Additionally, you drop a temporary table slightly differently in Oracle than in MySQL, as shown in the ...