Oracle

PLUGGABLE DATABASE HOT CLONE REFRESH AUTO

Author     : Cihan Gedik Email        : cihangedik@gmail.com Linkedin  : https://www.linkedin.com/in/cihan-gedik-13b55065/ Group      : https://www.linkedin.com/groups/13792740/   PLUGGABLE DATABASE HOT CLONE REFRESH AUTO Compatible Versions Oracle Database 12.1.x and Later   Requirements One Source PDB in CDB One Empty CDB for Target   In this post ; Database Version : …

Read More »

PLUGGABLE DATABASE HOT CLONE REFRESH MANUAL

Author     : Cihan Gedik Email        : cihangedik@gmail.com Linkedin  : https://www.linkedin.com/in/cihan-gedik-13b55065/ Group      : https://www.linkedin.com/groups/13792740/   PLUGGABLE DATABASE HOT CLONE REFRESH MANUAL Compatible Versions Oracle Database 12.1.x and Later   Requirements One Source PDB in CDB One Empty CDB for Target   In this post ; Database Version : …

Read More »

Tableau Sunucu Mimarisi

Tableau Sunucusu aynı anda birçok kullanıcının bağlanıp hizmet alabildiği güçlü bir mimariye sahiptir. Tableau Masaüstü uygulaması ile çok çeşitli zengin görseller(rapor ve dashboardlar) hazırlanabilmektedir. Tableau Masaüstü uygulamasında hazırlanan görseller Tableau Sunucusuna yüklenerek kullanıcıların erişimine sunulmaktadır. Aslında Tableau Sunucusu bir nevi Web Uygulama Sunucusu gibi çalışmaktadır. Tableau sunucu uygulamasının modüler mimarisinden …

Read More »

PL/SQL Conversion/Decoding/NULL-Related Functions

Hi Folks,   Conversion functions convert a value from one datatype to another. Generally, the form of the function names follows the convention datatype TO datatype. The NULL-related functions facilitate null handling. The encoding and decoding functions let you inspect and decode data in the database. The following list contains …

Read More »

PL/SQL Datetime Functions

Hi Folks,   Datetime functions operate on date (DATE), timestamp (TIMESTAMP, TIMESTAMP WITH TIME ZONE, and TIMESTAMP WITH LOCAL TIME ZONE), and interval (INTERVAL DAY TO SECOND, INTERVAL YEAR TO MONTH) values. Some of the datetime functions were designed for the Oracle DATE datatype (ADD_MONTHS, CURRENT_DATE, LAST_DAY, NEW_TIME, and NEXT_DAY). …

Read More »