Category Archives: Oracle

Read Oracle Database using C# .Net Core

Posted on February 25, 2024 by chanmingman

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

Posted on February 23, 2024 by chanmingman

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

Posted on February 20, 2024 by chanmingman

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#

Posted on February 19, 2024 by chanmingman

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

Posted on February 17, 2024 by chanmingman

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

Posted on February 17, 2024 by chanmingman

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

MySQL Backup and Restore Database

Posted on May 16, 2023 by chanmingman

This blog article shows you one of the methods to backup and restore MySQL database. You can see from the HeidiSQL there is a database in MySQL named world. To backup the database, use the mysqldump command as following. mysqldump … Continue reading →

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

ADO.NET Read MySQL Database

Posted on April 21, 2023 by chanmingman

The blog article shows you how to read MySQL using ADO.NET. Firstly, import the required namespaces: using System.Data; using MySql.Data.MySqlClient; Establish a connection to the MySQL database: string connectionString = “server=localhost;database=world;uid=root;password=123456”; MySqlConnection connection = new MySqlConnection(connectionString); connection.Open(); Define the SQL … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform, Oracle, Servers | Tagged | 3 Comments

The problem with Java1z0-808 exam

Posted on December 5, 2019 by chanmingman

Why you should not take the Oracle exam 1z0-808. Actually, I have gotten some pretty good past questions from https://www.gratisexam.com/. The problem was, I suspected the answers were questionable. So I have built them using NetBean, many of them, here … Continue reading →

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

Oracle Oracle.DataAccess.Client.OracleException ORA-01843: not a valid month

Posted on August 16, 2019 by chanmingman

This post shows how to resolve the error “Oracle.DataAccess.Client.OracleException ORA-01843: not a valid month” when using C# to insert or update the data with date. In my below statement I have SS_COMPLETED is a date column. I want to update … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform, Oracle | Tagged , | 2 Comments