How Insert Statement Works

When Oracle receives sql/insert query, it requires to run some pre-tasks before actually being able to really run the query.   During parsing, Database validate the syntax of the statement whether the query is valid or not.   Database validate the semantic of the statement. It checks whether a statement is meaningful or not.   […]

Read More

Oracle Cloud Platform Systems Management 2018 Associate (1Z0-930)

Hi Readers Finally, I’ve successfully passed 1Z0-930, Oracle Cloud Platform Systems Management 2018 Associate. It was almost more than 3 months that I’ve been preparing for this. The Exam contains 70 questions related to Oracle Management Cloud. To earn this certification you need to get 70% marks. This was the result of the journey: Oracle Cloud […]

Read More

Upgrade Oracle DBA 11g or 12c to 12c R2 (1Z0-074)

Hi Readers Finally, I’ve successfully passed 1Z0-074, Upgrade Oracle DBA 11g or 12c to 12c R2. It was almost more than 3 months that I’ve been preparing for this. The Exam contains 75 questions related to Oracle Database 12cR2 New Features. To earn this certification you need to get 63% marks. This was the result of […]

Read More

List of Publication

I am listing here 55 articles which I write and are published on the different Oracle Technology Network  (OTN), different Oracle User Group (OUG) and ToadWorld. OTN Spanish Oracle Cloud: Creación de Configuración Oracle RAC en Cloud Oracle Cloud: Creando base de datos en la nube en base a “backup” existente (Parte I) Oracle Cloud: […]

Read More

Oracle Autonomous Database CookBook

Written by Oracle Certified Master Skant Gupta and Oracle Certified Professional Mohit Sharma are diligently planned to direct the readers about the usage of Oracle Autonomous Database.  The primary target audience is Oracle DBAs and Oracle Cloud DBA’s. This book has been diligently planned for all levels of DBA experts. Coming right from the real-world […]

Read More

Oracle Exadata Database Machine 19.1.0 Documentation

Exadata System Software Release 19.1.0.0.0 is now generally available. This release lays the foundation for the Autonomous Database and improves every aspect of Exadata with 20+ features and enhancements. All new features and enhancements are available on all supported Exadata generations, protecting customer investment across all Exadata deployment models: on-premises, Cloud Service, and Cloud @ […]

Read More

Oracle Database 19c Now Available

The latest generation of the world’s #1 database, Oracle Database 19c, is now available on LiveSQL.oracle.com. Oracle Database 19c is a long term support release, with premier support planned through March 2023 and extended support through March 2026. For the latest Oracle Database 19c availability on other platforms, check out Document ID 742060.1 on My Oracle Support […]

Read More

RestAPI for Oracle DBaaS Cookbook

Written by Oracle Certified Master Skant Gupta and Oracle Certified Professional HariPrasath Rajaram are diligently planned to direct the readers about the usage of RestAPI with DBaaS. This book covers the most important trends providing operational best practice knowledge required for executing different API methods and calls facilitating the administration and execution of DBaaS features with Rest. […]

Read More

Oracle Database 18c New Features Book

Written by Oracle Certified Master Skant Gupta and Oracle Certified Master & Oracle ACED Joel Pérez describes the myriad new and enhanced capabilities available in the latest Oracle Database release. This book is meticulously planned for the audience keen to learn all about the amazing new features being offered by Oracle Database 18c. You must […]

Read More

PreBuilt Oracle Database 18c with Docker

In this post, we can use Docker service to pull the prebuilt Oracle Database 18c. Docker must be installed and running for this feature prerequisite. In your VM or Bare Metal, check the status and version of Docker if it is installed.

To Install Docker on your machine, please go to https://docs.docker.com/install/. As Docker is […]

Read More