New OCI GoldenGate Service is First of Any Major Cloud Provider to Deliver Operational and Analytic Integration into a Single Data Fabric

• 
• 
• 
• 
• 
• 

PrevNext

Oracle Corporation is unveiling Oracle Cloud Infrastructure GoldenGate. Oracle Cloud Infrastructure GoldenGate is a fully-managed cloud service that customers can use to help ensure that their valuable data is always available and analyzable in real-time. Best of all, Oracle Cloud Infrastructure GoldenGate is built on the industry leading,...

Continue reading

DynamoDB - Basic Concepts

Before using DynamoDB, you must familiarize yourself with its basic components and ecosystem. In the DynamoDB ecosystem, you work with tables, attributes, and items. A table holds sets of items, and items hold sets of attributes. An attribute is a fundamental element of data requiring no further decomposition,...

Continue reading

Oracle Enterprise Database Service

• 
• 

PrevNext

Oracle Enterprise Database Service’s managed compute and storage infrastructure allow customers to efficiently run Oracle Database workloads in Oracle Cloud Infrastructure (OCI). Consumption-based subscription pricing for managed compute and storage infrastructure with low-cost OCI block storage enable IT departments to lower the cost of running Oracle Database workloads...

Continue reading

SQL: Subqueries to Solve Queries

• 
• 

PrevNext

A subquery is best defined as a query within a query. Subqueries enable you to write queries that select data rows for criteria that are actually developed while the query is executing at run time. More formally, it is the use of a SELECT statement inside one of...

Continue reading

Elevate your database into the cloud using Oracle Cloud Infrastructure Database Migration

• 
• 

PrevNext

Oracle has reinvented databases in the cloud by providing self-driving, self-securing, and self-repairing databases such as  Autonomous Transaction Processing and Autonomous Data Warehouse. These database solutions eliminate the complexities of operating a database, securing data, and developing data-driven applications. Today, we’re launching the new managed cloud service Oracle...

Continue reading

Difference between SQL Server and Oracle

• 
• 

PrevNext

What is Microsoft SQL server?MS SQL server is a database product of Microsoft. It allows users to SQL queries and execute them. It is among the most stable, secure and reliable database solutions. It supports wide variety of transaction processing, analytics, and business intelligence applications in corporate IT...

Continue reading

Introduction of Object Oriented Programming

• 
• 
• 
• 
• 

PrevNext

As the name suggests, Object-Oriented Programming or OOPs refers to languages that use objects in programming. Object-oriented programming aims to implement real-world entities like inheritance, hiding, polymorphism, etc in programming. The main aim of OOP is to bind together the data and the functions that operate on them...

Continue reading

Difference between OOP and POP

• 
• 

PrevNext

OOP:Related with the real life objects and their properties. OOP Concepts:1. Class and Objects2. Data abstraction3. Encapsulation4. Polymorphism5. Inheritance POP:Related with the conventional style. This approach is also known as the top-down approach. In this approach, a program is divided into functions that perform specific tasks. This approach is...

Continue reading

Difference between Database Administrator vs Database Architect

• 
• 

PrevNext

1. Database Administrator:Database administrator is a person who creates updates and maintains the database. It is more of a wide role as a data administrator might be someone who is hired to create, maintain, and backup the database, optimize the database for high performance or someone who helps...

Continue reading

Difference between Structured Programming and Object Oriented Programming

• 
• 

PrevNext

1. Structured Programming :Structured Programming, as name suggests, is a technique that is considered as precursor to OOP and usually consists of well-structured and separated modules. In this programming, user can create its own user-defined functions as well as this methodology tries to resolve issues that are associated...

Continue reading

Simple migration from Oracle multimedia to secure-file blob data type

Support for the Oracle Multimedia data type was ended in the Oracle Database 19c release, so we wanted to provide some guidance for working with this data type from that release onward.Oracle recommends that you store multimedia content in secure files lob and use third party products such...

Continue reading

Blockchain Tables in Oracle Database 21c

• 
• 

PrevNext

A blockchain table is a tamper-proof, insert-only table with an associated table-level and row-level retention period.This feature has been backported to Oracle 19.10, but also requires patch 32431413 and the COMPATIBLE parameter set to 19.10. In future release update for 19c, the additional patch shouldn't be necessary.When learning...

Continue reading