Oracle Apex is a modern framework to quickly develop and deploy web apps sitting on top of Oracle Database. Apex can be run directly from the database engine itself using a component called Mod PL/SQL. It is one of the easiest way to run Apex, but it is not a production ready setup. In a … Continue reading Install Oracle Apex 5.1.x, 18.1 on ORDS 3,17.4, 18.1
Query to Select the First Day and Last Day of the Current Month select trim(to_date(last_day(sysdate),'DD/MM/YYYY')) as lastday from dual; select trunc((sysdate),'month') as FirstDay from dual;
First Install UTL_MAIL ### To install UTL_MAIL: [code language="sql"] sqlplus sys/**** @$ORACLE_HOME/rdbms/admin/utlmail.sql @$ORACLE_HOME/rdbms/admin/prvtmail.plb [/code] ### Create a Reporting User ### [code language="sql"] create user tctreport identified by tctreport; grant connect to tctreport; grant dba to tctreport; sqlplus tctreport/tctreport [/code] ## Grant TCTREPORT User permission to execute UTL_MAIL ## [code language="sql"] sqlplus "/as sysdba" grant execute … Continue reading Generate Excel and PDF in Oracle and Send Report by Email
1. Download Software as Zip file from OTN http://www.oracle.com/technetwork/developer- tools/apex/downloads/index.html 2.Unzip apex_5.0_en.zip Software to ORACLE_HOME directory, it will create a directory called Apex 3. Login to SQLPLUS as SYSDBA in database where you will create the Apex instance. Create a tablespace called "apex" for the Apex 5 installation $ cd $ORACLE_HOME/apex SELECT dbms_xdb.gethttpport FROM dual; … Continue reading Install and Configure Oracle Application Express Apex 5.0, 4.2.6, 4.2.x with Embedded PL/SQL Gateway
This error occurs when an expression is divided by zero. It is considered a logical error in Oracle. In mathematics, division by zero is division where the divisor (denominator) is zero. Such a division can be formally expressed as a/0 where a is the dividend (numerator). Whether this expression can be assigned a well-defined value … Continue reading ORA-01476: divisor is equal to zero
While creating a' Report and Form' Application in Oracle APEX if your using a table which has no primary key then you might get an error. I would not recommend to do the below procedure in a production environment. It is better to create a new table with a primary key column and copy the … Continue reading Oracle APEX : Source tables for forms and tabular forms must have a primary key.