Install Oracle Apex 5.1.x, 18.1 on ORDS 3,17.4, 18.1

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

First Day and Last Day of Current Month Oracle

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;

Generate Excel and PDF in Oracle and Send Report by Email

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

Install and Configure Oracle Application Express Apex 5.0, 4.2.6, 4.2.x with Embedded PL/SQL Gateway

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

ORA-01476: divisor is equal to zero

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

Oracle APEX : Source tables for forms and tabular forms must have a primary key.

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.