2

types,tables and nested table code in below.

create type virus_spread_details_t as object(
sDate date,
deadCount int,
recoveredCount int,
infectedCount int
)
/

create type virus_spread_details_tbl as table of virus_spread_details_t

create type countries_t as object(
ProvinceOrState varchar2(30),
CountryOrRegion varchar2(50),
Latitude Number(10,6),
Longtude Number(10,6),
virusSpread virus_spread_details_tbl
)
/

create table VirusSpreadcountries of countries_t(
primary key(ProvinceOrState, CountryOrRegion)
CountryOrRegion varchar2(30) NOT NULL,
) nested table virusSpread store as virus_nested_table;

i have csv file it was merged using phython.

it contains 8 columns.

Province/State
Country/Region
Latitude
Longtude
Date
ConfirmedPatients
DeathPatients
RecoveredPatients

i want to import this CSV file into oracle sqlplus.how can I import this CSV through the object.

Improve this question
1
Related questions
4
Retrieve and insert into type objects in oracle
1
Inserting objects with oracle dbms
1
Oracle: Insert into a table type
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.