You already tried the FAQ?
And it would be easier to help if you told us the format of your "Excel sheets". Is it a bunch of CSV files or XLS or XLSX or...?
thank you very much for your rqplies ,
but as you can see the excel sheet have many question every question in a column and have answer in another column based on that answer you may find question in the next column or you can go direct to action ,
my target structure as below
id as sequence for question
question as question text
answer as question answer
child it will be the next squence based on the answer.
i tryied below code
* from table( as_read_xlsx.read( as_read_xlsx.file2blob( 'DOC', 'E:\under_test\excel_to_oracle\High.xlsx' ) ) );
So you created an Oracle Directory object named 'DOC'? To which OS-directory? It should be "E:\under_test\excel_to_oracle". And then your file name is simply "High.xlsx"
thank you very much for your quick response.
now i created DIRECTORY
OR REPLACE DIRECTORY AUW
then i did grant as below
READ, WRITE ON DIRECTORY AUW TO MD;
then query as below:
ad.directory_name "Directory Name"
,ujp.type_name "Java Priv. Typ"
,ujp.action "Java Priv."
JOIN all_tab_privs atp
ON (ad.directory_name = atp.table_name)
LEFT JOIN user_java_policy ujp
ON (ujp.name = ad.directory_path)
and got below data:
AUW E:\ MD READ
AUW E:\ MD EXECUTE
AUW E:\ MD WRITE
DATA_PUMP_DIR D:\app\Administrator/admin/tak131/dpdump/ IMP_FULL_DATABASE READ
DATA_PUMP_DIR D:\app\Administrator/admin/tak131/dpdump/ EXP_FULL_DATABASE WRITE
DATA_PUMP_DIR D:\app\Administrator/admin/tak131/dpdump/ EXP_FULL_DATABASE READ
DATA_PUMP_DIR D:\app\Administrator/admin/tak131/dpdump/ IMP_FULL_DATABASE WRITE
then i tried the following:
* from table( as_read_xlsx.read( as_read_xlsx.file2blob( 'E:\AUW', 'Abscess.xlsx' ) ) );
and got below error:
ORA-22285: non-existent directory or file for FILEOPEN operation
ORA-06512: at "MD.AS_READ_XLSX", line 347