Oracle
Versions
- 10g and later (all editions, including XE)
Default Driver
Sql Script Syntax
- Standard Sql
syntax with statement delimiter ;
- PL/SQL blocks starting with DECLARE or BEGIN and finishing with END; /
Compatibility
- DDL exported by Oracle can be used unchanged in a Flyway migration.
- Any Oracle sql script executed by Flyway, can be executed by SqlPlus
and other Oracle-compatible tools (after the placeholders have been replaced).
Example
/* Single line comment */
CREATE TABLE test_user (
name VARCHAR(25) NOT NULL,
PRIMARY KEY(name)
);
/*
Multi-line
comment
*/
-- PL/SQL block
CREATE TRIGGER test_trig AFTER insert ON test_user
BEGIN
UPDATE test_user SET name = CONCAT(name, ' triggered');
END;
/
-- Placeholder
INSERT INTO ${tableName} (name) VALUES ('Mr. T');
Limitations
- SPATIAL EXTENSIONS: sdo_geom_metadata can only be cleaned for the user currently logged in
- No support for SqlPlus-specific commands that have no JDBC equivalent (SET DEFINE OFF, ...)
- No support for executing external scripts referenced with @other.script, as supported by SqlPlus
SQL Server
Boxfuse 