With the APEX_DATA_EXPORT package, you are able to export data from Oracle Application Express in the following file types: PDF, XLSX, HTML, CSV, XML, and JSON. Step 1: Create a table and populate it with some sample records. CREATE TABLE emp ( empno NUMBER, first_name VARCHAR2(240), last_name VARCHAR2(240), mgr NUMBER, deptno NUMBER, sal NUMBER, created_date TIMESTAMP (6), comm NUMBER, hiredate DATE, JOB VARCHAR2(240), ename VARCHAR2(240), PRIMARY KEY (empno) USING INDEX ENABLE ); / INSERT INTO emp (empno, first_name, last_name, mgr, deptno, sal, created_date) VALUES (1, 'Larry', 'Ellison', , 10, 5000, LOCALTIMESTAMP); INSERT INTO emp (empno, first_name, last_name, mgr, deptno, sal, created_date) VALUES (2, 'Juan', 'Juan', 1,
Comments
Post a Comment