Discuss in the Community - Toad World

Discuss in the Community


Ajith Narayanan
Follow /30 Nov 2015 at 7:19am / Oracle

Oracle Workflow Performance Issue

In this blogpost, we can see how to overcome the performance issues in our EBS environments, All our EBS workflows undergoes many test and incomplete workflow cycles, that starts giving performance issues over a time period. This is a step-by-step guide...
8 0 /
Iggy Fernandez
Follow /30 Nov 2015 at 5:16am / Oracle

OT: The Best Job Interview of My Life

I’ve written often enough about terrible job interviews before ( The Worst Interview of My Life ; How Not to Interview a Database Administrator: The Google Way ; How to interview an Oracle DBA candidate NOT ) but that’s not to say that I haven’t...
176 0 /
Nakul Vachhrajani
Follow /30 Nov 2015 at 3:30am / SQL Server

#0363 – SQL Server – T-SQL Script to generate week date ranges from any given day

Recently, I was asked to help out in implementing a requirement for a reporting application. The application was designed to report weekly consumption trends from the day the report is run, and we therefore had to generate a lookup with week long date...
20 0 /
Robert Catterall
Follow /30 Nov 2015 at 1:42am / IBM DB2

DB2 for z/OS: How I Use -DISPLAY BUFFERPOOL Output

A couple of weeks ago, I was going over output of the DB2 for z/OS command -DISPLAY BUFFERPOOL with a group of people, and one of the meeting participants said words to this effect: "You've got some useful formulas and rules of thumb here. Could...
13 0 /
Mike Smithers
Follow /29 Nov 2015 at 6:00pm / Oracle

A False Sense of Security, or how Database Developers can save £35 million

Deb’s been recovering from an operation recently. During her convalescence, I have been designated as her nurse and carer. Careful planning was required prior to the op. She promised not to over do things, and I promised to attend to her every...
35 0 /
Chris Webb
Follow /27 Nov 2015 at 9:30am / SQL Server

New SSAS, Power BI And SQL Server Training Courses For 2016

I’ve just added a number of new 2016 training course dates to the Technitrain site. If you’re looking for Power BI, Analysis Services, SQL Server or Data Science training in London then please check them out! Also, if you’d like to sign up for the Technitrain...
44 0 /
Arthur Olcot
Follow /26 Nov 2015 at 8:51pm / SQL Server

UK Contractors - As you were, for now at least

I think there were are few sighs of relief around the country yesterday after the chancellor finished giving his autumn financial statement to parliament. For the past few weeks there has been plenty of reports of doom and gloom from the various media...
55 0 /
Follow /26 Nov 2015 at 8:17pm / Oracle

BGOUG Autumn Conference - Extraordinary trip

it's 19-Nov-2015 and this day means that i should start packing and prepare myself for traveling to Bulgaria, at first everything was normal and i thought it will be like any other trip i did before. since there is no direct flight to Bulgaria then...
120 0 /
Arthur Olcot
Follow /26 Nov 2015 at 8:04pm / SQL Server

Temporary Post Used For Theme Detection (b4dd5212-1214-4a73-ab89-2e9107f53b84 - 3bfe001a-32de-4114-a6b4-4005b770f6d7)

This is a temporary post that was not deleted. Please delete this manually. (9ef4d2a7-197a-4c68-8beb-0f37348d6aec - 3bfe001a-32de-4114-a6b4-4005b770f6d7)
65 0 /
Dan Hotka
Follow /26 Nov 2015 at 1:43pm / Oracle

Oracle11 SQL Inlining Coding Feature

Hi! I have been talking a little bit about the context switch when you are working with PL/SQL and SQL together. IF you call a function from the SQL statement, a context switch will occur to pass control to the PL/SQL engine then back when the PL...
61 0 /
Derik Hammer
Follow /26 Nov 2015 at 1:00pm / SQL Server

Statistics Parser

Today I’d like to recommend a free community tool, StatisticsParser.com . Statistics Parser is web-based tool for interpreting the text output of the T-SQL SET STATISTICS IO and TIME settings. The tool was created and is maintained by Richie Rump...
48 0 /
Sten Vesterli
Follow /26 Nov 2015 at 12:54pm / Oracle

Brand-new Oracle Forms 12c heading out of support

I was happy that Oracle finally got around to releasing Oracle Forms 12c, and confidently expected Oracle to offer us the normal 5 years of premier support and 3 years of extended support. But that's not what happened. You see, Oracle considers...
120 1 /
Clarisa Maman Orfali
Follow /26 Nov 2015 at 2:21am / Oracle

Definir Valores de Interfaz de Usuario por Defecto (UI) en Oracle APEX 5.0

Muchas veces estamos usando en nuestra aplicación tablas de datos en Informes/Pantallas en diferentes páginas y lo que es habitual siempre necesitamos cambiar el nombre de los encabezados de columnas para que sea más representativo...
64 0 /
Paul Turley
Follow /26 Nov 2015 at 2:09am / SQL Server

Complete DAX Function Reference

The DAX function reference documentation in MSDN can be found on separate pages,  organized by categories but you can’t view all of the functions in one page.  If you don’t know exactly what you’re looking for, this can be a bit of a hunting...
63 0 /
Ed Elliott
Follow /25 Nov 2015 at 10:42pm / SQL Server

Convert select statements in scripts into Inline-TVF's automatically

In-line TVF's are awesome, they are a great way to reuse T-SQL code without the performance penalties of multi line TVF's or horror of horrors Scalar Functions. Taking select statements and turning them into in-line TVF's is actually really...
62 0 /
Fernando Garcia
Follow /25 Nov 2015 at 10:36pm / Oracle

¿Para qué sirve la cláusula CROSS APPLY?

La versión 12c del servidor de base de datos Oracle incluye una nueva extensión del lenguaje SQL: la cláusula CROSS APPLY. Existen diversos escenarios en los que dicha cláusula nos resulta de gran utilidad. En general, los...
157 0 /
Thomas LaRock
Follow /25 Nov 2015 at 5:09pm / SQL Server

The DBA Plate for 2016

Four years ago I wrote about the DBA Plate, which was a reference to the food plate that replaced the food pyramid right about the time the U.S. Congress declared pizza to be a vegetable. I had every intention of keeping the plate updated annually but...
64 0 /
Ed Elliott
Follow /25 Nov 2015 at 5:07pm / SQL Server

ScriptDomVisualizer - Now Displays TSqlParserToken's

New ScriptDom visualizer now also shows the tokens that are found in a sql script. It also highlights the part of the query that is covered by the token so it is really easy to see where you are in the script. Honestly if you are doing anything with...
65 0 /
Denny Cherry
Follow /25 Nov 2015 at 4:00pm / SQL Server

Inline Nonclustered Indexes

One of the new features that I just recently learned about in SQL Server 2014 is the ability to create nonclustered indexes on a table inline with the creation of the table. This is handy in a couple of ways. First it makes it so that all the indexes...
73 0 /
Craig Mullins
Follow /25 Nov 2015 at 4:00pm / IBM DB2

Happy Thanksgiving 2015

Every year this week those of us in the USA take time out to give thanks for all that we have. We do this by taking time off of work, gathering with our families, eating turkey (and a lot of other stuff), and watching football. It is one of my favorite...
185 0 /
Norm [TeamT]
Follow /25 Nov 2015 at 3:45pm / Oracle

UTL_FILE Operation fails with ORA-29283

A process that called ”UTL_FILE” was failing in the test system, but worked fine with exactly the same set up in production. Why? The error was ORA-29283: invalid file operation. How do we find out exactly why it was failing? MY_DIRECTORY...
61 0 /
Kenneth Fisher
Follow /25 Nov 2015 at 2:00pm / SQL Server

Women in technology

Earlier this week a friend of mine (Lynn Swayze (Hall) ( b / t )) posted this great article on women in technology . It’s a great read and I highly recommend it. In fact, go read it right now. I’ll wait. You’re back? Good. So, her...
68 0 /
Svetoslav Gyurov
Follow /25 Nov 2015 at 10:04am / Oracle

How to rename ASM disk groups in Exadata

Deployment of Exadata requires you to generate configuration using Oracle Exadata Deployment Assistant (OEDA). Within the same the default  ASM disk groups names are DBFS_DG, RECOC1 and DATAC1. I usually change those to RECO01 and DATA01 as others doesn’t...
67 0 /
Deiby Gomez
Follow /25 Nov 2015 at 6:40am / Oracle


In our daily tasks as a Database Administrator it's common to see requests to get the DDL sentence from any object. Everybody knows that there is the package DBMS_METADATA that can be used for this kind of requests. But most of the DBAs uses DBMS_METADATA...
172 0 /
Clarisa Maman Orfali
Follow /25 Nov 2015 at 2:20am / Oracle

Crear Informe-Formulario tipo Maestro-Detalle en Oracle APEX 5.0

Una de las más populares características en Oracle APEX es el asistente para crear un formulario del tipo Maestro/Detalle con el cual fácilmente podemos crear un informe y su correspondiente formulario (Pantalla) para manejar los...
91 0 /