Expert Blogs

Blogs

Clarisa Maman Orfali

Getting to Know the Toad for Oracle Schema Browser

The Schema Browser is an interface that allows us to work with various objects in the database. To learn about this interface, we first open Toad and connect to a database schema. For this example, we are using the SCOTT schema of Oracle Express...
141 0 /
Tim Fritz
Follow /2 Feb 2018 at 10:04pm / Toad for Oracle Blog

Ensure PL/SQL Accuracy and Quality in the Age of DevOps: Join Quest on February 8 for a new Toad webcast series

Agile methodologies and DevOps workflows for application development are becoming common, but database development workflows have been left behind, resulting in a major bottleneck when application updates require database changes. Quest believes that...
123 0 /
Clarisa Maman Orfali

Conociendo el Navegador de Esquema del Toad for Oracle

El navegador de Esquema del “Toad for Oracle” es una interfaz que nos permite trabajar con los diversos objetos de la base de datos. Para conocer esta interfaz, abrimos el Toad y nos conectamos a un esquema de la base de datos. Para...
106 0 /
Dan Hotka
Follow /31 Jan 2018 at 3:30pm / Toad for Oracle Blog

Video: 'Dan's Dozen' Quick Toad Tips: Tip #4 - DBMS_XPLAN

You can use these Toad tips and techniques for SQL tuning: (Please visit the site to view this video)
120 0 /
Dan Hotka
Follow /31 Jan 2018 at 3:11pm / Toad for Oracle Blog

Video: 'Dan's Dozen' Quick Toad Tips - Tip #3 - Code Snippets

My tip on using code snippets: (Please visit the site to view this video)
396 0 /
Dan Hotka
Follow /31 Jan 2018 at 3:00pm / Toad for Oracle Blog

Video: 'Dan's Dozen' Quick Toad Tips - Tip #2 - Auto Replace

Here's my second tip, hope you're finding them useful! (Please visit the site to view this video)
116 0 /
skant.gupta
Follow /30 Jan 2018 at 2:00pm / Toad for Oracle Blog

Oracle 12cR2: Cross-Platform PDB Transport Using XTTS

Hi Readers Oracle 12cR2: Cross-Platform PDB Transport Using XTTS For Reading, Click Here: http://blog.enmotech.com/2018/01/10/oracle-12cr2-cross-platform-pdb-transport-using-xtts/ #Oracle #CloudComputing #Cloud #Data #SelfDriving #AutonomousDB...
99 0 /
Dan Hotka
Follow /29 Jan 2018 at 6:42pm / Toad for Oracle Blog

Video: 'Dan's Dozen' Quick Toad Tips - Tip #1 - Toad Insights

Welcome to my new quick video series, Dan's Dozen Toad Tips! Here's today's tip: (Please visit the site to view this video)
299 0 /
skant.gupta
Follow /29 Jan 2018 at 2:00pm / Toad for Oracle Blog

RMAN one of the best tools to move “On-prem” databases to the Cloud

Hi Readers RMAN one of the best tools to move “On-prem” databases to the Cloud For Reading, Click Here: http://blog.enmotech.com/2018/01/11/rman-one-of-the-best-tools-to-move-on-prem-databases-to-the-cloud/ #Oracle #CloudComputing...
79 0 /
Pini.Dibask
Follow /28 Jan 2018 at 5:00pm / Oracle Blog

ILOUG Summary + My presentation

Last week, ILOUG (Israel Oracle User Group) hosted an awesome Oracle conference in Israel which included 30 Oracle speakers from 9 countries and 45 different sessions. This event was organized by Ami Aharonovich, Zohar Elkayam, and Oren Nakdimon, all...
219 0 /
Dan Hotka
Follow /26 Jan 2018 at 7:47pm / Oracle Blog

Oracle Coding Best Practices: Making a CASE for the CASE statement

This article will discuss the CASE statement. PL/SQL has had the CASE statement since Oracle9 I believe (an eternity for most of today’s coders). I will also illustrate a little-known fact: The CASE statement also exists for SQL! I believe this...
370 4 /
zaheer.appsdba
Follow /26 Jan 2018 at 7:24pm / Postgres - Blog

Postgres/EDB Database Management with PEM

Database administration and management is required for any database on which there are continuous business transactions. If databases across enterprises are not monitored and maintained, then such databases are vulnerable to disasters, which eventually...
238 0 /
Deiby Gomez
Follow /26 Jan 2018 at 7:05pm / Oracle Blog

What Oracle 12cR2 brought us in 2017 and what Oracle brings us for 2018

By Deiby G ó mez (OCM11g , MAA OCM 12c and Oracle ACE Director) The year 2017 brought us a lot of good Oracle stuff; Oracle Database version 12cR2 was released for On Premises, and the new Autonomous Database 18c was announced at Oracle Open...
670 0 /
skant.gupta
Follow /25 Jan 2018 at 2:00pm / Toad for Oracle Blog

Oracle 12cR2: Cross-Platform Transportable PDB

Hi Readers Oracle 12cR2: Cross-Platform Transportable PDB For Reading, Click Here: http://blog.enmotech.com/2018/01/10/oracle-12cr2-cross-platform-transportable-pdb/ #Oracle #CloudComputing #Cloud #Data #SelfDriving #AutonomousDB #AutonomousDatabase...
73 0 /
skant.gupta
Follow /24 Jan 2018 at 2:00pm / Toad for Oracle Blog

Starting Oracle Database Cloud.. Where the DBAs are going to be working.. ?

Hi Readers Starting Oracle Database Cloud.. Where the DBAs are going to be working.. ? For Reading, Click Here: http://blog.enmotech.com/2018/01/11/starting-oracle-database-cloud-where-the-dbas-are-going-to-be-working/ #Oracle #CloudComputing...
91 0 /
skant.gupta
Follow /23 Jan 2018 at 2:00pm / Toad for Oracle Blog

12 Things You Need to Know about Oracle Database 12c R2

Hi Readers 12 Things You Need to Know about Oracle Database 12c R2 For Reading, Click Here: http://blog.enmotech.com/2018/01/11/12-things-you-need-to-know-about-oracle-database-12c-r2/ #Oracle #CloudComputing #Cloud #Data #SelfDriving #AutonomousDB...
135 0 /
Deepak Vohra
Follow /22 Jan 2018 at 9:19pm / NoSQL Blog

Using Docker Windows Containers with Databases

Docker for Windows was introduced recently. Docker for Windows runs Docker containers on Windows OS similar to running Docker containers on Linux platforms. The novelty of Docker for Windows is Docker Windows containers. Docker Windows containers differ...
154 0 /
Denny Cherry
Follow /22 Jan 2018 at 4:00pm / SQL Server Blog

Where Denny went during PASS and Live360 Events

https://www.flickr.com/photos/128733321@N05/17222900949/in If you were at the PASS Summit, Live360 in November, or SQL Saturday in Slovenia in December, you may have noticed that I couldn’t make it to these events. It turns out that I had a medical...
177 0 /
skant.gupta
Follow /22 Jan 2018 at 2:00pm / Toad for Oracle Blog

ORACLE 12CR2 ( NEW FEATURES ): CLONING REMOTE PDBS IN HOT MODE

Hi Readers ORACLE 12CR2 ( NEW FEATURES ): CLONING REMOTE PDBS IN HOT MODE For Reading, Click Here: http://blog.enmotech.com/2018/01/09/oracle-12cr2-new-features-cloning-remote-pdbs-in-hot-mode/ #Oracle #CloudComputing #Cloud #Data #SelfDriving...
111 0 /
Robert Catterall
Follow /22 Jan 2018 at 7:47am / IBM DB2 Blog

Db2 12 for z/OS and Insert Algorithm 2: Faster, More-Efficient INSERTs than Ever Before

Near the end of the blog entry I most recently posted prior to this one , I mentioned that a specification of MEMBER CLUSTER for a Db2 for z/OS universal table space could help maximize INSERT throughput and efficiency, in situations where the importance...
113 0 /
skant.gupta
Follow /18 Jan 2018 at 2:00pm / Toad for Oracle Blog

Upgrading a Single Regular PDB from 12.1 to 12.2

Hi Readers Upgrading a Single Regular PDB from 12.1 to 12.2 For Reading, Click Here: http://blog.enmotech.com/2018/01/10/oracle-12cr2-upgrading-a-single-regular-pdb-from-12-1-to-12-2/ #Oracle #CloudComputing #Cloud #Data #SelfDriving #AutonomousDB...
132 0 /
zaida.villanova
Follow /18 Jan 2018 at 11:38am / Toad Edge - Blog

How to create an "Empty database" project in Jenkins with the help of Toad Edge

In this post we are going to create a project in Jenkins that drops all objects from a database to prepare it for a clean script deployment. In order to do this in Jenkins, we need the sql script that drops and recreate the database and the connection...
94 0 /
Syed Jaffar Hussain
Follow /18 Jan 2018 at 9:05am / Oracle Blog

Oracle Cloud - Database Services

This blog post highlights some of the essentials of Oracle cloud Database service offerings and its advantages. Also discuss about Database deployment (DBaaS) benefits and tools that can be used to automate backup/recovery operations and maintenance tasks...
253 0 /
Deepak Vohra
Follow /17 Jan 2018 at 9:48pm / Toad for SQL Server Blog

Using Toad for SQL Server with AWS RDS

Introduction Toad for SQL Server is an integrated development environment (IDE) for accessing, administering and using SQL Server. The SQL Server may be on a local machine or may be on a remote platform such as AWS RDS, EC2, Azure, or Google Cloud...
78 0 /
skant.gupta
Follow /17 Jan 2018 at 2:00pm / Toad for Oracle Blog

Controlling the Degree of Parallelism of Queries

Hi Readers Controlling the Degree of Parallelism of Queries For Reading, Click Here: http://blog.enmotech.com/2018/01/10/oracle-12cr2-controlling-the-degree-of-parallelism-of-queries/ #Oracle #CloudComputing #Cloud #Data #SelfDriving #AutonomousDB...
113 0 /