How to Escape Characters in Oracle PL/SQL Queries
Oracle databases reserve some special characters with specific meaning and purpose within Oracle environment. These reserved characters include [...]
Duplicate, Copy or Backup Tables in MySQL, MariaDB, Oracle, PostgreSQL, DB2 and SQLite with Create Table As SQL
In Oracle, PostgreSQL, DB2, MySQL, MariaDB and SQLite database system, there is a nice command feature called Create [...]
Change or Set MySQL Long Query Time Value for log-slow-queries
If you enable slow queries log of MySQL database server, you will notice that from the slow query [...]
Enable Logging of Slow Queries (Slow Query Log) in MySQL Database
One of the main requirements for a fast web server is to has efficient and effective SQL statements [...]
Delete, Remove or Drop Oracle Stored Packages with Drop Package
Oracle Package is an object in Oracle database that allows developers and designers to group procedures and functions [...]
ORA-00942 Table or View Does Not Exist Oracle Error
Sometime when you compile an object or package or view in Oracle, or execute some PL/SQL statements on [...]
Oracle ORA-01658 Unable to Create INITIAL Extent for Segment in Tablespace Error
When inserting records into Oracle database by SQL statements, creating new tables, importing backup dump into Oracle database [...]
WordPress MySQL SQL Query Error in WPDB Class
WordPress plug-ins users or external scripts developers may encounter problems on when trying to perform query or manipulation [...]
Create, Add or Split Oracle Database Partition Fails with ORA-14080 Error
Oracle table partitioning is important for optimum performance of the database, as it allows Oracle to process the [...]
Oracle ORA-14074 Create or Add New Partition Fails Error
Oracle database partition is a division or decomposition of a logical database and/or its constituting elements (indexes or [...]