Monthly Archives: February 2024

The Right Way to AI

The latest article from WorkLab gives you five specific steps you can take to get maximum buy-in and usage from your teams as you start to implement more AI technologies. Check it out to put your best foot forward. This … Continue reading

Posted in .Net, Cloud, Community, Computers and Internet, CTO, Data Platform | Tagged | Leave a comment

Read Oracle Database using C# .Net Core

This blog article shows you how to read the Oracle 19c database using C# with .NET 5 and above. To read the EMP table in the Scott schema of an Oracle database using C# and Visual Studio Code, you’ll need … Continue reading

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform, Oracle | Tagged | Leave a comment

SSQL Server Integration Service SSIS Connect to Oracle

This blog article shows you one possible way to connect SSIS to Oracle database, I am using Oracle 19c. This article expects you to have basic knowledge of SSIS. Firstly, download and install Oracle Client for Microsoft Tools. Add Data … Continue reading

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform, Oracle | Tagged | Leave a comment

Write a Python Program to Access Oracle Database

This blog article shows you one of the possible ways to access Oracle 19c Database using Python. There are some articles on the Internet asking you to use cx_Oracle library then you have an error “Failed building wheel for cx_Oracle“. … Continue reading

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform, Oracle | Tagged | Leave a comment

Read Oracle Database using C#

This blog article shows you how to access Oracle 19c using C# with .NET Framework 4.8. To access the EMP table in the Scott schema of an Oracle database using C# and Visual Studio Code, you’ll need to use Oracle’s … Continue reading

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform, Oracle | Tagged | 1 Comment

Declare a Variable and Assign the Value to the Variable from Query – Oracle

This blog article should you how to declare a variable, loop through EMP table and assign ENAME column to the variable. DECLARE     — Declare a string variable.     v_employee_name VARCHAR2(100); BEGIN     FOR emp_rec IN (SELECT ename FROM emp) LOOP         — Assigning … Continue reading

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform, Oracle | Tagged | Leave a comment

Create Oracle 19c Database

The blog article shows you how to create a new Oracle Database using Database Configuration Assistant. Start Database Configuration Assistant from the start menu. There are a few important fields to key, Global database name, all the passwords. I unchecked … Continue reading

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform, Oracle | Tagged | 1 Comment

Execute Openquery with parameter Microsoft SQL Server

This blog article shows you one of the ways to execute a query with Openquery with parameter. Firstly, I declared a variable with DateTime data type. DECLARE @EndCollecDate DATETIME Then I select the latest date from a database table named … Continue reading

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform | Tagged | Leave a comment

Search a Single String in MS SQL Database using C#

This blog article shows you one of the ways to search for a Single String in MS SQL Database using C#. The code snippet below is to find a string “Chai” in Northwind database in MS SQL Server. static void … Continue reading

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform, programming | Tagged | Leave a comment

Three Smart Ways to Exceed Your Customers’ Digital Expectations

Discover how to drive business impact with superior customer experiences using AI and app innovation on Azure. This eBook provides strategies for staying competitive and growing your business by exceeding your customers’ expectations. Read this eBook to learn how to: … Continue reading

Posted in .Net, Cloud, Community, Computers and Internet, CTO, Data Platform | Tagged | Leave a comment