This year Android cross just learning background, a lot of do not understand, a lot of things to learn, feel back to the beginning of learning Android passion

Java intern can’t begin to let you rolled a project start to finish, so I took a small project The start is to use the MySQL database, all online, was later found in this or MySQL database configuration, in line with this it is quite many differences between the two databases, or link Oracle test just rest assured.

SQL > alter database create tablespace test_name; alter database create tablespace test_name; Create a new tablespace table and import it again. Oracle does not automatically convert space names, table names, and fields into double quotation marks. Oracle does not automatically convert space names, table names, and fields into double quotation marks. The exported PL/SQL file does not contain double quotation marks and the field names are lowercase.

Address.tab (table), address.trg (trigger), address_sequence.seq (sequence)

Pit 3, Navicat tools have data synchronization, structure synchronization, the two same type of library can be convenient backup import, try not, but with insert statement can, data is not much to use SQL insert.

SQL script:

address.tab
create table XYC_ADDRESS
(
  id          NUMBER(11) not null,
  user_id     NVARCHAR2(45) not null,
  user_name   NVARCHAR2(45),
  award_id    NUMBER(11),
  award_name  NVARCHAR2(255),
  record_id   NUMBER(11),
  address     NVARCHAR2(255),
  phone       NVARCHAR2(45),
  create_date DATE,
  update_date DATE);comment on column XYC_ADDRESS.user_name
  is 'User name';
comment on column XYC_ADDRESS.address
  is 'Shipping address, user needs to fill in manually';
comment on column XYC_ADDRESS.phone
  is 'Mobile number';
alter table XYC_ADDRESS
  add primary key (ID);


address_sequence.seq
create sequence XYC_ADDRESS_SEQUENCE
minvalue 1
maxvalue 9999999999999999999999999999
start with 1
increment by 1
nocache;


address.trg
CREATE OR REPLACE TRIGGER "XYC_ADDRESS" BEFORE INSERT ON "CUNJINGUAN"."XYC_ADDRESS" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW WHEN (new.ID is null)
begin    select XYC_ADDRESS_sequence.nextval into:new.ID from dual; end;
/

Copy the code

Reference: www.jianshu.com/p/ce3786435…