文档课题：运用navicat将oracle表结构转换为mysql表结构.
源端数据库：oracle 19.13
目标端数据库：mysql 8.0.27
navicat连接oracle与mysql，点击"工具"选项，选择"数据传输"选项. 

oracle端建表语句如下：
rptuser@TMIS> create table fruits
(
f_id varchar2(10) not null,
s_id number(38) not null,
f_name varchar2(255) not null,
f_price number(8,2) not null,
primary key(f_id)
);

rptuser@TMIS> create table books
(
bk_id number(38) not null primary key,
bk_title varchar2(50) not null,
copyright date not null
  6  );

自动转换为mysql建表语句如下：
SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for BOOKS
-- ----------------------------
DROP TABLE IF EXISTS `BOOKS`;
CREATE TABLE `BOOKS`  (
  `BK_ID` decimal(38, 0) NOT NULL,
  `BK_TITLE` varchar(50) NOT NULL,
  `COPYRIGHT` datetime NOT NULL,
  PRIMARY KEY (`BK_ID`)
);

-- ----------------------------
-- Table structure for FRUITS
-- ----------------------------
DROP TABLE IF EXISTS `FRUITS`;
CREATE TABLE `FRUITS`  (
  `F_ID` varchar(10) NOT NULL,
  `S_ID` decimal(65, 30) NOT NULL,
  `F_NAME` varchar(255) NOT NULL,
  `F_PRICE` decimal(8, 2) NOT NULL,
  PRIMARY KEY (`F_ID`)
);

SET FOREIGN_KEY_CHECKS = 1;