Without Plugins | Upload XLSX, CSV, XML or JSON data using Oracle Apex to Database without plugins

1) 

CREATE TABLE EMP
 (

EMPLOYEE_ID                                              VARCHAR2(50),

FIRST_NAME                                                 VARCHAR2(50),

LAST_NAME                                                 VARCHAR2(50),

EMAIL                                                             VARCHAR2(50),

PHONE_NUMBER                                         VARCHAR2(50),

HIRE_DATE                                                    DATE,

JOB_ID                                                            VARCHAR2(50),

SALARY                                                          VARCHAR2(50),

COMMISSION_PCT                                      VARCHAR2(50),

MANAGER_ID                                              VARCHAR2(50),

DEPARTMENT_ID                                         VARCHAR2(50)

 )
 /

CONVERT EXECL | ORACLE APEX | Convert simple CSV, JSON, XML and XLSX data to rows and columns (APEX_DATA_PARSER )

CREATE OR REPLACE DIRECTORY TEMP_DIR AS 'C:\tmp';
GRANT READ, WRITE ON DIRECTORY TEMP_DIR TO test;

CREATE OR REPLACE FUNCTION file_to_blob (p_dir       IN  VARCHAR2,

                                         p_filename  IN  VARCHAR2)

  RETURN BLOB

AS

  l_bfile  BFILE;

  l_blob   BLOB;

  l_dest_offset INTEGER := 1;

  l_src_offset  INTEGER := 1;

BEGIN

  l_bfile := BFILENAME(p_dir, p_filename);

  DBMS_LOB.fileopen(l_bfile, DBMS_LOB.file_readonly);

  DBMS_LOB.createtemporary(l_blob, FALSE);

  IF DBMS_LOB.getlength(l_bfile) > 0 THEN

    DBMS_LOB.loadblobfromfile (

      dest_lob    => l_blob,

      src_bfile   => l_bfile,

      amount      => DBMS_LOB.lobmaxsize,

      dest_offset => l_dest_offset,

      src_offset  => l_src_offset);

  END IF;

  DBMS_LOB.fileclose(l_bfile);

  RETURN l_blob;

END file_to_blob;

/

https://oracle-base.com/articles/misc/apex_data_parser#xml

Send SMS from Oracle Database | Ad Tec | Bulksms api | IP Base api

---SEND SMS FROM ORACLE DATABASE

মোবাইল নাম্বার কমা (,) সেপারেটেড  অথবা  Newline/Space থাকতে হবে যেমন  (88017,017,17)

SMS

'This is a sample English testing message from oracle Database'

'এটি ওরাকল ডেটাবেস থেকে একটি নমুনা বাংলা পরীক্ষার বার্তা' 

'This is a sample English testing message from oracle Database or এটি ওরাকল ডেটাবেস থেকে একটি নমুনা বাংলা পরীক্ষার বার্তা '

Oracle Apex | Image Show | Product Image

decode(nvl(dbms_lob.getlength(p.prod_img),0),0,null,
'<img alt="'||apex_escape.html_attribute(p.prod_nm)||'" title="'||apex_escape.html_attribute(p.prod_nm)
||'" style="border: 4px solid #CCC; -moz-border-radius: 4px; -webkit-border-radius: 4px;" '
||'src="'||apex_util.get_blob_file_src('P11_PROD_IMG',p.prod_id)||'" height="75" width="75" />') detail_img

ORACLE DATABASE | PL/SQL | PACKAGE | Create Package

create or replace package x_customer_ledger_pkg
as
FUNCTION GET_TOTAL_PRICE ( order_no_ IN VARCHAR2) RETURN NUMBER;
FUNCTION GET_ORDER_NO ( pvoucher_type IN VARCHAR2,pvoucher_no NUMBER) RETURN VARCHAR2;
procedure test_proc (in_val in number);
end;

ORACLE APEX | STORE BLOB FILE | Store Blob file Outside the Oracle database in Oracle APEX

-- New Table 

CREATE TABLE  "EMP_IMAGE" 

   (    "EMP_ID" varchar2(10), 

    "FILENAME" VARCHAR2(3000) ,  

    "MIMETYPE" VARCHAR2(3000), 

    "LAST_UPDATE" DATE, 

    "IMAGE" BLOB

   )

/

1)  Add privilege to use UTL_FILE to Your User
grant execute on utl_file to TEST;

select * from dba_tab_privs where table_name='UTL_FILE';

2 ) Create Directory to Save File and add privilege to write on Directory to You User
CREATE OR REPLACE DIRECTORY TEST_DIR AS 'G:\STORE_IMAGES';
GRANT read, write ON DIRECTORY TEST_DIR TO TEST;

3) Use this Procedure to write a BLOB file to your disk
Create or Replace PROCEDURE Store_Blob_FileOutside (p_blob IN OUT NOCOPY BLOB,
p_dir IN VARCHAR2,
p_filename IN VARCHAR2)
AS
l_file UTL_FILE.FILE_TYPE;
l_buffer RAW(32767);
l_amount BINARY_INTEGER := 32767;
l_pos INTEGER := 1;
l_blob_len INTEGER;
BEGIN
l_blob_len := DBMS_LOB.getlength(p_blob);
-- Open the destination file.
l_file := UTL_FILE.fopen(p_dir, p_filename,'wb', 32767);
-- Read chunks of the BLOB and write them to the file until complete.
WHILE l_pos <= l_blob_len LOOP
DBMS_LOB.read(p_blob, l_amount, l_pos, l_buffer);
UTL_FILE.put_raw(l_file, l_buffer, TRUE);
l_pos := l_pos + l_amount;
END LOOP;
-- Close the file.
UTL_FILE.fclose(l_file);
EXCEPTION
WHEN OTHERS THEN
-- Close the file if something goes wrong.
IF UTL_FILE.is_open(l_file) THEN
UTL_FILE.fclose(l_file);
END IF;
RAISE;
END Store_Blob_FileOutside;

4) Use this process to upload file

DECLARE
l_blob BLOB;
BEGIN
-- Ge SELECT filename,
select
BLOB_CONTENT INTO l_blob
FROM apex_application_temp_files
where NAME= :P5_PRODUCT_IMAGE ;

blob_to_file(p_blob => l_blob,
p_dir => 'TEST_DIR',
p_filename => :P5_PRODUCT_IMAGE);
END;