@Chris_Knoll thank you! I find the DDL.But,it seems that some codes don‘t match with my oracle.I just want to modify it,but I don‘t konw whether it will make bad influence.
For example:
①: I set up the ‘results’ schema and run the codes
CREATE TABLE @results_schema.cohort
(
COHORT_DEFINITION_ID int NOT NULL,
SUBJECT_ID bigint NOT NULL,
cohort_start_date date NOT NULL,
cohort_end_date date NOT NULL
);
The error is
00903. 00000 - "invalid table name"
*Cause:
*Action:
If I delete “@results_schema.”,it runs correctly.Therefore,should I delete it?
②: It seems that identifier should be less than 30 characters in oracle sql developer according to the specify,but the code below:
CONSTRAINT DF_heracles_results_dist_last_update DEFAULT GETDATE()
Obviously,the identifier is more than 30 characters.I do don’t know how to deal with it.
Could you help me once again?
Sincerely.
-ZHU.