Derived table vs subquery

›
There are several ways to combine datasets: Subquery: SELECT clause, correlation Join (cross/left/right/inner/full): FROM clause, no corre...

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...

No login prompt for website

›
Suppose you want to login with Internet Explorer to an intranet website, that uses Windows Authentication as the authentication mechanism. W...
1 comment:

Run SSMS using different Windows account

›
You can log on to a SQL Server database using SQL Server Management Studio (SSMS) with a Windows Authentication login / NT account / Windows...

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...

Most recognizable samples

›
Breakbeats Al Green - I’m Glad You’re Mine (0:00) [Eric B. & Rakim - Mahogany, The Notorious B.I.G. - I Got a Story to Tell, RZA - My ...
2 comments:

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...

Cannot load package & required privilege is not held by the client

›
How to start a filesystem dtsx package from sql agent, without a config file or without adding a package password to the command line: - s...
2 comments:

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...

SQLite enforces foreign key constraints

›
As of version 3.6.19, SQLite finally supports foreign key constraints that can be enforced. http://sqlite.org/releaselog/3_6_19.html A pragm...

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:

Winload.exe missing or corrupt (0xc000000e)

›
Today we had a problem with Acronis Disk Doctor. We used it to try to resize a existing partition. The tool doesn't directly support dyn...

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:

Create handwritten truetype font for free using fontcapture

›
Fontcapture ( http://www.fontcapture.com/ ) is the only website I could find that offers a service to convert handwritten characters into a ...