Differences in other Relational Database Management Systems

In Oracle, you can't use the same syntax for multiple-row inserts. Instead, you need to use an INSERT ALL syntax, as in the following query:

INSERT ALL
INTO collegeplaying(playerID, schoolID, yearID) VALUES('blaloha01','sandiegost',2000)
INTO collegeplaying(playerID, schoolID, yearID) VALUES('blaloha01','sandiegost',2001)
INTO collegeplaying(playerID, schoolID, yearID) VALUES('blaloha01','sandiegost',2002)
SELECT * FROM DUAL;

PostgreSQL and SQL Server allow the same syntax as MySQL for multiple-row inserts. 

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
18.116.69.244