Oracle

Oracle

RoundhousE integrates with Oracle.

Batch Splits

Put a ; on a single line where you want to split and it will work.

Batch split example

The following ; would cause a batch split:

CREATE TABLE Timmy
(
  ID  Number(19,0) NOT NULL
  ,dude varchar(50) NULL
)
;
ALTER TABLE Timmy ADD (PRIMARY KEY(id))

None of the following statement is split:

begin
Insert into Table (column1,column2) values (value1,value2);
Insert into Table (column1,column2) values (value1,value2);
Insert into Table (column1,column2) values (value1,value2);
Insert into Table (column1,column2) values (value1,value2);
end;

ConnectionString

We did not get Oracle working correctly over Windows Authentication yet. But you can use tnsless connections to provide to RoundhousE.

###ConnectionString example Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=SERVERNAME)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=SERVICENAME)));User Id=DatabaseName;Password=DatabaseName;Pooling=False;Persist Security Info=false