Useful tips for everyday
Which 2 wildcards are used in SQL? SQL supports two wildcard operators in conjunction with the LIKE operator which are explained in detail in the…
How to restore PostgreSQL database from WAL without…? To have a checkpoint in past you need to have a basebackup (a cold copy with db…
Can a constraint trigger be created in PostgreSQL? Finally, PostgreSQL has the option to create “constraint triggers” with CREATE CONSTRAINT TRIGGER. It sounds like such…
How to solve ora-01017 invalid username password LOGON denied? There are a few ways to resolve the ORA-01017 error: Check the username and password are…
What are the constraints for a column in SQL? Constraints can be column level or table level. Column level constraints apply to a column, and…
Where can I find information schema? Using the Information Schema SELECT TABLE_NAME FROM INFORMATION_SCHEMA. TABLES. SELECT TABLE_NAME, COLUMN_NAME FROM INFORMATION_SCHEMA. COLUMNS. SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.…
How does MySQL Gtid work? Each GTID acts as a unique Id that MySQL generates and associates with every transaction that takes place within your…
How can use two database in stored procedure? If we’re talking about two databases on the same server: yes, a stored procedure can access another…
How do I fix DBCC consistency errors? Method 2 – Run DBCC CHECKDB with Minimum Repair Option If restoring from the backup is not possible,…
What is UUID in PostgreSQL? UUID is an abbreviation for Universal Unique Identifier defined by RFC 4122 and has a size of 128-bit. It is…