Useful tips for everyday
How do you use CTE? How to write a clean CTE Query: A CTE must be followed by a single SELECT, INSERT, UPDATE, or DELETE…
Is Oracle RAC high availability? “RAC only” architecture uses Real Application Clusters and is an inherently high availability system. The clusters that are typical of…
How do I compare two procedures in SQL Developer? Diff Report Steps Open SQL Developer. Create database connections to the DEV and TEST databases to…
What are the states of a binary lock? A Binary lock has only two states: Locked or Unlocked. Other transactions cannot access locked items, not…
What is Mysqld log? MySQL Server has several logs that can help you find out what activity is taking place. By default, the server writes…
What is DBMS output? The DBMS_OUTPUT is a built-in package that enables you to display output, debugging information, and send messages from PL/SQL blocks, subprograms,…
Can Access pull data from SQL Server? How to Link an Access Database to SQL Server in Access 2016 Launch the Import/Link Wizard. Select the…
What data type is PostgreSQL? PostgreSQL has three character data types namely, CHAR(n), VARCHAR(n), and TEXT. CHAR(n) is used for data(string) with a fixed-length of…
How does streaming replication work in Postgresql 9.0? Streaming Replication (SR) provides the capability to continuously ship and apply the WAL XLOG records to some…
How do I export data from a pump? Data Pump Schema Mode. Step1: Create a Directory. Create a directory anywhere in your system and name…