Pl sql updating multiple columns mmamba datings2016service comlogin
If your statements are not delimited using a semicolon, the whole editor text is sent as a single statement to the database. Microsoft SQL Server), but most DBMS will throw an error in that case.
A script with two statements could look like this: DELETE FROM person; DELETE FROM address; COMMIT; INSERT INTO person (id, firstname, lastname) VALUES (1, 'Arthur', 'Dent'); INSERT INTO person (id, firstname, lastname) VALUES (4, 'Mary', 'Moviestar'); INSERT INTO person (id, firstname, lastname) VALUES (2, 'Zaphod', 'Beeblebrox'); INSERT INTO person (id, firstname, lastname) VALUES (3, 'Tricia', 'Mc Millian'); COMMIT; You can specifiy an alternate delimiter that can be used instead of the semicolon.
This can be changed in the options dialog, that is accessible from will display the online manual for the current DBMS (if there is one).
Where possible the link will display the manual that corresponds to the version of the current connection.
See the description of the alternate delimiter for details. for stored procedures) that contain semicolons that should not delimit the statements.