Using SQLPlus under Linux Using SQLPlus under Linux You would be surprised to see that you can't rollback your command with the up arrow (last command entered)... Nov 15, 2009Programming > Databases > Oracle |
Display limit of Serveroutput Display limit of Serveroutput Serveroutput has a display limit which is set by default to a total of 1000 records but can be modified... Nov 13, 2009Programming > Databases > Oracle |
Avoid being blocked in case of the error :TOO MANY CONNECTIONS Avoid being blocked in case of the error :TOO MANY CONNECTIONS Issue MySQL normally allows, by default, 100 (150 since version 5.1)... Nov 10, 2009Programming > Databases > MySQL |
[Oracle] Making use of special characters [Oracle] Making use of special characters Intro Solution Intro For some SQL queries, we need to search for strings containing special... Nov 3, 2009Programming > Databases > Oracle |
[Oracle] Optimize import/export processes [Oracle] Optimize import/export processes Optimizing the performance of the Import/Export Make use of "commit = y" Adjust the buffer... Nov 3, 2009Programming > Databases > Oracle |
[Linux]Installing Oracle 11g on Ubuntu [Linux]Installing Oracle 11g on Ubuntu Intro Download UBUNTU Download Oracle X server configuration Updating packages Installing of... Oct 20, 2009Programming > Databases > Oracle |
[Oracle] Recover lost passwords [Oracle] Recover lost passwords To recover a password in Oracle, simply connect under command line mode on the server: #sqlplus /nolog... Oct 20, 2009Programming > Databases > Oracle |
[Installation/Migration] Mysql 5.1 with the official binaries [Installation/Migration] Mysql 5.1 with the official binaries Many persons prefer to install MySQL from the binaries compiled with... Oct 16, 2009Programming > Databases > MySQL |
Easy Ingres Easy Ingres Intro Easy Ingres Ingres works as Easy PHP for MySQL. Download, install, and develop! It allows you to set up a development... Oct 9, 2009Programming > Databases > Ingres |
Connecting to an Ingres database with PHP Connecting to an Ingres database with PHP Getting started Download PECL Installation Windows Linux & Unix Getting connected This tip is... Oct 8, 2009Programming > Databases > Ingres |
MySQL - SELECT ... YESTERDAY MySQL - SELECT ... YESTERDAY Make use of the following syntax: SELECT * FROM myTable WHERE field_date = DATE_SUB(CONCAT(CURDATE(), '... Oct 3, 2009Programming > Databases > MySQL |
[SQL] avoid duplicates when using SELECT [SQL] avoid duplicates when using SELECT Issue How to avoid duplicates in the results of a SQL query? Solution Simply use the DISTINCT... Sep 5, 2009Programming > Databases > SQL |
Automatic backup of a Database in SQL EXPRESS 2005 Automatic backup of a Database in SQL EXPRESS 2005 If you want to automate a backup of a database in SQL Server Express, there is a... Aug 28, 2009Programming > Databases |
Detecting server name for Ingres installation Detecting server name for Ingres installation Intro Note Intro Ingres can be installed several times on a single machine and depending... Aug 23, 2009Programming > Databases > Ingres |
MySQL real time monitoring MySQL real time monitoring You are administrating a MySQL database and you want to analyze in real time the operations taking place in... Aug 10, 2009Programming > Databases > MySQL |
Starting Ingres : ingstart Starting Ingres : ingstart Syntaxe Command Options Note Syntaxe Command ingstart [-iigcn | -dmfrcp | -dmfacp | -client | -rmcmd | ... Aug 9, 2009Programming > Databases > Ingres |
Graphical interfaces for SQLite Graphical interfaces for SQLite SQLite is a powerful database management engine found in a relatively small C programming library; it... Aug 9, 2009Programming > Databases |
Updating a table having a common key Updating a table having a common key In the case you have two tables with a common key (in the case below it is the primary key "id"),... Aug 8, 2009Programming > Databases > MySQL |
Reinitializing the root password of MySQL Reinitializing the root password of MySQL The root password is lost! Reinitializing the password: It's important that you are able to... Aug 8, 2009Programming > Databases > MySQL |
[Oracle] Information about the size of the database [Oracle] Information about the size of the database Normally the size of the database is denoted by total size of the physical... Jul 31, 2009Programming > Databases > Oracle |
