现在有这么一个Excel文档：XLS文件导入样本.xls，想将它导入到Oracle数据库中。

现在有这么一个Excel文档：XLS文件导入样本.xls，想将它导入到Oracle数据库中。

 

 

然后将它上传到服务器的某个文件夹。注意，这个文件路径(/data/uat/apps/apps_st/appl/attchment/12.0.0/BATCH_UPLOAD_TEMP/)必须是在all_directories有定义的。否则用PLSQL无法直接读取文件。值得一提的是，这个步骤并不是必须的，你也可以将Excel文件上传到Blob大字段中，然后再直接读取。常见的是FND_LOBS表的FILE_DATA字段。

 

 

最后一步，用下面的函数就可以直接读取出Excel文本的内容了(注意输入的参数)：

SELECT* FROM TABLE(XYG_PUB_DATA_UPLOAD_PKG.CONVER_EXCEL_TO_TAB(XYG_ALD_FILE_PKG.CONVERT_FILE_BLOB('XYG_BATFILE','XLS文件导入样本.xls'),'',1))

 

必须要说明的是，栏位BATCH_CODE=工作表的名称。

如果有多个工作表，那BATCH_CODE是不同的。

 

 

 

weibo.com/ttarticle/p/show?id=2309405151121919574256

weibo.com/ttarticle/p/show?comment=1&id=2309405151121919574256

weibo.com/ttarticle/p/show?id=2309405151121940545791

weibo.com/ttarticle/p/show?comment=1&id=2309405151121940545791

weibo.com/ttarticle/p/show?id=2309405151121974100038

weibo.com/ttarticle/p/show?comment=1&id=2309405151121974100038

weibo.com/ttarticle/p/show?id=2309405151122020237488

weibo.com/ttarticle/p/show?comment=1&id=2309405151122020237488

weibo.com/ttarticle/p/show?id=2309405151122024431637

weibo.com/ttarticle/p/show?comment=1&id=2309405151122024431637

weibo.com/ttarticle/p/show?id=2309405151122024431815

weibo.com/ttarticle/p/show?comment=1&id=2309405151122024431815

weibo.com/ttarticle/p/show?id=2309405151122061918297

weibo.com/ttarticle/p/show?comment=1&id=2309405151122061918297

weibo.com/ttarticle/p/show?id=2309405151122078957673

weibo.com/ttarticle/p/show?comment=1&id=2309405151122078957673

weibo.com/ttarticle/p/show?id=2309405151122125095130

weibo.com/ttarticle/p/show?comment=1&id=2309405151122125095130

weibo.com/ttarticle/p/show?id=2309405151122133221386

weibo.com/ttarticle/p/show?comment=1&id=2309405151122133221386

weibo.com/ttarticle/p/show?id=2309405151122133483667

weibo.com/ttarticle/p/show?comment=1&id=2309405151122133483667

weibo.com/ttarticle/p/show?id=2309405151122179358728

weibo.com/ttarticle/p/show?comment=1&id=2309405151122179358728

weibo.com/ttarticle/p/show?id=2309405151122183815224

weibo.com/ttarticle/p/show?comment=1&id=2309405151122183815224

weibo.com/ttarticle/p/show?id=2309405151122229953017

weibo.com/ttarticle/p/show?comment=1&id=2309405151122229953017

weibo.com/ttarticle/p/show?id=2309405151122234147251

weibo.com/ttarticle/p/show?comment=1&id=2309405151122234147251

weibo.com/ttarticle/p/show?id=2309405151122238341365

weibo.com/ttarticle/p/show?comment=1&id=2309405151122238341365

weibo.com/ttarticle/p/show?id=2309405151122284478792

weibo.com/ttarticle/p/show?comment=1&id=2309405151122284478792

weibo.com/ttarticle/p/show?id=2309405151122288410672

weibo.com/ttarticle/p/show?comment=1&id=2309405151122288410672

weibo.com/ttarticle/p/show?id=2309405151122343199004

weibo.com/ttarticle/p/show?comment=1&id=2309405151122343199004

weibo.com/ttarticle/p/show?id=2309405151122355781653

weibo.com/ttarticle/p/show?comment=1&id=2309405151122355781653

weibo.com/ttarticle/p/show?id=2309405151122359976130

weibo.com/ttarticle/p/show?comment=1&id=2309405151122359976130

weibo.com/ttarticle/p/show?id=2309405151122397724929

weibo.com/ttarticle/p/show?comment=1&id=2309405151122397724929

weibo.com/ttarticle/p/show?id=2309405151122758172779

weibo.com/ttarticle/p/show?comment=1&id=2309405151122758172779

weibo.com/ttarticle/p/show?id=2309405151122762629377

weibo.com/ttarticle/p/show?comment=1&id=2309405151122762629377

weibo.com/ttarticle/p/show?id=2309405151122779406488

weibo.com/ttarticle/p/show?comment=1&id=2309405151122779406488

weibo.com/ttarticle/p/show?id=2309405151122783600893

weibo.com/ttarticle/p/show?comment=1&id=2309405151122783600893

weibo.com/ttarticle/p/show?id=2309405151122863292886

weibo.com/ttarticle/p/show?comment=1&id=2309405151122863292886

weibo.com/ttarticle/p/show?id=2309405151122884263950

weibo.com/ttarticle/p/show?comment=1&id=2309405151122884263950

weibo.com/ttarticle/p/show?id=2309405151122884264159

weibo.com/ttarticle/p/show?comment=1&id=2309405151122884264159

weibo.com/ttarticle/p/show?id=2309405151122888458289

weibo.com/ttarticle/p/show?comment=1&id=2309405151122888458289

weibo.com/ttarticle/p/show?id=2309405151122972344446

weibo.com/ttarticle/p/show?comment=1&id=2309405151122972344446

weibo.com/ttarticle/p/show?id=2309405151122989121693

weibo.com/ttarticle/p/show?comment=1&id=2309405151122989121693

weibo.com/ttarticle/p/show?id=2309405151122988859429

weibo.com/ttarticle/p/show?comment=1&id=2309405151122988859429

weibo.com/ttarticle/p/show?id=2309405151122989121931

weibo.com/ttarticle/p/show?comment=1&id=2309405151122989121931

weibo.com/ttarticle/p/show?id=2309405151123081134088

weibo.com/ttarticle/p/show?comment=1&id=2309405151123081134088

weibo.com/ttarticle/p/show?id=2309405151123093717006

weibo.com/ttarticle/p/show?comment=1&id=2309405151123093717006

weibo.com/ttarticle/p/show?id=2309405151123093979174

weibo.com/ttarticle/p/show?comment=1&id=2309405151123093979174

weibo.com/ttarticle/p/show?id=2309405151123093979649

weibo.com/ttarticle/p/show?comment=1&id=2309405151123093979649

weibo.com/ttarticle/p/show?id=2309405151123182059985

weibo.com/ttarticle/p/show?comment=1&id=2309405151123182059985

weibo.com/ttarticle/p/show?id=2309405151123194642774

weibo.com/ttarticle/p/show?comment=1&id=2309405151123194642774

weibo.com/ttarticle/p/show?id=2309405151123198836844

weibo.com/ttarticle/p/show?comment=1&id=2309405151123198836844

weibo.com/ttarticle/p/show?id=2309405151123198837028

weibo.com/ttarticle/p/show?comment=1&id=2309405151123198837028

weibo.com/ttarticle/p/show?id=2309405151123286917468

weibo.com/ttarticle/p/show?comment=1&id=2309405151123286917468

weibo.com/ttarticle/p/show?id=2309405151123299500349

weibo.com/ttarticle/p/show?comment=1&id=2309405151123299500349

weibo.com/ttarticle/p/show?id=2309405151123303694442

weibo.com/ttarticle/p/show?comment=1&id=2309405151123303694442

weibo.com/ttarticle/p/show?id=2309405151123303432251

weibo.com/ttarticle/p/show?comment=1&id=2309405151123303432251

weibo.com/ttarticle/p/show?id=2309405151123391775129

weibo.com/ttarticle/p/show?comment=1&id=2309405151123391775129

weibo.com/ttarticle/p/show?id=2309405151123404357932

weibo.com/ttarticle/p/show?comment=1&id=2309405151123404357932

weibo.com/ttarticle/p/show?id=2309405151123408552050

weibo.com/ttarticle/p/show?comment=1&id=2309405151123408552050

weibo.com/ttarticle/p/show?id=2309405151123408552134

weibo.com/ttarticle/p/show?comment=1&id=2309405151123408552134

weibo.com/ttarticle/p/show?id=2309405151123508953131

weibo.com/ttarticle/p/show?comment=1&id=2309405151123508953131

weibo.com/ttarticle/p/show?id=2309405151123521798424

weibo.com/ttarticle/p/show?comment=1&id=2309405151123521798424

weibo.com/ttarticle/p/show?id=2309405151123525992768

weibo.com/ttarticle/p/show?comment=1&id=2309405151123525992768

weibo.com/ttarticle/p/show?id=2309405151123668598827

weibo.com/ttarticle/p/show?comment=1&id=2309405151123668598827

weibo.com/ttarticle/p/show?id=2309405151123689308179

weibo.com/ttarticle/p/show?comment=1&id=2309405151123689308179

weibo.com/ttarticle/p/show?id=2309405151123723125149

weibo.com/ttarticle/p/show?comment=1&id=2309405151123723125149

weibo.com/ttarticle/p/show?id=2309405151123739902160

weibo.com/ttarticle/p/show?comment=1&id=2309405151123739902160

weibo.com/ttarticle/p/show?id=2309405151123773456468

weibo.com/ttarticle/p/show?comment=1&id=2309405151123773456468

weibo.com/ttarticle/p/show?id=2309405151123802816687

weibo.com/ttarticle/p/show?comment=1&id=2309405151123802816687

weibo.com/ttarticle/p/show?id=2309405151123827982909

weibo.com/ttarticle/p/show?comment=1&id=2309405151123827982909

weibo.com/ttarticle/p/show?id=2309405151123853148195

weibo.com/ttarticle/p/show?comment=1&id=2309405151123853148195

weibo.com/ttarticle/p/show?id=2309405151123861536931

weibo.com/ttarticle/p/show?comment=1&id=2309405151123861536931

weibo.com/ttarticle/p/show?id=2309405151123878314094

weibo.com/ttarticle/p/show?comment=1&id=2309405151123878314094

weibo.com/ttarticle/p/show?id=2309405151123911868753

weibo.com/ttarticle/p/show?comment=1&id=2309405151123911868753

weibo.com/ttarticle/p/show?id=2309405151123937034316

weibo.com/ttarticle/p/show?comment=1&id=2309405151123937034316

weibo.com/ttarticle/p/show?id=2309405151123962200265

weibo.com/ttarticle/p/show?comment=1&id=2309405151123962200265

weibo.com/ttarticle/p/show?id=2309405151123966394734

weibo.com/ttarticle/p/show?comment=1&id=2309405151123966394734

weibo.com/ttarticle/p/show?id=2309405151123983171693

weibo.com/ttarticle/p/show?comment=1&id=2309405151123983171693

weibo.com/ttarticle/p/show?id=2309405151124037697958

weibo.com/ttarticle/p/show?comment=1&id=2309405151124037697958

weibo.com/ttarticle/p/show?id=2309405151124046086533

weibo.com/ttarticle/p/show?comment=1&id=2309405151124046086533

weibo.com/ttarticle/p/show?id=2309405151124067057872

weibo.com/ttarticle/p/show?comment=1&id=2309405151124067057872

weibo.com/ttarticle/p/show?id=2309405151124070989951

weibo.com/ttarticle/p/show?comment=1&id=2309405151124070989951

weibo.com/ttarticle/p/show?id=2309405151124088029444

weibo.com/ttarticle/p/show?comment=1&id=2309405151124088029444

weibo.com/ttarticle/p/show?id=2309405151124146749716

weibo.com/ttarticle/p/show?comment=1&id=2309405151124146749716

weibo.com/ttarticle/p/show?id=2309405151124163526721

weibo.com/ttarticle/p/show?comment=1&id=2309405151124163526721

weibo.com/ttarticle/p/show?id=2309405151124176109734

weibo.com/ttarticle/p/show?comment=1&id=2309405151124176109734

weibo.com/ttarticle/p/show?id=2309405151124176109691

weibo.com/ttarticle/p/show?comment=1&id=2309405151124176109691

weibo.com/ttarticle/p/show?id=2309405151124192887143

weibo.com/ttarticle/p/show?comment=1&id=2309405151124192887143

weibo.com/ttarticle/p/show?id=2309405151124251607243

weibo.com/ttarticle/p/show?comment=1&id=2309405151124251607243

weibo.com/ttarticle/p/show?id=2309405151124272578921

weibo.com/ttarticle/p/show?comment=1&id=2309405151124272578921

weibo.com/ttarticle/p/show?id=2309405151124280967316

weibo.com/ttarticle/p/show?comment=1&id=2309405151124280967316

weibo.com/ttarticle/p/show?id=2309405151124284899332

weibo.com/ttarticle/p/show?comment=1&id=2309405151124284899332

weibo.com/ttarticle/p/show?id=2309405151124297744787

weibo.com/ttarticle/p/show?comment=1&id=2309405151124297744787

weibo.com/ttarticle/p/show?id=2309405151124356464841

weibo.com/ttarticle/p/show?comment=1&id=2309405151124356464841

weibo.com/ttarticle/p/show?id=2309405151124381630851

weibo.com/ttarticle/p/show?comment=1&id=2309405151124381630851

weibo.com/ttarticle/p/show?id=2309405151124390019134

weibo.com/ttarticle/p/show?comment=1&id=2309405151124390019134

weibo.com/ttarticle/p/show?id=2309405151124389757019

weibo.com/ttarticle/p/show?comment=1&id=2309405151124389757019

weibo.com/ttarticle/p/show?id=2309405151124415185032

weibo.com/ttarticle/p/show?comment=1&id=2309405151124415185032

weibo.com/ttarticle/p/show?id=2309405151124499071040

weibo.com/ttarticle/p/show?comment=1&id=2309405151124499071040

weibo.com/ttarticle/p/show?id=2309405151124511391769

weibo.com/ttarticle/p/show?comment=1&id=2309405151124511391769

weibo.com/ttarticle/p/show?id=2309405151124520042819

weibo.com/ttarticle/p/show?comment=1&id=2309405151124520042819

weibo.com/ttarticle/p/show?id=2309405151124662648940

weibo.com/ttarticle/p/show?comment=1&id=2309405151124662648940

weibo.com/ttarticle/p/show?id=2309405151124675231842

weibo.com/ttarticle/p/show?comment=1&id=2309405151124675231842

weibo.com/ttarticle/p/show?id=2309405151124708524213

weibo.com/ttarticle/p/show?comment=1&id=2309405151124708524213

weibo.com/ttarticle/p/show?id=2309405151124767506581

weibo.com/ttarticle/p/show?comment=1&id=2309405151124767506581

weibo.com/ttarticle/p/show?id=2309405151124779827279

weibo.com/ttarticle/p/show?comment=1&id=2309405151124779827279

weibo.com/ttarticle/p/show?id=2309405151124813644113

weibo.com/ttarticle/p/show?comment=1&id=2309405151124813644113

weibo.com/ttarticle/p/show?id=2309405151124872364081

weibo.com/ttarticle/p/show?comment=1&id=2309405151124872364081

weibo.com/ttarticle/p/show?id=2309405151124872364134

weibo.com/ttarticle/p/show?comment=1&id=2309405151124872364134

weibo.com/ttarticle/p/show?id=2309405151124884947029

weibo.com/ttarticle/p/show?comment=1&id=2309405151124884947029

weibo.com/ttarticle/p/show?id=2309405151124918501508

weibo.com/ttarticle/p/show?comment=1&id=2309405151124918501508

weibo.com/ttarticle/p/show?id=2309405151124922433563

weibo.com/ttarticle/p/show?comment=1&id=2309405151124922433563

weibo.com/ttarticle/p/show?id=2309405151124972765435

weibo.com/ttarticle/p/show?comment=1&id=2309405151124972765435

weibo.com/ttarticle/p/show?id=2309405151124989804555

weibo.com/ttarticle/p/show?comment=1&id=2309405151124989804555

weibo.com/ttarticle/p/show?id=2309405151125002387558

weibo.com/ttarticle/p/show?comment=1&id=2309405151125002387558

weibo.com/ttarticle/p/show?id=2309405151125027291243

weibo.com/ttarticle/p/show?comment=1&id=2309405151125027291243

weibo.com/ttarticle/p/show?id=2309405151125035942159

weibo.com/ttarticle/p/show?comment=1&id=2309405151125035942159

weibo.com/ttarticle/p/show?id=2309405151125081817250

weibo.com/ttarticle/p/show?comment=1&id=2309405151125081817250

weibo.com/ttarticle/p/show?id=2309405151125098856623

weibo.com/ttarticle/p/show?comment=1&id=2309405151125098856623

weibo.com/ttarticle/p/show?id=2309405151125115371639

weibo.com/ttarticle/p/show?comment=1&id=2309405151125115371639

weibo.com/ttarticle/p/show?id=2309405151125132411025

weibo.com/ttarticle/p/show?comment=1&id=2309405151125132411025

weibo.com/ttarticle/p/show?id=2309405151125153382717

weibo.com/ttarticle/p/show?comment=1&id=2309405151125153382717

weibo.com/ttarticle/p/show?id=2309405151125186937002

weibo.com/ttarticle/p/show?comment=1&id=2309405151125186937002

weibo.com/ttarticle/p/show?id=2309405151125216034941

weibo.com/ttarticle/p/show?comment=1&id=2309405151125216034941

weibo.com/ttarticle/p/show?id=2309405151125233074207

weibo.com/ttarticle/p/show?comment=1&id=2309405151125233074207

weibo.com/ttarticle/p/show?id=2309405151125237268791

weibo.com/ttarticle/p/show?comment=1&id=2309405151125237268791

weibo.com/ttarticle/p/show?id=2309405151125275017340

weibo.com/ttarticle/p/show?comment=1&id=2309405151125275017340

weibo.com/ttarticle/p/show?id=2309405151125291794616

weibo.com/ttarticle/p/show?comment=1&id=2309405151125291794616

weibo.com/ttarticle/p/show?id=2309405151125325086907

weibo.com/ttarticle/p/show?comment=1&id=2309405151125325086907

weibo.com/ttarticle/p/show?id=2309405151125337669699

weibo.com/ttarticle/p/show?comment=1&id=2309405151125337669699

weibo.com/ttarticle/p/show?id=2309405151125342126417

weibo.com/ttarticle/p/show?comment=1&id=2309405151125342126417

weibo.com/ttarticle/p/show?id=2309405151125421818080

weibo.com/ttarticle/p/show?comment=1&id=2309405151125421818080

weibo.com/ttarticle/p/show?id=2309405151125455110192

weibo.com/ttarticle/p/show?comment=1&id=2309405151125455110192

weibo.com/ttarticle/p/show?id=2309405151125459304497

weibo.com/ttarticle/p/show?comment=1&id=2309405151125459304497

weibo.com/ttarticle/p/show?id=2309405151125472149765

weibo.com/ttarticle/p/show?comment=1&id=2309405151125472149765

weibo.com/ttarticle/p/show?id=2309405151125534802115

weibo.com/ttarticle/p/show?comment=1&id=2309405151125534802115

weibo.com/ttarticle/p/show?id=2309405151125547647011

weibo.com/ttarticle/p/show?comment=1&id=2309405151125547647011

weibo.com/ttarticle/p/show?id=2309405151125652242448

weibo.com/ttarticle/p/show?comment=1&id=2309405151125652242448

weibo.com/ttarticle/p/show?id=2309405151125811888654

weibo.com/ttarticle/p/show?comment=1&id=2309405151125811888654

weibo.com/ttarticle/p/show?id=2309405151125828665560

weibo.com/ttarticle/p/show?comment=1&id=2309405151125828665560

weibo.com/ttarticle/p/show?id=2309405151125836791856

weibo.com/ttarticle/p/show?comment=1&id=2309405151125836791856

weibo.com/ttarticle/p/show?id=2309405151125933523185

weibo.com/ttarticle/p/show?comment=1&id=2309405151125933523185

weibo.com/ttarticle/p/show?id=2309405151125937717310

weibo.com/ttarticle/p/show?comment=1&id=2309405151125937717310

weibo.com/ttarticle/p/show?id=2309405151125937717388

weibo.com/ttarticle/p/show?comment=1&id=2309405151125937717388

weibo.com/ttarticle/p/show?id=2309405151125941911877

weibo.com/ttarticle/p/show?comment=1&id=2309405151125941911877

weibo.com/ttarticle/p/show?id=2309405151125979660367

weibo.com/ttarticle/p/show?comment=1&id=2309405151125979660367

weibo.com/ttarticle/p/show?id=2309405151126038380665

weibo.com/ttarticle/p/show?comment=1&id=2309405151126038380665

weibo.com/ttarticle/p/show?id=2309405151126038380754

weibo.com/ttarticle/p/show?comment=1&id=2309405151126038380754

weibo.com/ttarticle/p/show?id=2309405151126046769241

weibo.com/ttarticle/p/show?comment=1&id=2309405151126046769241

weibo.com/ttarticle/p/show?id=2309405151126050701324

weibo.com/ttarticle/p/show?comment=1&id=2309405151126050701324

weibo.com/ttarticle/p/show?id=2309405151126105489428

weibo.com/ttarticle/p/show?comment=1&id=2309405151126105489428

weibo.com/ttarticle/p/show?id=2309405151126143238547

weibo.com/ttarticle/p/show?comment=1&id=2309405151126143238547

weibo.com/ttarticle/p/show?id=2309405151126151364649

weibo.com/ttarticle/p/show?comment=1&id=2309405151126151364649

weibo.com/ttarticle/p/show?id=2309405151126160015530

weibo.com/ttarticle/p/show?comment=1&id=2309405151126160015530

weibo.com/ttarticle/p/show?id=2309405151126164210022

weibo.com/ttarticle/p/show?comment=1&id=2309405151126164210022

weibo.com/ttarticle/p/show?id=2309405151126210084903

weibo.com/ttarticle/p/show?comment=1&id=2309405151126210084903

weibo.com/ttarticle/p/show?id=2309405151126248096179

weibo.com/ttarticle/p/show?comment=1&id=2309405151126248096179

weibo.com/ttarticle/p/show?id=2309405151126264873042

weibo.com/ttarticle/p/show?comment=1&id=2309405151126264873042

weibo.com/ttarticle/p/show?id=2309405151126281650181

weibo.com/ttarticle/p/show?comment=1&id=2309405151126281650181

weibo.com/ttarticle/p/show?id=2309405151126285844498

weibo.com/ttarticle/p/show?comment=1&id=2309405151126285844498

weibo.com/ttarticle/p/show?id=2309405151126315205036

weibo.com/ttarticle/p/show?comment=1&id=2309405151126315205036

weibo.com/ttarticle/p/show?id=2309405151126352953852

weibo.com/ttarticle/p/show?comment=1&id=2309405151126352953852

weibo.com/ttarticle/p/show?id=2309405151126390439969

weibo.com/ttarticle/p/show?comment=1&id=2309405151126390439969

weibo.com/ttarticle/p/show?id=2309405151126394896424

weibo.com/ttarticle/p/show?comment=1&id=2309405151126394896424

weibo.com/ttarticle/p/show?id=2309405151126394896735

weibo.com/ttarticle/p/show?comment=1&id=2309405151126394896735

weibo.com/ttarticle/p/show?id=2309405151126423994434

weibo.com/ttarticle/p/show?comment=1&id=2309405151126423994434

weibo.com/ttarticle/p/show?id=2309405151126474588349

weibo.com/ttarticle/p/show?comment=1&id=2309405151126474588349

weibo.com/ttarticle/p/show?id=2309405151126491365975

weibo.com/ttarticle/p/show?comment=1&id=2309405151126491365975

weibo.com/ttarticle/p/show?id=2309405151126499754365

weibo.com/ttarticle/p/show?comment=1&id=2309405151126499754365

weibo.com/ttarticle/p/show?id=2309405151126537502948

weibo.com/ttarticle/p/show?comment=1&id=2309405151126537502948