upload CSV File In Oracle APEX Step by step
video Tutorial
01 Create Page
02 Wizard make
03 Wizard Name Edite
04.Ceate Page Items
05.Page Items Edit
06.Page Items Edit
07.Page Items Edit
08.Page Items Edit
PL/SQL Code:
PL/SQL Code:
select p.line_number,
p.col001, p.col002, p.col003, p.col004, p.col005, p.col006, p.col007, p.col008, p.col008, p.col009, p.col010,
--add more columns (col011 ro col300) here,
from apex_application_temp_files f,
tabe( apex_data_parser.parse(
p_content => f.blob_content,
p_file name => f.filename,
p_add_headers_row => 'Y',
p_csv_enclosed => '"',
p_file_charset => 'WEBISO8859P1',
P_max_rows => 20 ) ) p
where f.name = :p11_file
and p.line_number > 1
10.Parse data
11.Create Process
12.Create a Regions
13.Create Validation
14.Validation code
15.Validation pl.sql code
Is valid file type
declare
v_file_name varchar2(1000):=null;
begin
select filename into v_file_name
from apex_application_temp_files
where name = :P15_FILE;
if apex_data_parser.assert_file_type(
p_file_name =v_file_name,
p_file_type => apex_data_parser.c_file_type_csv )
then
return true;
else
:p15_file := null;
return false;
end if;
end;
16.data load definitions
17.data load definitions
18.data load definitions
19.data load definitions
20.data load definitions
21.data load definitions
