GoldenGate Interview Questions. What type of Topology does Goldengate support? GoldenGate supports the following topologies. More details can be found here. Unidirectional Bidirectional Peer-to-peer Broadcast Consolidation Cascading What are
Difference between Oracle and SQL server in GoldenGate setup. GG Setup on Oracle S/No Task/Feature Oracle Comments 1 Connectivity GGSCI> dblogin userid gger password userpw 2 Determine if change data
Relational Database Management System (RDBMS) Concepts. What is Data? • Data is a collection of facts, such as numbers, words, measurements, observations or just descriptions of things. • Raw
Applying 19.21 client patch on Oracle client 19c. In this article we will learn how to apply patch to oracle client software. Base version of Oracle 19c client software is
Operators in Oracle SQL*Plus with Examples. The following are the operators supported by SQL*Plus: ◆ Arithmetic operators ◆ Comparison operators ◆ Logical operators ◆ Set operators Let us discuss them
Different Select Statements in Oracle SQL . We know that to perform a query the select command is used. Apart from just providing information this command can be clubbed with
Comparision between Oracle and PostgreSQL Differences in Naming conventions. S/No Oracle PostgreSQL 1 Table or indexes Relation 2 Row Tuple 3 Column Attribute 4 Data block Page (on the disk)
Oracle Internal Datatypes with Examples: In order to create a table we need to specify a datatype for individual columns in the create table command. Oracle supports the following datatypes,
Partitioning Table based on Weekly. Range Partitions: Creating a table with weekly Partitions CREATE TABLE “STG”.”WPT” ( “END_DATE” DATE, “STATE” VARCHAR2(20), “NBR” VARCHAR2(20) ) TABLESPACE USERS PARTITION BY RANGE (“END_DATE”)
