Oracle

Jump to bottom Edit New page

ferventcoder edited this page Jun 9, 2011 · 9 revisions

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;

Anyone can edit this