Regular expression for file browse extension
Recently I was working on file upload in Oracle application express. I was using file browse and storing the file oracle database. I have created some item level validations to…
Storing file in Oracle database using Oracle Application Express
In this example I will illustrate how to upload a file into a table in oracle database and display the image in Oracle Application Express page. I will also show…
Insert data from one database to another in oracle
Insert data from one database to another database in oracle Sometimes we require to migrate data between the databases when using different servers. Like in my case I use three…
SQL query to link report column depending on value
In this example I will show how to set link column and exclude some columns depending on their value. Suppose I want to link only those records who got active…