Click here to Skip to main content
13,900,479 members

Oracle

Great Reads

by Bert O Neill
Query Hadoop using Microsoft oriented technologies (C#, SSIS, SQL Server, Excel etc.)
by vic_ch2000
A nullable datetime column in .NET DataGrid with DateTimePicker.
by Ed Wiebe
Can't we obtain the benefit of using bitwise operators for SQL many-to-many relationships AND maintain referential integrity?
by DrABELL
Technique to extend capability of standard SQL by adding the Aggregate Product Function

Latest Articles

by Martin Vorbrodt
SQL database access
by Benktesh Sharma
An illustration of working with Map/Reduce paradigm in the NetSuite cloud.
by Stephane Come
Scaling Oracle Databases in the Cloud with NetApp Cloud Volumes
by Awesh Vishwakarma
By reading this trick, you will be able to update your database from DataGridView through external class instead of writing code on each page.

All Articles

Sort by Updated

Oracle 

6 Dec 2016
_Asif_
This article helps in identifying database design issues like certain fields missing, nullable fields, Primary key not found issues in production environment using SQL Server schema views.
1 Apr 2009
Ahmet Göktaş
T-SQL string maker for backup with a MEDIAPASSWORD database.
20 Dec 2010
Albin Abel
Simple Pattern Matching Technique for Search Suggest Boxes
18 Apr 2016
Alex_2979
A lot of modern Business Intelligence solutions offer to transfer work of analysts to developers or rise technical level of business analysts, make them closer to developers. Instead of it, I advise to consider a solution, which takes information from Database and gives it to business analysts.
4 Dec 2013
Alexander Iskhakov
A comparison Entity Framework 5 and NHibernate 3.3 on a real-world .NET application with Oracle 11g.
20 Mar 2017
AlexeyYakovlev
A library to emulate Oracle-style permanent temporary tables in the PostgreSQL database.
9 Dec 2010
AnupKumarYadav
Can be used in Multilevel Marketing with binary tree (can be modified accordingly to be used for n Tree)
1 Feb 2012
Ashish Tripathi
DALC4NET is an Open Source data access layer built for Microsoft .NET projects. It enables us to access data from databases including SQL Server, Oracle, MySQL, MS Access, and MS Excel.
21 Dec 2018
Benktesh Sharma
An illustration of working with Map/Reduce paradigm in the NetSuite cloud.
30 Dec 2015
Bert O Neill
Query Hadoop using Microsoft oriented technologies (C#, SSIS, SQL Server, Excel etc.)
27 Jan 2010
Bibhas Paul
ADO.NET DataTable as an XML parameter to an Oracle/SQL Server database Stored Procedure.
1 Jan 2011
Bibhas Paul
Interaction between C# application and Oracle through custom Object
18 Oct 2013
Brian C Hart
To save you from hunting through the docs and locating downloads, we gather both databases here and walk you through installing them using SQL Server Management Studio Express -- updated for SQL Server 2008 Express Edition!
5 Jan 2018
Brien M. Posey
In this article, we compare the object storage offerings of each of these cloud providers.
4 Feb 2009
C.L. Moffatt
This article describes SQL Joins in a visual manner, and also the most efficient way to write the visualized Joins.
18 Oct 2010
carl.b.anderson
This article gives you an overview of how you can quickly develop .NET applications using the pragmatic CodeFluent Entities software factory. This tool generates ready-to-use components from a simple model and provides you multiple out-of-the box architecture options.
13 Feb 2012
Chinthala Upender
Bouncy Castle provide encrypt/decrypt your personal data such as password, SSN, credit card numbers etc. using Simple JASYPT framework.
13 Nov 2008
cirovladimir
An article explaining how to list oracle data sources from tnsnames.ora file
11 Apr 2015
Database Star
This article explains how to download and install Oracle Express and SQL Developer on your own computer, to get started with running SQL queries.
17 Jul 2017
Database Star
This article explains how to insert a DATE with or without a time into an Oracle table using the INSERT statement.
22 May 2014
djc2032
A three-part series demonstrating how to develop an Oracle Call Interface (OCI) custom data source for Ultimate Grid
22 May 2014
djc2032
A three-part series demonstrating how to develop an Oracle Call Interface (OCI) custom data source for Ultimate Grid
15 Jun 2007
dmihailescu
Take a snapshot of the main Window of any UI application
26 Jul 2017
Ed Wiebe
Can't we obtain the benefit of using bitwise operators for SQL many-to-many relationships AND maintain referential integrity?
13 Apr 2014
Espen Harlinn
Enhance productivity and reliability, write your own tools.
1 Oct 2013
Espen Harlinn
A reflection based wrapper for the Oracle Data Provider for .NET – allows your application to dynamically load the Oracle.DataAccess.dll assembly installed on your client’s computer.
25 Apr 2014
FaizanMubasher
This article helps developer to start working with new mobile application development framework Oracle ADF Mobile.
9 Oct 2016
Farhad Jabiyev
One of the most popular questions is whether there exists a method which will automatically decide whether to insert, update or delete entity in the Entity-Framework. Now it is possible with EntityGraphOperations library.
8 Nov 2005
fstrahberger
How to do full text search with Oracle Text
19 Sep 2013
G3Coder
Details using an ORM model to provide a common facade to multiple disparate databases.
19 Apr 2013
Girish Yerzal
This article will definitely give you a brief idea about cursor with examples.
25 Oct 2008
Guy Haim
A Graphic tool for Oracle developers and DBAs
8 Aug 2013
h_wiedey
An approach using updatable views with check option and deferred constraint checking.
29 Jul 2013
h_wiedey
The article treats the differences between triggers in Oracle and MS SQL and demonstrates the mutating table problem.
3 Jan 2013
hevesir
Alternative tnsping for Oracle Instant Client.
9 Jun 2009
himanshu2561
How to return multiple ref cursors from Oracle using DAAB
25 Apr 2013
In the Face of God
Unmanaged code application accessing data in a database via Web Services without a database provider.
19 Apr 2017
Intel Corporation
This article introduces BigDL, shows you how to build the library on a variety of platforms, and provides examples of BigDL in action.
13 May 2011
J Chandra Sekhar Achary
Useful tips for Oracle import/export to address constraint issues.
16 Mar 2013
Jeremy Todd
Using the right approach can make GUIDs nearly as fast as integer primary keys on almost any database system.
27 Jan 2016
Jörgen Andersson
A propertymapping extension for DataReaders
2 Mar 2016
Jörgen Andersson
Fluent database access
2 May 2013
Koray Dakan, PMP
DBMapper - A new ORM tool for vendor-neutral solutions
23 Jun 2009
Kuldip Rindani
This script calculates size of every user database with summary
18 Apr 2011
Manuel Vidigal
An implementation of the Longest Common Subsequence (LCS) diff algorithm in PL/SQL.
26 Sep 2018
MattiLindroth
An example on how to call Oracle stored procedures with UDTs from ASP.NET MVC / REST API
1 Feb 2018
Member 11127135
ETL Testing and data-validation, dynamic SQL rule generator
21 Dec 2017
Miguel Diaz Kusztrich
A database tool for search text in procedures, views and tables using regular expressions
16 Jun 2009
Mike Lang
A data abstraction layer for .NET applications. Write your application code to be database neutral. Swap out the type of database your application uses without updating or even recompiling your business components.
13 May 2009
Mohammad Al Hoss
Passing an array as parameter to SQL server Procedure
2 Mar 2015
Moises Barba
The seventh version of the dynamic, configuration-less and self-adaptive Kerosene ORM library, that provides full real support for POCO objects, natural SQL-like syntax from C#, and advanced capabilities while being extremely easy to use.
1 Mar 2015
Moises Barba
A deep dive into the Kerosene ORM Entity Maps operational mode that provides full real support for POCO objects.
2 Mar 2015
Moises Barba
Kerosene ORM support for complete database-alike WCF services and connections
1 Mar 2015
Moises Barba
A deep dive tutorial on Kerosene ORM Dynamic Records and other core concepts of the library
11 Mar 2014
Moises Barba
Implementing the Repository and Unit of Work Patterns dynamically using Kerosene ORM
3 Jul 2012
Muammar©
Dynamic data retrieval from Oracle database to Excel sheet based on a parameter from Excel cell value
1 Dec 2009
Murali Manohar Pareek
ASP.NET Gridview with Default and Custom Paging, Sorting, Export Data, Freeze Header, Column Resizing, Row Hover, Row Selection, Grid Cell Tooltip features for better Performance, functionality and GUI with Oracle Database
6 Mar 2012
nguyenannhon
This article introduces the steps to create a report with a custom search area.
29 Oct 2013
Ogwara Rowland
NW.ORM, a helper framework for working Hibernate.
29 Sep 2014
Omar Al Zabir
Oracle Performance Dashboard (OPD) is a small ASP.NET website that shows you performance & problems of one or more Oracle instances in near real-time. It uses the Dynamic Performance Views (DPV) and runs some popular DBA scripts in order to get meaningful, easy to understand information out of the s
19 Sep 2009
Paul Rony
A Programmer's Guide to Starting a Software Company and Building an Enterprise Application
7 Oct 2016
Paulo Uechi
Uechi APM Web is an APM (Application Performance Management) Open Source Server Performance Monitor written and developed in Java and C # for all Linux and Windows platforms. The Uechi.APM.Web offers a complete resource for unlimited monitoring servers in real time. Have full control of the CPU cons
9 May 2012
Petr Ivankov
Long time strategy of software design and development
18 Jan 2014
Petr Ivankov
Application of abstract approach to database domain
30 Aug 2010
Petr Kozelek
Logging of data changes in relational databases
10 Nov 2011
Phani Krishna Kollapur Gandla
Migration of Relational Data structure to Cassandra (No SQL) Data structure
10 Nov 2011
Phani Krishna Kollapur Gandla
How to solve performance issues in data migration to SQL Server.
3 Apr 2013
Pierre Kellerman
Explaining different ways to join tables
30 Jan 2018
Quest Software
If you wanted to ramp up database DevOps, which development tasks would be most important for you?
6 Sep 2018
QxOrm
QxOrm C++ library: Persistence (based on QtSql Qt library) - Serialization (based on boost::serialization library) - Reflection (introspection)
27 May 2016
Rednet Software
Rednet.DataAccess is yet another component to work with data that simplifies your use.
22 Feb 2011
ronald.cao@gmail.com
The article is to introduce a utility to generate cascading delete script for an Oracle table.
5 Sep 2015
Sadique KT
How to Install Oracle 12c, How to create listener, How to create TablesSpaces and How to restore database
4 Mar 2011
sandip_bhadane
This article briefs about different types of PL/SQL collections, their advantages, how to pass an array to stored procedure from ASP.NET application, etc.
6 Mar 2014
Shivprasad koirala
Steps to use a logging utility in your projects using Application Blocks.
26 Feb 2014
Shivprasad koirala
This article will discuss about 11 important database designing rules.
1 Nov 2016
SlavaUtesinov
EF implementation of BulkInsert operation and "Arrays in a Bind" solution at case of absence of EF.
22 Nov 2011
Srivalsalakumar
Oracle 11g Report Installation on RedHat Linux 5x
3 Dec 2011
Srivalsalakumar
Oracle database 11g release 2 installation on suse and Enterprise Linux
31 Oct 2018
Stephane Come
Scaling Oracle Databases in the Cloud with NetApp Cloud Volumes
29 Mar 2009
Steve MunLeeuw
Embedding the content of a PDF document is not supported, but we can add this feature with a SQL CLR function to parse the PDF into a list of images.
11 Jul 2008
Syed M Hussain
This is a very simple tool, to query an Oracle XE database
5 Apr 2009
Tarek Najem
How to delete duplicate entries from a data store, while leaving a single copy.
1 Jan 2009
Telerik
Learn how to bridge the gap between relational and object designs(models) and increase your productivity using Telerik OpenAccess ORM.
31 Jul 2008
TSells
Utility to manage multiple DB connection strings for an application.
5 Feb 2014
V.
First article on creating a reusable framework
30 Oct 2014
Vaclav Naydenov
How C++ library YB.ORM can help manipulate the data stored in RDBMS using domain classes. Basic concepts of ORM are explained by examples.
17 Aug 2009
vic_ch2000
A nullable datetime column in .NET DataGrid with DateTimePicker.
20 Aug 2010
Vivek Johari
This article is written to describe all the different types of Sql Joins
28 Aug 2009
weilidai2001
Instead of using incremental INSERT to generate test data, this method effectly copies the existing data multiple times.
1 Apr 2012
Wendelius
The article starts with building a simple toolkit package using basic PL/SQL but also covers some more advanced techniques, such as pipeline.
19 Mar 2011
Wendelius
How to create custom aggregates in Oracle using PL/SQL
14 Sep 2011
Wendelius
This article briefly describes basic information about installing the Oracle 11g XE database on Windows and few Developer tools such as SQL Developer
8 Jan 2012
Wendelius
This article describes how to use a sequence to mimic the SQL Server identity column in Oracle.
1 May 2012
Wendelius
This article describes techniques such as autonomous transactions and action information that can be used when logging information about operations in Oracle database.
2 Apr 2017
Wendelius
This is an alternative for "What You See Is What You Update"
2 Jun 2014
Woong Gyu La
This is an alternative project of "OraLib - a lightweight C++ wrapper over Oracle's OCI library"
30 Apr 2009
zhongzf
An open source Data Access Component


Advertise | Privacy | Cookies | Terms of Service
Web02 | 2.8.190306.1 | Last Updated 24 Mar 2019
Copyright © CodeProject, 1999-2019
All Rights Reserved.
Layout: fixed | fluid