Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
We usually export a dataset in SQL Server to Excel instead of CSV. But in some cases we may need to export to csv …
Read More »ORA-12012: error on auto execute of job “SYS”.”BSLN_MAINTAIN_STATS_JOB”
When the BSLN_MAINTAIN_STATS_JOB job ends with ORA-12012: error on auto execute of job “SYS”.”BSLN_MAINTAIN_STATS_JOB” and “ORA-06502: PL/SQL: numeric or value error” errors, the baseline …
Read More »How To Check if Oracle instance was started with pfile or spfile
We can learn the parameter file in which the database is opened by querying the spfile and pfile parameter value. If both the spfile and …
Read More »SET LANGUAGE and @@LANGUAGE Function in SQL Server(TSQL)
We can set a session’s language With SET LANGUAGE Command. This command affects the system datetime format and system messages. If you want to …
Read More »The Extended Events session named “x” could not be found. Make sure the session exist and is started.
One day I opened SSMS (SQL Server Management Studio) and wanted to check the Extended Events Session that captured Timeouts. To find out how …
Read More »SUM Function in SQL Server(TSQL)
We use SUM Function to calculate the sum of values in a column. SUM is a aggregated function and generally we use it with …
Read More »ORA-64307: Exadata Hybrid Columnar Compression is not supported for tablespaces on this storage type
When you try to import the export from a database on Exadata to a database that is not on Exadata storage, Pillar Axiom storage …
Read More »“Database ‘x’ cannot be opened due to inaccessible files or insufficient memory or disk space” and “Initializing/Recovery Pending”
There may be several reasons for this error. A friend of mine said that when he received this error, the database files were deleted. …
Read More »STRING_AGG Function in SQL Server(TSQL)
We can concatenate string columns with STRING_AGG function. STRING_AGG function requires 2 argument. Thats why we must put seperater between values. Let’s make examples …
Read More »ORA-08104 error received during index rebuild process
During the process of an online index rebuild operation, when the related session is unexpectedly interrupted, even though there is no rebuild process, it …
Read More »