sql

Jan09

Extend asp.net membership schema to store additional user information

In ASP.NET you can use default membership provider and use the aspnet_Profile table to store additional information of a user at the time of registration. If you don’t know how to install Membership Schema then read my previous article Installing...
Read More
Mar26

Create trigger to set column value depending on another table column value in Oracle database

You can create a trigger in Oracle database to set column value dynamically depending on another table column value. Recently some asked this question in Oracle Apex Forum and here was my suggestion for creating trigger to check if the new value exists...
Read More
Mar25

Create dynamic URL in Oracle SQL

Creating a dynamic field or formatting any column is quite easy using case statement in SQL query. In the recent forum post in Oracle Apex forum I have provided an example how to create dynamic URL based on the value of another field. In this example...
Read More
Mar18

Calculate BCI/CPI using PL/SQL and Oracle table

Recently I was working in a project to calculate BCI (Building Cost Index) for the assets in the asset management system. After messing around with different systems and methodology I have come across a simple solution that calculate the CPI (Consumer...
Read More
Sep12

Update multiple Oracle database tables using procedure in asp.net

In one of my recent project I had the situation where I wanted to update multiple Oracle database tables with one button click event. I do not want to update the second table if the update operation fails for the first table. I have created an Oracle...
Read More