After the STANDBY Database is installed and the necessary configurations were made, when INSTANCEs wanted to be START, one of the INSTANCEs opened and the …
Read More »LOCK TABLES in MYSQL
The article contains information about LOCK TABLES in MySQL VTY system. Features added to the database during database design or later (INDEX, Foreign Key, UNIQUE …
Read More »INDEX SCANS IN ORACLE
The index scans are the table access paths used by the oracle optimizer to generate the best execution plan. There are different types of scans …
Read More »Oracle PDB Automatic Startup in 12C
We will explain Oracle PDB Automatic Startup in 12c in this article. STEP 1 :- Check The List Of PDBS . Here In My case …
Read More »MySQL Temporary Tables
The article contains information about the MySQL Temporary Tables used to create a temporary table in MySQL VTY system. What is Temporary Tables in MySQL? …
Read More »How do I declare a variable in MySQL?
The article contains information about declaring variable in MySQL VTY system to store temporary data. Variables can be used to pass values from one MySQL …
Read More »ORA-16664: unable to receive the result from a database
When querying the status of the configuration from broker, errors like below were seen. Warning: ORA-16664: unable to receive the result from a database [crayon-676b931c8c41f992940628/] …
Read More »PL/SQL Tutorial
This article is an index of PL/SQL Tutorial. You can find almost everything for beginners in this article and in related articles about PL/SQL. If …
Read More »How to Install PostGIS in PostgreSQL 12
What is PostGIS in PostgreSQL? It would not be wrong to say that PostGIS is an open source software program that supports geometrical features for …
Read More »How To Install PostgreSQL12 On Centos 8
In this article, we will install PostgreSQL 12 On Centos 8. We choose the versions we will install by going to the link below. https://www.postgresql.org/download/linux/redhat/ …
Read More »