Category Archives: Oracle

Create Table Example – Oracle PL/SQL

CREATE TABLE statement is used to create tables in Oracle like other databases such as SQL Server and MySQL. Similarly we can also add constraints to the columns like Primary… Read more »

Generate DDL/DML of Oracle database objects using Oracle SQL Developer

Introduction In this post I will explain how to generate DDL(CREATE statement) and DML(INSERT statement) of Oracle database objects using “Oracle SQL Developer” Description Using Database Export feature of Oracle… Read more »

Fix “System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.” error in .NET

Introduction In this article I will explain cause and resolution of “System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.” error Cause This error generally occurs when you deploy an… Read more »