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…
Formatting report column in currency in Oracle
Here is the little script to convert number to char and trailing with $ symbol. select new_cost, to_char( old_cost,'$999,99,999') as original_cost from cpt_products; It displays result like – 12227 $6,000…
Spliting data in oracle table
Recently I was working on re-modelling and re-designing an oracle database. As part of the re-modelling I was required to import data from old tables to new tables. One of…