Oracle Database

Herkese Merhabalar Oracle Indexlere Değinmeyi Planlıyorum Kısa ve Öz Şekilde Yazmayı Planlıyorum Umarım Şimdiden Faydalı Olur Haydi Başlayalım :) İçerik Index Çeşitleri | Index Scan |Index Kullanımı Etkileyen Yanlışlıklar | Index Kullanımı Takip Etmek | Index Rebuild | CBO (Cost Based Optimizer) |Index Clustering Factor Index Nedir Verilere Daha Hızlı Erişmek…

A JSON viewer for visualising the API request’s The current project that I handle in my current organization facilitates the fintech companies to communicate with the banking services like checking the account balances, making payments, creating standing orders for OTT subscriptions, etc. One of the roles we have as apart…

You might have seen lot of articles with node webserver and some with node REST API. Here I am demonstrating a webserver which is consuming a REST API created in oracle OCI. So what components to be used and in what order is what you will see shortly. In this article…

Database patch management is a very critical and operationally time consuming issue for Infrastructure Admins. According to the systems you manage and your needs, patches should be applied in 3–6–12 month periods. It means downtime, workload, planning load ... There are few enterprise and open source solutions for this problem…

In a nutshell, SOA (service-oriented architecture) is a framework for integrating applications into a service model. Applications written in any programming language can exchange data when speaking over HTTP utilising the SOAP or REST protocols. Numerous vendors, including Oracle, Mule, IBM, Apache, etc., support the SOA framework. Among these, Oracle…

Earlier in Part 1, we looked at various DBCLI commands to administer the Oracle Database Cloud Service instance. In this article, we will focus on configuring Oracle Database Cloud Service Backup using the DBCLI utility. Assumption: This article assumes that you are using 1 Node DB System. When you provision…

Veja nesse post rápido como criar um container docker com o oracle 21.3.0 O foco deste post rápido será demonstrar como subir um ambiente com a base de dados Oracle na versão 21.3.0 em um container docker. No final deste artigo você vai ter configurado um banco de dados oracle…

This story, I will add my frequently used Sql commands and the queires to fetch some important facts in a db (specially a oracle DB) Note :- I will be keep on adding this list as I learn and use them :D If you are new to SQL you may…

Have you ever wanted to be able to predict the sale price of a property? In this demo, we are going to predict the sale price of Brooklyn family homes using the power of Oracle’s Autonomous Data Warehouse (ADW) in the cloud and Oracle Machine Learning (OML) notebooks. In this…