Expert Blogs - Toad World

Expert Blogs


Brendan Tierney
Follow /6 May 2016 at 1:01pm / Oracle

Advanced Analytics in Oracle Data Visualization Desktop

Oracle Data Visualisation Desktop has the feature of being able to include some advanced analytics. In a previous blog post I showed you how to go about installing Oracle R Distribution on your desktop/client machine. This will allow you to make use of...
37 0 /
Fernando Garcia
Follow /6 May 2016 at 12:58am / Oracle

Expresiones regulares y listas de caracteres de igualación.

No me resulta fácil explicar cómo funcionan las listas de caracteres de igualación. Vayamos directamente con un ejemplo. A diferencia del “.” que iguala con cualquier caracter, las listas nos permiten “limitar”...
86 0 /
Ed Elliott
Follow /6 May 2016 at 12:03am / SQL Server

SQLCover v 0.2 - Bug fixes and Azure V12 Support

I have released a new version of SQLCover which is a code coverage tool for T-SQL (let's you identify where you need to focus when writing tests). This includes a few minor fixes but also support for SQL Azure so if you run your test in a v12 database...
49 0 /
Craig Mullins
Follow /5 May 2016 at 6:29pm / IBM DB2

I'm Co-Presenting with a Couple of DB2 Experts at IDUG

I have the absolute pleasure of being able to co-present on a couple of great DB2 topics with two very knowledgeable and great speakers at this year's North American IDUG conference in Austin, TX. The first session is on Tuesday, May 24, 2016 at 1...
23 0 /
Follow /5 May 2016 at 1:48pm / Oracle

EBS Clone R12.2.4 Guide

In This document i will show how to clone EBS R12.2.4 Step by step Link Here Thank Osama
47 0 /
Follow /5 May 2016 at 12:46pm / Oracle

OBIA Installation

The following link describe how to install OBIA on Linux 6.7 Here Thank you Osama Mustafa
46 0 /
Steve Hilker
Follow /4 May 2016 at 8:43pm / Toad for Sybase

Toad for SAP Solutions v3.1 is now available

We are pleased to announce the release of Toad for SAP Solutions v3.1. This new version is now available for customers to download at SupportLink and for trial download at Toad for SAP Solutions . Toad for SAP Solutions is a comprehensive solution...
158 0 /
Steve Hilker
Follow /4 May 2016 at 8:39pm / Toad for IBM DB2

Toad for DB2 v6.2 is now available

We are pleased to announce the release of Toad for DB2 v6.2. This new version is now available for customers to download at SupportLink and for trial download at our Toad for DB2 product page on Toad for DB2 is a comprehensive solution...
162 0 /
Denny Cherry
Follow /4 May 2016 at 5:00pm / SQL Server

When using Always Encrypted in SQL Server 2016, how do I as the DBA view the data?

The short answer is, you don’t. The entire point of Always Encrypted is that the DBA can’t view or modify the data using SQL Server Management Studio. The only way to view and change the data is by using the front end application that created...
58 0 /
Henrik Loeser
Follow /4 May 2016 at 3:11pm / IBM DB2

Starter Kit for Data-Driven Cloud App with Access to On-prem Resources

26 0 /
John Pocknell
Follow /4 May 2016 at 1:29pm / Toad for Oracle

Introduction to Toad Intelligence Central

If you have been reading the Toad for Oracle blogs over the last few months, you’ll have doubtless seen references to the new Toad for Oracle Agile Cookbook as well as references to DevOps. So, you ask, what’s going on? Well, we have...
56 0 /
Follow /4 May 2016 at 1:29pm / Oracle

Ensuring Data Protection Using Oracle Flashback Features - Part 2

Introduction In the previous article we have reviewed the basics of Oracle Data Protection, and explored Oracle Data Protection solutions. We also covered the data protection objectives which are measured by the RPO (Recovery Point Objective) and RTO...
51 0 /
Sten Vesterli
Follow /4 May 2016 at 11:56am / Oracle

Which Oracle Development Tool?

I was just in Istanbul last week for the Turkish Oracle User Group TROUG Days 2016, where I gave my popular Oracle development tools overview presentation covering Forms, APEX, ADF, JET and MAF. One interesting thing from discussions with Oracle developers...
131 0 /
Dan Hotka
Follow /3 May 2016 at 5:51pm / Oracle

Oracle12 New PL/SQL Role

This technical tip came up at a recent user group meeting where I was doing my Oracle12 New Features presentation. One of the many features I like is the fact that there is now a role to grant PL/SQL routines (I would think mostly functions) access...
153 0 /
Ed Elliott
Follow /3 May 2016 at 5:13pm / SQL Server

How do you audit automatically generated sql deployment scripts?

I saw recently an email where someone stated that the reason that they manually create deployment scripts is that because of the restirctions put on them by the requirements for auditing and the ability to be able to demonstrate exactly what was deployed...
134 0 /
Brad Wulf
Follow /2 May 2016 at 5:14pm / Toad for Hadoop - Blog

Toad for Hadoop & Spark SQL Explainer

With the release of Toad for Hadoop 1.5, the Toad team has introduced support for Spark SQL . This is kind of a big deal! If you’re new to Hadoop, you might be overwhelmed by the number of new projects that seemingly spring up every month. Simply...
222 0 /
Brendan Tierney
Follow /2 May 2016 at 3:49pm / Oracle

Setting up OBIEE Sample App VM to use Oracle R Enterprise

Oracle semi regularly releases a new version of their OBIEE Sample App virtual machine. The most recent versions have had examples of using Oracle R Enterprise built into the demo dashboards. Unfortunately Oracle R Enterprise (ORE) does not work or is...
71 0 /
Follow /2 May 2016 at 3:18pm / SQL Server

PowerSehll : How to suppress the table heading and remove the blank space from a text file

There are a multiple ways to suppress and remove the first line from text file. The first scenario would be writing a suppressed heading to an output text file Or after writing, we can remove the line using trim function Or using the trick shared in PowerShell...
258 0 /
Follow /2 May 2016 at 1:57pm / Oracle

Ensuring Data Protection Using Oracle Flashback Features - Introduction (Part 1)

Introduction This article is the first part of my article series regarding data protection using Oracle Flashback Features. Ensuring Data Protection for Oracle Databases is one of the most important tasks every Oracle DBA is faced with. Without protecting...
75 0 /
Dan Hotka
Follow /2 May 2016 at 1:24pm / Oracle

PC Support Call – a scam of the worst kind…

Scam focusing on home computer users I’ve heard of this scam but have not received the call. Last night, I received the call. It came in as ‘out of area’ caller. He presented himself as “Peter from PC Support…”...
153 0 /
Johannes Ahrends
Follow /2 May 2016 at 1:19pm / Oracle

Flashback Functions – One Name, different Techniques

Part 1: Flashback Database Since version 9i there is the term “Flashback” in the Oracle Technology. However it is often hard to harmonize the different terms and corresponding technologies. Let’s start with the definitions: Flashback...
142 0 /
Deiby Gomez
Follow /1 May 2016 at 6:51pm / Oracle

Upgrading TFA to use the RAC and DB Support Tools

If you have installed Grid Infrastructure you will notice that TFA is already included there, and actually TFA started to be included since Oracle GI The version that come with GI is as you can see below: [root...
384 0 /
Porus Homi Havewala
Follow /1 May 2016 at 10:40am / Oracle

Snap Clone Via Self Service Portal – Part 1

A friend asked: “I am setting up the “PDB as a service portal” in Enterprise Manager Cloud Control 13c. I want to ask, how I can create a profile for a pdb as this is a requirement for a creating a template for the self service portal...
94 0 /
Iggy Fernandez
Follow /1 May 2016 at 7:00am / Oracle

When SQLT is not enough

When tuning a SQL query, I rely on a SQLT report because it has all kinds of pertinent information including—to name just a few—optimizer settings, indexes, statistics, plan history, and view definitions. However, recently I came across a...
1335 0 /
Ajith Narayanan
Follow /1 May 2016 at 6:36am / Oracle

Loading Data From CSV File Into MySQL Table

This is my first ever post in MySQL, Reason is that I just started working in MySQL very recently. My requirement of the day was very simple, I had to load a set of data rows from a csv file into a table. I was very sure that, there should be something...
76 0 /