With Oracle external tables, we can run SQL queries against text files without physically loading them into the database. To create a external table, simply specify the "ORGANIZATION EXTERNAL" parameters after "Create table". Once it is created, you can query the text file like a regular table.
CREATE TABLE "BDM"."TBL_TRADE_EXT"
(
"SYMBOL" VARCHAR2(32),
"DT" VARCHAR2(32),
"OPEN" NUMBER,
"HIGH" NUMBER,
"LOW" NUMBER,
"CLOSE" NUMBER,
"ADJ_CLOSE" NUMBER
)
ORGANIZATION EXTERNAL
(
TYPE ORACLE_LOADER
DEFAULT DIRECTORY "DIR_MKT_DATA"
ACCESS PARAMETERS
( records delimited by '\n'
SKIP 1
fields terminated by "," )
LOCATION
( 'all.csv'
)
)
This blog is mostly focused on the technical aspect of data mining.
No comments:
Post a Comment