Search

Category filtered by: Database [x] | Database [x] | Oracle [x]

DBTool for Oracle - Part 1 by Espen Harlinn

Article 7 May 2013 license: CPOL

Enhance productivity and reliability, write your own tools.

Database » Database » Oracle

C#WindowsArchitectDevWCFWPFIntermediateAdvancedOracle

Oracle PL/SQL Cursor by Girish Yerzal

Article 19 Apr 2013 license: CPOL

This article will definitely give you a brief idea about cursor with examples.

Database » Database » Oracle

WindowsBeginnerOracle

Optimized way to join tables residing across multiple databases in Oracle by Karthik Narahari

Tip/Trick 1 Apr 2013 license: CPOL

Querying data from tables across multiple databases when we need data from all those tables in a single query.

Database » Database » Oracle

SQLDBADevIntermediateAdvancedOracle

Convert Interval value to calender syntax while migrating DBMS_JOB to DBMS_SCHEDULER by J Chandra Sekhar Achary

Tip/Trick 27 Feb 2013 license: CPOL

Useful piece of code which will convert the DBMS_JOB interval value to calendar syntax.

Database » Database » Oracle

SQLDBA

EpOraLibrary - A lightweight C++ wrapper over Oracle's OCI library by Woong Gyu La

Article 24 Jan 2013 license: GPL3

This is an alternative project of "OraLib - a lightweight C++ wrapper over Oracle's OCI library"

Database » Database » Oracle

SQLSQL-ServerDBADevIntermediateC++VC9.0

Alternative tnsping utility by hevesir

Article 3 Jan 2013 license: CPOL

Alternative tnsping for Oracle Instant Client.

Database » Database » Oracle

WinXPC#WindowsDBADevIntermediateWindowsSysAdminOracleWin7, +

.NET Essbase MaxL Wrapper by AthosXtreme

Tip/Trick 8 Nov 2012 license: CPOL

How to build a .NET wrapper to send MaxL commands to Essbase.

Database » Database » Oracle

C++/CLI.NETDev

Oracle C++ API non-sense by VentsyV

Technical Blog 29 Oct 2012 license: CPOL

A solution to the problem.

Database » Database » Oracle

C++DevIntermediate

How To Create Auto Generated Primary Key in Oracle Database by Junian Triajianto

Technical Blog 21 Sep 2012 license: CPOL

For the first time in my life (finally ) I decided to make an article about oracle database. This semester is my first time learn about database, and you know, the curriculum in my country is very suck. Until almost at the end of the semester, I just learned about CDM, PDM, DDL, DML, and some basic

Database » Database » Oracle

All-Topics

Setting-up Oracle Database for .NET development by - NA -

Tip/Trick 8 Aug 2012 license: CPOL

How to set-up an Oracle database for .NET development.

Database » Database » Oracle

C#Windows.NETMobileDevOracleApplication

Displaying a Bar Chart using SELECT command in Oracle by Azim Zahir

Tip/Trick 4 Aug 2012 license: CPOL

This tip demonstrates using the Select command to display a bar chart.

Database » Database » Oracle

SQLWindowsLinuxIntermediateOracle

Defeasible asynchronous Oracle database operations by Emmet M

Article 3 Aug 2012 license: Apache

Run database updates and selects in a separate thread

Database » Database » Oracle

ASP.NETWindowsIntermediateVBVB.NET

OracleDataReader FetchSize Property by cesar_boucas

Tip/Trick 25 Jul 2012 license: CPOL

"Application performance depends on the number of database round-trips to retrieve data. The less round-trips, the better the performance."

Database » Database » Oracle

C#DevIntermediatedatabase

Using Oracle with EntityFramework 4 by wshcdr

Tip/Trick 13 Jul 2012 license: MIT

ODP.NET EF

Database » Database » Oracle

WindowsADO.NETIntermediate

How to guarantee a fixed amount of rows in a table in Oracle by Mika Wendelius

Tip/Trick 19 May 2012 license: CPOL

This tip describes how to guarantee a fixed amount of rows in a table by using triggers in Oracle

Database » Database » Oracle

SQLArchitectDBADevBeginnerOracle

Logging information in Oracle by Mika Wendelius

Article 30 Apr 2012 license: CPOL

This article describes techniques such as autonomous transactions and action information that can be used when logging information about operations in Oracle database.

Database » Database » Oracle

SQLArchitectDBADevIntermediateOracle

Examples for Creating Oracle Functions by Mika Wendelius

Article 1 Apr 2012 license: CPOL

The article starts with building a simple toolkit package using basic PL/SQL but also covers some more advanced techniques, such as pipeline.

Database » Database » Oracle

SQLDBADevDesignIntermediateOracle

Create an Oracle DSN in C# by Vipin_Arora

Tip/Trick 29 Mar 2012 license: CPOL

Create an Oracle Data Source Name programmatically.

Database » Database » Oracle

C#.NETBeginnerIntermediate

Solving ORA-01882: timezone region not found by Wael Al Wirr

Tip/Trick 26 Mar 2012 license: CPOL

Solving the ORA-01882 error.

Database » Database » Oracle

WindowsDBADevOracle

Solving operating system version: must be 5.0, 5.1, 5.2. Actual 6.1 Failed by Wael Al Wirr

Tip/Trick 26 Mar 2012 license: CPOL

Installing sqldeveloper on windows 7 64bit

Database » Database » Oracle

WindowsDBADevOracle

Build a customized report using Oracle APEX by nguyenannhon

Article 6 Mar 2012 license: CPOL

This article introduces the steps to create a report with a custom search area.

Database » Database » Oracle

SQLDBADevIntermediateOracle

Mimicking SQL Server identity column in Oracle by Mika Wendelius

Article 8 Jan 2012 license: CPOL

This article describes how to use a sequence to mimic the SQL Server identity column in Oracle.

Database » Database » Oracle

C#SQLDBADevADO.NETIntermediateOracle

Oracle database 11g release 2 installation on suse and Enterprise Linux by Srivalsalakumar

Article 3 Dec 2011 license: CPOL

Oracle database 11g release 2 installation on suse and Enterprise Linux

Database » Database » Oracle

Oracle

Oracle 11g Report Installation on RedHat Linux 5x by Srivalsalakumar

Article 22 Nov 2011 license: CPOL

Oracle 11g Report Installation on RedHat Linux 5x

Database » Database » Oracle

DBAOracle

Installing Oracle 11g XE (Express Edition) by Mika Wendelius

Article 14 Sep 2011 license: CPOL

This article briefly describes basic information about installing the Oracle 11g XE database on Windows and few Developer tools such as SQL Developer

Database » Database » Oracle

SQLWindowsArchitectDBADevBeginnerOracle

Gotcha #1167: Quoted Identifiers in Oracle by MBigglesworth79

Technical Blog 16 Jun 2011 license: CPOL

Quoted identifiers appear to be causing more problems and confusion than they are worth; not least the potential creation of "duplicate" column names.

Database » Database » Oracle

SQLDevBeginnerOracle

Export/Import an Oracle database with date range without constraint issues by J Chandra Sekhar Achary

Article 13 May 2011 license: CPOL

Useful tips for Oracle import/export to address constraint issues.

Database » Database » Oracle

SQLDBADevIntermediateOracle

CLOB Comparison Line by Line in PL/SQL by Manuel Vidigal

Article 18 Apr 2011 license: BSD

An implementation of the Longest Common Subsequence (LCS) diff algorithm in PL/SQL.

Database » Database » Oracle

SQLDevIntermediateOracle

Custom Aggregates in Oracle by Mika Wendelius

Article 19 Mar 2011 license: CPOL

How to create custom aggregates in Oracle using PL/SQL

Database » Database » Oracle

SQLDBADevDesignAdvancedOracle

Oracle PL/SQL collections by sandip_bhadane

Article 3 Mar 2011 license: CPOL

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.

Database » Database » Oracle

C#ASP.NETSQLDevIntermediateOracle

Migrating OpenInsight(Multivalue) Database to Oracle(ORDBMS) -4 by Sabarinathan Arthanari

Technical Blog 16 Jul 2010 license: CPOL

In previous post we saw techniques to create collections on the fly to simulate the multi-value columns in Oracle. In this part we use simple PL/SQL function to aggregate individual collection values in to single field separated by value Delimiter. Following function creates multi-valued string from

Database » Database » Oracle

All-Topics

Migrating OpenInsight(Multivalue) Database to Oracle(ORDBMS) -3 by Sabarinathan Arthanari

Technical Blog 8 Jul 2010 license: CPOL

Migrating OpenInsight(Multivalue) Database to Oracle(ORDBMS) -3

Database » Database » Oracle

Oracle

Migrating OpenInsight(Multivalue) Database to Oracle(RDBMS) -1 by Sabarinathan Arthanari

Technical Blog 5 Jul 2010 license: CPOL

A post about how to migrate OpenInsight(Multivalue) Database to Oracle(RDBMS) -1

Database » Database » Oracle

All-TopicsVirtualizationvirtual-machine

Returning Multiple Ref Cursors from Oracle using DAAB by himanshu2561

Article 9 Jun 2009 license: CPOL

How to return multiple ref cursors from Oracle using DAAB

Database » Database » Oracle

C#1.0C#2.0C#3.0C#ASP.NET.NETDBADevIntermediateC#, +

TNSNames Reader by ciro_vladimir

Article 13 Nov 2008 license: CPOL

An article explaining how to list oracle data sources from tnsnames.ora file

Database » Database » Oracle

C#DBADevIntermediateOracle

Sql180 Developer by Guy Haim

Article 25 Oct 2008 license: CPOL

A Graphic tool for Oracle developers and DBAs

Database » Database » Oracle

.NET2.0WinXPWin2003VistaVS2005.NET3.0.NET3.5VS2008C#SQL, +

A Very Simple Oracle Query Tool by Syed M Hussain

Article 11 Jul 2008 license: CPOL

This is a very simple tool, to query an Oracle XE database

Database » Database » Oracle

.NET2.0WinXPC#2.0Visual-StudioDevBeginnerC#Windows.NETOracle

Creating and Modifying Database Objects by Ali Etoom

Article 30 Mar 2008 license: CPOL

oracle 10g

Database » Database » Oracle

(untagged)

OraToolDotNet by cagatay.yildir.im

Article 25 Jan 2008 license: CPOL

An oracle database query, schematic view and query export tool

Database » Database » Oracle

.NET2.0C#2.0C#Windows.NETDBADevADOIntermediateAdvanced, +

Mixing .NET Remoting with COM+ to communicate with an Oracle database: Client and server side by Windmiller

Article 5 Nov 2007 license: CPOL

This article will explain a system made for developers to store their software versions in a SQL database, client and server side. Will handle COM+ mixed with Remoting, and a Oracle database.

Database » Database » Oracle

.NET1.1.NET2.0Win2KWinXPWin2003VS.NET2003VS2005C#1.0C#2.0.NET3.0, +

Using C# for Inserting CLOB Data in Oracle by ace

Article 3 Aug 2007 license: CPOL

Inserting CLOB data into an Oracle table using C#.

Database » Database » Oracle

.NET1.1.NET2.0WinXPVS.NET2003VS2005C#2.0DBADevBeginnerC#, +

Instant Oracle Using C# by Paul Groetzner

Article 7 May 2007 license: CPOL

Connecting to Oracle using C# without using Oracle Developer Tools for Visual Studio .NET. Managing Oracle connectivity with a minimal footprint using Oracle Instant Client.

Database » Database » Oracle

.NET2.0VS2005C#2.0WindowsDBADevIntermediateC#.NETVisual-Studio

Simple C# code generator for Oracle by rovshan_b

Article 12 Mar 2007 license: CPOL

This is a simple C# code generator for stored procedures in an Oracle database. It also can create text for the new stored procedures.

Database » Database » Oracle

.NET2.0VS2005C#2.0WindowsDBADevIntermediateC#.NETVisual-Studio

How to call an Oracle Stored Procedure that returns one or more REF CURSORS, using ADO from C++ by Koushik Biswas

Article 16 May 2006 license: CPOL

How to call an Oracle Stored Procedure that returns one or more REF CURSORS, using ADO from C++? Think it should be easy to find on the internet or make it work with a little luck? Not before this article was posted!

Database » Database » Oracle