In this COVID-19 pandemic period, the popularity of Crypto coins heavily increased among society. The majority of society isolated in their homes and most of them tend to follow online earnings. Ten out of nine people will be interested in cryptocurrency trading because popular coins’ prices increased higher and higher day by day.

I am working on a project these days that are related to cryptocurrency trading platforms. My company already had created a web crawler that capable of crawl crypto coin tables from the reputed crypto trading platform when they assigned me. After I am in, my supervisor assigns…

In previous story, we have covered creating CDB and PDBs.

  1. Part 1Install Oracle Database 19.3c on CentOS 7 -:
  2. Part 2Oracle Database 19.3c — Multitenant Architecture, Create CDB and PDB -:

In this part I am going to talk about listener and how we register PDB with a listener. Before we begin let us talk about listener.

What is listener in oracle?

If we simply explain, Listener is the middleware between user and the servers.

If we discuss in advance, Listener is a server-side process that can listen to incoming requests from client side and manage traffic to the…

In previous story, we covered how to install oracle 19.3c on CentOS 7 ( In this part we will cover installation of CDB and PDB. Before began installation, lets talk about what is CDB and PDB.

Multitenant Architecture

  • After Oracle 12c, Oracle came up with new architecture called “Multitenant Architecture.”
  • In previous versions of Oracle database versions main problem was, if user start new instance there are particular background processes for each instance. This process is kind of memory wasting thing and affect to the system performance badly.
  • Therefore, Oracle came up with the new idea to connect different databases into one…

What is Oracle Database?

Oracle Database is a multi-model database management system. It means a database that can store, index, and query data in more than one model. Also, it is a free product that can use by everyone.

What are the uses of Oracle Database?

Most commonly, it uses Data Warehousing (DW), Online Transaction Processing (OLTP), and both mix of DW and OLTP.

Evaluation of Oracle Database

Oracle started its first product as “Oracle v2” and then upgraded it until “Oracle 7.3” as regular versions.

After that, they evaluate their oracle versions using three categories that started in 1998.

  • The “i” version -: Stands for “internet.” Ex: Oracle 8i, Oracle 9i
  • The “g” version…

Many peoples have lot of problems with C format specifiers. Most of them don’t know how to use it, when can use it, ranges of data types and etc. I have studied these format specifiers and it takes few hours to complete this article.

I would like to show these using table and give an example to each format specifier by explain them.


Format  Description  Type              range         Uses
%c Character char -128 to 128 Use to output
single character
%c Character unsigned char 0 to 255 Use to output
single character
%s String…


Nowadays, information retrieval systems are viral and very useful to peoples seeking answers to their problems and managing their time. Medical information retrieval systems are one of the critical systems out of other retrieval systems. Those are very important for doctors, patients, and all who are related to the medical side. If someone searches for medical information in WWW (World Wide Web), they can get more than a thousand results related and non-related to your topic there for you will find it challenging to get the most helpful answer to your question. If someone can access a system that is…

Kalana Eranda Jayasuriya

Research Analyst at CoinGuru | Data Science Undergraduate from Sri Lanka Institute of Information Technology

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store