How To - Databases

Oracle - Resetting a sequence

How To Reset a Sequence To reset a sequence SEQ created through the command:... Read more

Oracle

August 20, 2019 at 03:10 AM

How To Recover a Lost Password on Oracle

It is important to recover your lost password on the Oracle database, as not... Read more

Oracle

September 1, 2019 at 03:18 PM

SQL - Avoid duplicates in the result of a SELECT query

Issue Solution Issue How to avoid duplicates in the results of a SQL query?... Read more

SQL

October 18, 2013 at 10:25 AM

Equivalent of DATEDIFF function of the SQL Server under Oracle.

DATEDIFF is a common function in the SQL Server to find the number of days... Read more

Databases

March 15, 2012 at 07:31 AM

Oracle - Components of the Oracle architecture

[Oracle] Components of the Oracle architecture Oracle Instance The user... Read more

Oracle

March 12, 2010 at 09:30 AM

How To List the Tables in an Oracle Database

Displaying the list of tables present in an Oracle database is quite easy to... Read more

Databases

November 22, 2017 at 05:50 PM

Linux - Installing Oracle 11g on Ubuntu

To install the Oracle 11g database on Ubuntu, first download Ubuntu with a... Read more

Oracle

February 13, 2012 at 06:48 AM

Oracle - Using SQLPlus under Linux

SQLPlus is a command line tool which allows you to store and retrieve data... Read more

Oracle

March 12, 2012 at 12:36 PM

Graphical interfaces for SQLite

SQLite is a database management engine that works with most computer... Read more

Databases

February 14, 2012 at 10:20 AM

MySQL - Reset the root password

For users of the powerful database MySQL, access, as well as right to modify... Read more

MySQL

October 18, 2013 at 10:21 AM

Ingres - Importing/Exporting data

Ingres is an open source database management system that is growing day by... Read more

Ingres

November 8, 2012 at 01:31 PM

ORA-00942: table or view does not exist

Does ORA-00942 table or view not exist in Oracle? No problem, here is a... Read more

Oracle

March 15, 2012 at 05:38 PM

Insert an Image in a MySQL database

Issue Solution Issue I am creating a website to purchase books online using... Read more

Databases

September 14, 2011 at 01:12 PM

MYSQLD.EXE encountered an error and needs to close

SQL (Structured Query Language) is a programming language for database... Read more

MySQL

March 15, 2012 at 08:17 AM

MySQL - SELECT ... YESTERDAY

MySQL provides easy access to database records and makes it possible to... Read more

MySQL

March 5, 2012 at 10:20 AM

Export Access Database to MySQL

Establish a connection plase type ODBC database server Using ACCESS to... Read more

MySQL

April 17, 2010 at 07:09 AM

The MySQL adapter "mysql" is not available

MySQL is a RDBMS which can run as a server in a computer system and can... Read more

MySQL

March 16, 2012 at 07:02 PM

Automatic backup of a database in SQL EXPRESS 2005

SQL is one of the most widely used databases across the world. Structured... Read more

Databases

March 10, 2012 at 09:15 AM

DUPLICATE ENTRY '127' FOR KEY 1

The MySQL duplicate entry 127 for key 1 error occurs when the primary key of... Read more

MySQL

March 14, 2012 at 05:48 PM

MySQL real time monitoring

Intro Installation: Intro You are administrating a MySQL database and you... Read more

MySQL

March 9, 2011 at 11:12 AM