mysql的代码怎么改写成oracle的代码？

mysql的代码怎么改写成oracle的代码？

有些需要通过其他方式实现.
比如说自增长的,
需要通过sequence 的next_val来实现.

-- Create table
create table sl_dept
(
dept_id number(11, 0) not null,
parent_id number(11, 0),
dept_name varchar2(50),
company_id number(11, 0)
)
;
-- Create/Recreate primary, unique and foreign key constraints
alter table sl_dept
add constraint PK_sl_dept primary key (DEPT_ID);
alter table sl_dept
add constraint fk_company_id foreign key (COMPANY_ID)
references sl_company (COMPANY_ID) on delete cascade;
alter table sl_dept
add constraint fk_parent_id foreign key (PARENT_ID)
references sl_dept (DEPT_ID) on delete cascade;