-
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 -
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 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 -
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
DatabasesOctober 19, 2020 at 02:31 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 -
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 -
Starting Ingres : ingstart
ingstart [-iigcn | -dmfrcp | -dmfacp | -client | -rmcmd | -icesvr | [... Read more
IngresAugust 9, 2009 at 11:01 AM -
Getting connected to Ingres: the node
An important feature when using Ingres is the node (vnode). This is where... Read more
IngresMay 29, 2010 at 09:40 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 -
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
Subscribe To Our Newsletter!
