Thanks for that. In MS SQL Server, I use the following technique to avoid full compile:DECLARE @sql VARCHAR(100)DECLARE @pk INTSET @pk = 2SET @sql = 'SELECT id, pcname FROM pod WHERE id = ' + CAST(@pk AS VARCHAR)EXEC (@sql)-- or -- EXEC sp_sqlexec @SQL

Anoncrypt-Text Encryption and Decryption Website in Java (Struts2)

by Rishabh Upadhyay

Anoncrypt by HTCoders is a web-based Text Encryption and Decryption Project developed using Java Technology following Struts2 Framework

Attempt to load Oracle client libraries threw BadImageFormatException. This problem will occur when running in 64 bit mode with the 32 bit Oracle...

by Shripad J

ASP.NET website project hosted on IIS 7.5 running on Windows 2008 R2 is unable to connect to ‘Oracle’ database.

Attempt to load Oracle client libraries threw BadImageFormatException. This problem will occur when running in 64 bit mode with the 32 bit Oracle...

by Marvin Bland

The other option to review when you receive this error is to view your Application_Pools setting for the app_pool you are using for your application.Check the "Enable 32-Bit Applications". If this is "False", change it to "True". This may resolve your issue.

Attunity Connectors to Transfer Data from Oracle to SQL Server using SSIS

by Divyant Kulshrestha

This tip is useful when we have to move data from Oracle database to SQL Server database or vice-versa using SSIS.

Auto Increment Column Options in Different Databases

by DiponRoy

How to auto increment column options in databases

Calculating Average Processing Time in Hours Excluding Weekends

by Mohammed A. Mohiuddin

Calculating Average Processing Time in hours excluding weekends

Check Constraint to validate a Financial Year in Oracle

by Ravi LVS

Check Constraint to validate a Financial Year in Oracle

Check the input Query syntax from VB.NET

by bluesathish

If you build the Query executer tool in a VB.NET, you need to check the input query syntax before getting the results. This tip gives you a small idea of how to get the syntactic errors from the VB.NET front end screen by calling already created stored procedure.

Concept mapping between SQL Server and Oracle

by SergioAmorim

SQL Server and Oracle terms may match, but they can have a very different meaning. This article will help you match one system to the other.

Connection Pool Implementation

by Mahmoud_Gamal

Connection pool java without ConnectionContext

Create a JMS Configuration on Oracle Weblogic 11g using WSLT

by Octavio Sanchez Huerta

Python Script using WSLT

Creating Windows Server 2012 R2 VirtualBox VM for SharePoint 2016

by M Faheem Zafar

This tip explains how to install Windows Server 2012 R2 Server on Oracle VirtualBox VM Server.

Displaying a Bar Chart using SELECT command in Oracle

by Azim Zahir

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

Dynamic Where Clause in Oracle 11g stored procedures

by Kaveh Yazdi Nezhad

we are going to see how we can make a nice code to make search inside an oracle spc

Enumerate entries in TNSNames.ora using Oracle data provider class and DataSourceEnumerator

by Jana Sattainathan

There is an easier way to get the Oracle data source than custom-code a TNSNames.ora parser.

Fast and Simple IDataReader Implementation to Read CSV Files

by shijo joseph

A simple and fast CSV reader which you can directly use against Oracle and SQL Server databases or for any direct implementation

Fetching data in order of commit of database transactions in Oracle

by Davinder Singla

This tip provides soution details for fetching data from an Oracle database in the order in which data was commited when multiple concurrent transactions are executing.

Fibonacci sequence in Oracle using sinqle SQL statement

by Wendelius

This tip shows two ways of generating Fibonacci numbers in a single SQL statement

Freeing Locks on an Oracle Database

by jonyj

Queries and commands to discover what's locking the database

General function for all DML operations using vb.net and oracle stored procedures

by nan49

'All business logic access to the database can make use of this 'function if one is using a stored procedure.'--------------------------------------------------------------Public class classDbAccess#Region "DML OPERATIONS USING ORACLE STORED PROCEDURE" 'This take the necessary...

Generating desired amount of rows in Oracle using single statement

by Wendelius

Two ways of generating desired amount of rows in Oracle by using a single SQL statement.

How to Change Password in Oracle

by Wendelius

This alternative is created to correct few mistakes in the original tip. Most importantly: Never update system tables.

How to Convert a text Value into a date in Oracle SQL

by Database Star

Explanation and demonstration of some Oracle SQL functions to convert text to dates

How to drop dependency constrations in Oracle for all tables

by Slava Khristich

BackgroundI had to write a script to do some tables alternation and datamodification. I run into the problems where I had disable existingconstraints and re enable them at the end of the process. I wassearching the web for automated script to do that but whatever I foundwas not exactly w

How to Fetch Data from the Previous or Next Rows in the Resultset

by Wendelius

This tip demonstrates the use of LAG and LEAD functions in Oracle.

How to Guarantee a Fixed Amount of Rows in a Table in Oracle

by Wendelius

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

How to Implement a Custom Oracle Session Provider

by Rob_Smith_MN

Oracle session provider

How to Protect from SQL Injection in PhP based website

by chetan dudhagara

How to Protect from SQL Injection in PhP based website

How to Resolve the "Not a Valid Month" Error with Oracle TO_DATE

by Database Star

The "ORA-01843: not a valid month" error is quite common for Oracle SQL developers, and can be fixed in a few ways.

How to Use COALESCE with Different Data Types

by Database Star

Use the COALESCE function with different data types correctly

How To Use Oracle's TRIM, LTRIM and RTRIM Functions

by Database Star

How to use these three functions and what the differences are between them

Issues after Upgrade to SQL Server 2017 – Cannot Bulk Load Data Into the Table with Primary Key Constraint on it

by Satnam Singh CapGemini

Cannot Bulk Load Data Into the Table with Primary Key Constraint on it

LPAD and RPAD functions in SQL

by Member 10510822

LPAD and RPAD function works for padding in SQL Server

LPAD and RPAD Functions in SQL

by PIEBALDconsult

This is an alternative for "LPAD and RPAD functions in SQL"

Optimized way to join tables residing across multiple databases in Oracle

by Karthik Narahari

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

Oracle ADF Faces Cookbook

by apis3445

This is another book about ADF

Oracle ASP.Net membership provider ProviderUserKey endian conflict

by Norman Paterson

Oracle scrambles the first eight characters of the UserID

Oracle DB EDMX: Switch Between Prod/Test/Stage Schema Names Dynamically using Entity Framework DB First Approach

by DiponRoy

Use same EDMX file with different Oracle database schemas

Oracle DB EDMX: Upgrade ASP.NET Project and Entity Framework to use Oracle.ManagedDataAccess.Client

by DiponRoy

Upgrade a legacy ASP.NET project to use managed Oracle.ManagedDataAccess.Client instead of unmanaged Oracle.DataAccess.Client while using Entity Framework DB first or EDMX.

Oracle Home Selector

by hevesir

Oracle Home Selector

Out of memory issue in MyBatis

by Davinder Singla

This tip is for solving out of memory issue for large result sets in MyBatis

PHP with Oracle 11g on Windows 7 64-bit

by Zamshed Farhan

It’s a very common problem for those, using Oracle 11g in Windows 7 (64-bit) with PHP applications.

Reset PLSQL sequence value

by Shahriar Iqbal Chowdhury/Galib

Reset PLSQL sequence value

Run Database and GUI Clients in Docker

by DiponRoy

Quick start example to run DB and clients in docker

Select a Default Row in SQL

by DiponRoy

Select a default row for a query that returns no rows

Setting NLS_LANG Value for Oracle

by WernfriedD

How to set NLS_LANG value for Oracle to support all special characters you need in your language/application.

Setting-up Oracle Database for .NET development

by Member 8770718

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

Simple query to get weekdays between two date fields

by GregStevens

How to get weekdays between two date fields without a stored function

Solving operating system version: must be 5.0, 5.1, 5.2. Actual 6.1 Failed

by Wael Al Wirr

Installing sqldeveloper on windows 7 64bit

Solving ORA-01882: timezone region not found

by Wael Al Wirr

Solving the ORA-01882 error.

SQL Database Access

by Martin Vorbrodt

SQL database access

Storing JSON Objects in BLOBS in Oracle

by JimS12

Storing Data in Oracle

Top 5 New Features in Oracle 12c for Developers

by Database Star

Oracle 12c has many new features, and these are the five most useful (in my opinion).

UniDAC - database's direct connection

by Thiago Gaidzinski

UniDAC allows you to connect your cross-platform application directly with many database's types.

Updating Database from DataGridView Using a Class Two-Tier Architecture

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.

Use of columns belonging to tables referenced on main query in a subquery

by John Gathogo

Catastrophic results associated with unqualified use of columns belonging to tables referenced on main query in a subquery

Use SQL to generate large data sequence

by DrABELL

Generate large data series by using Cartesian Product and small data table

Using an Oracle Database Table as a Multithreaded Work Queue

by Brendan Lester

Use of an Oracle 11g Skip Lock feature to easily implement a scalable, robust work queue

Using Java Codes to Capture PIV4/IPV6 Packages

by JinWenQiang

How to capture and process packages using Java language

Using JavaServer Faces with Oracle

by Azim Zahir

This article explains creating a JSF application using NetBeans 7.2.1 and Oracle 11G.

Web-based Data Access Object

by In the Face of God

Generalize to access data in a database via HTTP

What Are The NVL and NVL2 Functions And When Should I Use Them?

by Database Star

This article explains the difference between the NVL and NVL2 functions in Oracle SQL.

What’s the Difference between a Full Index Scan and a Fast Full Index Scan in Oracle?

by Wendelius

This is an alternative for "What’s the Difference between a Full Index Scan and a Fast Full Index Scan in Oracle?"

Why Do I Have Questions to GO

by Alexey Shtykov

Lot of fancy languages were born and have died since I started working in IT, but a few of them continue their pitiful existance.