Skip to content

Instantly share code, notes, and snippets.

@gauravarora

gauravarora/oracle2mysql.sed

Forked from jabley/oracle2mysql.sed
Last active August 29, 2015 14:02
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save gauravarora/90186beff23928de1a1e to your computer and use it in GitHub Desktop.
Save gauravarora/90186beff23928de1a1e to your computer and use it in GitHub Desktop.
Download ZIP
Raw
oracle2mysql.sed
s/NUMBER(22,0)/BIGINT/
s/NUMBER(9,0)/INT/
s/NUMBER(8,0)/INT/
s/NUMBER(6,0)/MEDIUMINT/
s/NUMBER(5,0)/SMALLINT/
s/NUMBER(3,0)/TINYINT/
s/NUMBER(2,0)/TINYINT/
s/NUMBER(1,0)/BIT/
s/NUMBER(16,2)/DECIMAL(16,2)/
s/NUMBER(11,2)/DECIMAL(11,2)/
s/NUMBER(9,2)/DECIMAL(9,2)/
s/NUMBER(7,2)/DECIMAL(7,2)/
s/NUMBER(5,2)/DECIMAL(5,2)/
s/NUMBER(4,2)/DECIMAL(4,2)/
s/VARCHAR2/VARCHAR/
s/NUMBER,/BIGINT,/
s/ BYTE//
s/"//g
s/--.*//
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment