Showing posts with label Oracle. Show all posts
Showing posts with label Oracle. Show all posts

Oracle OLE DB source in SSIS

›
An OLE DB source to Oracle can be added to a SSIS package. Example data Server : locksnlatches.mydomain.com Oracle instance/SID : dwh ...

Reference SQL Server table with spaces from Oracle

›
It is possible to select data from a SQL Server table that contains spaces by using a database link from Oracle. The syntax is as follows:...

Query Oracle from SQL Server

›
Start with the following steps: Install the Oracle Instant Client (OIC) on the machine where SQL Server is running and add the ...

Quipu connections

›
Several ways to create a database connection in the open source data warehouse generator Quipu . SQL Express SQL Server configuration mana...
1 comment:

Working with dates in OBIEE

›
Here are several options to set date formats in OBIEE. Option #1 is the best way to work with dates and comparison of dates to strings conta...
2 comments:

CTAS disregards number precision and scale

›
When using a "create table as select" (CTAS) to create a table based on a query, when that query also contains a window function/a...

TNS service names ODBC dropdown box garbled, messed up, gibberish

›
Most likely cause is that there are two or more different Oracle clients installed, with two or more home folders and tnsnames.ora files. ...
1 comment:

SQL Developer thick/OCI driver

›
The following error messages may appear when using SQL Developer to select data from a SQL Server table via a (heterogeneous or DG4ODBC) dat...

Oracle JDBC connections

›
The following JDBC drivers exist for Oracle: classes111.jar: Java 1.1 classes12.jar: 1.2 and 1.3 ojdbc14.jar: 1.4 and 1.5 (no JDBC3 and ...

Databases

›
Row-oriented: Oracle DB SQL Server SQL Server CE MySql: InnoDB Sybase Advantage Database Server (ADS) MS Access Column-oriented: Ex...

Change column position

›
In Oracle, it is not straightforward to change the position of a column. Let alone one that contains data. Without resolving to manually c...

Change column data type

›
In Oracle, it is not straightforward to change the data type of a column that contains data. Without resolving to manually changing metadata...

Identifying keys

›
A key that is made up of one field is a simple key. All other keys are combined keys. There are two types of combined keys, compound and com...

Truncate tables that have a foreign key

›
A script to truncate tables that have foreign keys referencing them. It also keeps one record in the table, the one with ID=0. In this case,...

Unlimited login attempts on Oracle 11g

›
In Oracle 10g, by default, each user has unlimited login attempts before being blocked. In Oracle 11g this behaviour is changed to 10 attemp...

Reconfigure OracleXE built-in webserver's port

›
OracleXE comes with a built-in webserver, running on port 8080. Since this is a wellknown port, chances are that it is already in use on you...

External tables

›
Data can be imported into and exported from Oracle 10g in different ways. E.g. by using the SQL*Loader tool for text files (sqlldr) or the D...

Measuring disk I/O speed

›
Disk thruput tester is a handy tool to test the sequential read and write performance of storage media, like harddisks and SSD. It supports ...
1 comment:

Cursor variants in Oracle 10g

›
Examples of different types of cursors. Each has its own pros and cons. Example 1 is the most straightforward and easiest to understand. The...
1 comment:

Oracle SQL Developer screen redraw glitch

›
Perform the following steps to fix the redraw, or screen refresh, bug that can occur in Oracle SQL Developer when used on Windows Vista and ...
4 comments: