안녕하세요. ms sql 버전을 oracle버전으로 코딩변환작업을 하고있습니다.
다음 내용은 데이터 유형이 적합하지 않다고 뜨는데용, 어떻게 하면 좋을가요??
create global temporary table cohort_cdm.VISIT_OCCURRENCE
(
visit_occurrence_id bigint primary key,
person_id integer not null,
visit_concept_id integer not null,
visit_start_date date not null,
visit_start_time time,
visit_end_date date not null,
visit_end_time time,
visit_type_concept_id integer not null,
provider_id integer,
care_site_id integer,
visit_source_value varchar(50),
visit_source_concept_id integer
)
on commit preserve rows;
create global temporary table cohort_cdm.VISIT_OCCURRENCE
(
visit_occurrence_id bigint primary key,
person_id number not null,
visit_concept_id number not null,
visit_start_date date not null,
visit_start_time time,
visit_end_date date not null,
visit_end_time time,
visit_type_concept_id number not null,
provider_id number,
care_site_id number,
visit_source_value varchar(50),
visit_source_concept_id number
)
on commit preserve rows;
이렇게 바꿔도 데이터 유형이 부적합하다고 뜨네요.ㅠ.ㅠ
create global temporary table cohort_cdm.VISIT_OCCURRENCE
(
visit_occurrence_id number primary key,
person_id number not null,
visit_concept_id number not null,
visit_start_date date not null,
visit_start_time date,
visit_end_date date not null,
visit_end_time date,
visit_type_concept_id number not null,
provider_id number,
care_site_id number,
visit_source_value varchar(50),
visit_source_concept_id number
)
on commit preserve rows;