Lets see how a customer table is created in different database
In Oracle:
create table customer
(
cust_id number,
cust_name varchar2(200),
cust_gender char(1),
registration_date date,
);
In MySQL:
create table customer
(
cust_id int,
cust_name varchar(200),
cust_gender char(1),
registration_date datetime,
);
In MSSQL:
create table customer
(
cust_id int,
cust_name varchar(200),
cust_gender char(1),
registration_date datetime,
);
In PostgreSQL:
create table customer
(
cust_id int8, [or cust_id integer]
cust_name varchar(200),
cust_gender char(1),
registration_date date,
);
In Oracle:
create table customer
(
cust_id number,
cust_name varchar2(200),
cust_gender char(1),
registration_date date,
);
In MySQL:
create table customer
(
cust_id int,
cust_name varchar(200),
cust_gender char(1),
registration_date datetime,
);
In MSSQL:
create table customer
(
cust_id int,
cust_name varchar(200),
cust_gender char(1),
registration_date datetime,
);
In PostgreSQL:
create table customer
(
cust_id int8, [or cust_id integer]
cust_name varchar(200),
cust_gender char(1),
registration_date date,
);