-
Avoid Duplicates in the Result of a SELECT Query in SQL
Do you want to find out how to avoid duplicates in the results of a SQL... Read more
SQLJuly 31, 2020 at 10:45 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
OracleJuly 7, 2020 at 12:13 PM -
Resetting a Sequence in Oracle
It is possible to reset a sequence in Oracle. The company does not provide a... Read more
OracleJuly 21, 2020 at 04:37 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
DatabasesMarch 15, 2012 at 07:31 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
DatabasesJuly 8, 2020 at 08:10 AM -
ORA-01630 : max # extents (extent) reached in temp segment
ORA-01630 : max # extents (extent) reached in temp segment in tablespace... Read more
OracleJuly 1, 2009 at 03:57 AM -
Connecting to a database using JDBC
The JDBC API (Application Programming Interface), that is to say, the JDBC... Read more
DatabasesFebruary 8, 2013 at 07:32 AM -
The different types of JDBC drivers
JDBC drivers today are classified into four categories: Type 1: Drivers... Read more
DatabasesFebruary 8, 2013 at 07:33 AM -
Illegal mix of collations (latin1_swedish_ci,IMPLICIT)
If under PhpMyAdmin you get the following error: MySQL: Documentation... Read more
MySQLDecember 25, 2008 at 06:19 AM -
Start a database with a missing data file
In order to start an Oracle database with a misssing data file: First... Read more
OracleAugust 15, 2010 at 06:56 AM -
Oracle - Making use of special characters
For some SQL queries, we need to search for strings containing special... Read more
OracleMay 13, 2010 at 10:01 AM -
Oracle - Optimize import/export processes
Optimizing the performance of the Import/Export Make use of... Read more
OracleMay 16, 2010 at 05:32 AM -
Creating a listener in the Oracle server
In order to create a listener at a database server Oracle simply edit the... Read more
OracleMay 4, 2010 at 10:14 AM -
Display name of the Oracle database
To view the name of the Oracle databases and data related to them, simply... Read more
OracleMay 29, 2010 at 09:40 AM -
Oracle - Display parameters
In addition to the file init.ora, it is possible for you to consult the... Read more
OracleMay 4, 2010 at 10:11 AM -
Oracle - Get information about the size of the database
The size of the database corresponds to the total size of the physical data... Read more
OracleMay 20, 2014 at 06:41 AM -
MySQL console: Redirect standard output
MySQL client command must be common to you (mysql), with this small tip you... Read more
MySQLMay 3, 2010 at 09:16 AM -
Backup/Restore MySQL database
MySQL, a relational database management system (RDBMS), runs as a server... Read more
MySQLMarch 14, 2012 at 04:40 PM -
MySQL - SELECT ... YESTERDAY
MySQL provides easy access to database records and makes it possible to... Read more
MySQLMarch 5, 2012 at 10:20 AM -
How to install MySQL on Mac OS X?
MySQL is one of the world's most widely used database management systems.... Read more
MySQLJune 8, 2014 at 11:38 AM
