Discuss in the Community - Toad World

Discuss in the Community


Clarisa Maman Orfali
Follow /2 Dec 2015 at 3:23am / Oracle

Crear Filtros en Pantalla Tabular en Oracle 5.0

En el artículo de hoy voy a responder una consulta que me hicieron de cómo colocar filtros a un Formulario Tabular en Oracle APEX 5.0 Para ello primero de todo creamos una Pantalla Tabular con el asistente y usamos la tabla EMP para ejemplo...
7 0 /
Ryan Adams
Follow /1 Dec 2015 at 9:24pm / SQL Server

High Availability and Disaster Recovery Training in Austin

I’ll be doing a precon for SQLSaturday #461 in Austin on January 29th, 2016 titled “Creating a High Availability and Disaster Recovery Plan” .  If you are in the area or thinking of attending this event, I would love to have you in the...
28 0 /
Deiby Gomez
Follow /1 Dec 2015 at 5:02pm / Oracle

How to create a CDB with sqlplus and 12c Documentation

In this article I will show you how to create a CDB using sqlplus and oracle documentation. I found some problems while I was playing with this that you have to know in case to save time and stress :) I have put some links from Oracle Documentation...
136 0 /
Follow /1 Dec 2015 at 4:42pm / SQL Server

What You Are Missing by Sticking with SQL Server 2005: Data Architects Version

On 12 April 2011 it was Yuri’s Night — the night we space fans celebrate Yuri Gagarin’s 1961 history-setting flight into space.  We were celebrating 50 years of manned spaceflight. On that same day in 2011, we reached the end of...
82 0 /
James Serra
Follow /1 Dec 2015 at 4:00pm / SQL Server

Storage options on Azure

Microsoft Azure is a cloud computing platform and infrastructure, created by Microsoft, for building, deploying and managing applications and services through a global network of Microsoft-managed and Microsoft partner-hosted datacenters.  Included in...
29 0 /
Steven Feuerstein
Follow /1 Dec 2015 at 2:48pm / Oracle

SQL%ROWCOUNT: What/how much did my SQL statement do?

This post is courtesy of the PL/SQL Challenge quiz ending 27 November 2015 : If a SELECT INTO statement without a BULK COLLECT clause returns multiple rows, PL/SQL raises the predefined exception TOO_MANY_ROWS and SQL%ROWCOUNT returns 1, not the actual...
39 0 /
David Fitzjarrell
Follow /1 Dec 2015 at 2:22pm / Oracle

Export-Import Business

"Don't you know anything at all about numbers?" "Well, I don't think they're very important," snapped Milo, too embarrassed to admit the truth. "NOT IMPORTANT!" roared the Dodecahedron, turning red with...
26 0 /
Stuart Ainsworth
Follow /1 Dec 2015 at 2:00pm / SQL Server

#BigData is coming; what should SQL Server people do about it?

I’ve been presenting a lot on Big Data (specifically Hadoop) from the perspective of a SQL Server DBA, and I’ve made a couple of recent observations.  I think most people are aware of the fact that data generation is growing at a staggering...
41 0 /
Steve Hood
Follow /1 Dec 2015 at 1:00pm / SQL Server

Querying the Plan Cache

I love working with indexes, and I need to know what’s using them to work on them intelligently. Most of that information is already there waiting for you to query it. Luckily, Jonathan Kehayias (b|t) did the hard work for us in his post Finding...
27 0 /
Dan Hotka
Follow /1 Dec 2015 at 12:45pm / Oracle

PL/SQL Package Technique

Hi! In my classes/speaking engagements/webinars (I guess these are speaking engagements…) I push loading and using Associative Arrays to do repetitive data lookup. Stuff like the names of countries, the names of the states, the colors from...
43 0 /
Kellyn PotVin
Follow /30 Nov 2015 at 11:55pm / Oracle

Top 5 SQL Monitor Features

SQL Monitor is one cool tool.  Via EM12c, it empowers everyone, (yes, that means the developer, too, so give them the access to view this data via Cloud Control, please!)  This is a top five list, but it doesn’t stop there, just remember, this is...
42 0 /
Robert Catterall
Follow /30 Nov 2015 at 11:39pm / IBM DB2


Having recently posted a blog entry on my use of output from the DB2 for z/OS -DISPLAY BUFFERPOOL command , it seems a good time to post a companion entry focused on the -DISPLAY GROUPBUFFERPOOL command. Obviously, this latter command is relevant to people...
22 0 /
Follow /30 Nov 2015 at 10:32pm / SQL Server

Round a datetime to the nearest minute (or down to the minute)

Last week I was doing a comparison of 2 datetime fields, but I only wanted to do the comparison on the minute level. So I needed something to round the datetime to the nearest minute or down to the minute. I found this great answer on SO : DECLARE @dt...
38 0 /
Denny Cherry
Follow /30 Nov 2015 at 8:23pm / SQL Server

If you fail to plan for your scale, you’ll end up with no workload at all

Today is “Cyber Monday”, the artificial “holiday” that stores have decided to create in order to separate customers from their money on the first normal work day of the holiday season. You’d think that as online retailers...
40 0 /
Thomas LaRock
Follow /30 Nov 2015 at 3:09pm / SQL Server

SQL Server Identity Values Check

Very few users have any idea how many SQL Server identity values they have remaining on a column. The post SQL Server Identity Values Check appeared first on Thomas LaRock . If you liked this post then consider subscribing to the IS [NOT] NULL newsletter...
45 0 /
Dinesh Asanka
Follow /30 Nov 2015 at 2:04pm / SQL Server

How to Avoid CXPACKETs?

CXPACKET is one of the famous wait type that database administrators are experiencing. Before moving into the details of CXPACKET wait type, - See more at: http://www.sqlshack.com/how-to-avoid-cxpackets/#sthash.lnQI7Ouh.dpuf http://dbfriend.blogspot.com...
52 0 /
Kenneth Fisher
Follow /30 Nov 2015 at 2:00pm / SQL Server

You should always have an “I got hit by a bus” backup plan

You have an on call, you have a business continuity plan, you have a disaster recovery plan but what happens when your developer, DBA or whoever is hit by a bus? The situation User : Oh noes! The web sites down! One quick call later Developer...
43 0 /
Dinesh Asanka
Follow /30 Nov 2015 at 1:53pm / SQL Server

Eight Types of Slowly Changing Dimensions (SCDs)

We typically talks about three SCDs which are Type 1, Type 2 and Type 3. In Ralph Kimball and Margy Ross Third edition of the Data Warehouse Toolkit book, they talked about eight types of SCDs. http://dbfriend.blogspot.com/feeds/posts/default?alt=rss
38 0 /
Mark Broadbent
Follow /30 Nov 2015 at 1:46pm / SQL Server

Bitesize SSIS: Passing SSIS variables into script components

I hate SSIS. It seems to me that it is full of certain nuances and unless you are regularly developing SSIS packages, they are easy to forget or it is easy to miss specific important steps. I first started using SSIS back in 2005 when it was directly...
35 0 /
John Weathington

Three Smart Strategies For Avoiding Communication Problems

Communication Breakdown Communication breakdowns are the worst kinds of problems for business analysts. As a business analysts, your job centers on effective communication. However, how many times is communication (or lack thereof) blamed for broken...
17 0 /
Sten Vesterli
Follow /30 Nov 2015 at 9:47am / Oracle

Running a distributed ADF application

You might have noticed a feature called Remote Taskflows in JDeveloper 12.2.1. This feature is actually quite interesting: It allows you to use a task flow running on a completely separate server. Technically, this is like the Web Services for Report...
116 0 /
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...
38 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 ( 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...
502 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...
41 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...
24 0 /