One of the requirements for a project I’ve been working on is to connect to Oracle and retrieve some data related to data in MS SQL Server. After successfully setting up the Oracle server as a linked server, I ran into trouble.
Oracle’s data types aren’t quite the same as SQL Server’s data types. In particular, the timestamp type on the Oracle side would not translate to anything on the SQL Server side. After extensive research, I was considering switching to a .Net solution instead, like maybe I could query SQL Server and Oracle separately and then combine the data within the app. Surely not very efficient, but what else could I do?
Fortunately, I had lunch with my brother during the project and his Oracle experience is much greater than mine. After discussing the problem with him, I ended up using a view to get around the issue. For my project, I only needed the year out of the timestamp. Using the TO_CHAR function, I created a view that allowed me to select the year from the Oracle data as a char(4). Perfect!
May 23, 2022
Is local the real secret sauce leaders deploy for a successful development project? Rod Smith, Volano Software Partner, and Co-founder defines the benefits of working with a local development shop.
March 25, 2022
Are you relentlessly passionate about every detail and every pixel when it comes to front-end development? We’re looking to add a Senior Front-end Developer to join our growing team. At Volano, you will work with a variety of clients and projects alongside a remarkable team of back-end and front-end developers, designers, and management to build […]
March 15, 2022
It was 8:00 am on a sunny morning in Hawaii in January. People were hustling to get to their typical morning responsibilities. Cars were on the highway commuting to work, school, and other destinations when all of a sudden chaos breaks out. People start to panic, kids have been thrust down sewers for safety, everyone […]
February 7, 2022
As we continue to grow, we’re looking for an experienced ASP.NET MVC Developer to join our team. At Volano you will work within our high-functioning team to build web and mobile applications for our clients that make their work easier.
November 5, 2021
As we continue to grow, we’re looking for an experienced Senior Front-End Web Developer to join our team. At Volano you will work within our high-functioning team to build web and mobile applications for our clients that make their work easier.
April 23, 2021
We’re looking for an Operations Coordinator to join our team. At Volano you will work within a high-functioning team that builds and supports web and mobile applications for our clients that make their work easier.