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!
March 15, 2023
Why continue to utilize a mess of spreadsheets to run your operations? We think there’s a better way. Here are the top 7 reasons you should switch to custom software.
February 3, 2023
Wait. What’s the problem again? Several years ago I was working in Healthcare for a tech startup. At the time, healthcare systems could not bill patients until a chart was signed off and locked by a provider (MD, PA, or NP). The provider had to step through every single screen and check a box regardless […]
September 14, 2022
Why build software of our own? Any good story of a project starts with a problem that needs to be addressed. We work with many clients in the manufacturing vertical and during our time spent with them, we noticed a challenge with synchronization with their dealers. Much of the dealers’ in-office time was spent hunting […]
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 […]