Showing all available MySQL data types when creating a new table with MySQL for Excel

In this blog post we are going to talk about one of the features included since MySQL for Excel 1.3.0, you can install the latest GA or maintenance version using the MySQL Installer or optionally you can download directly any GA or non-GA version from the MySQL Developer Zone.

If you are familiar with the Export Data feature in MySQL for Excel you know the Excel data being exported to MySQL is meant (more...)

Oracle 12cR1 : Ya está aquí! Base de datos Oracle In-Memory


El día de ayer oficialmente salió la ultima version de la Base de Datos 12c (12.1.0.2.0), y lo peculiar de esta versión, es la inclusion de una nueva tecnología de base de datos que implementa en memoria un formato de datos columnar ,para ofrecer un procesamiento de SQL extremadamente rápido.

Entre las primeras preguntas que surgen con esta característica del RDBMS 12c, es si necesito tener toda mi base de (more...)

Just a Little Bit of Technology Awesome: Oracle HQ & Java Host Launch CMU event

| Jul 23, 2014

By Misha Vaughan, Oracle Applications User Experience



I got to see a giant monkey robot.

In June at the Launch CMU event, a research and technology startup showcase at the Oracle Conference Center in Redwood Shores, Calif, the giant monkey robot was part of an event called “Revealing Roboburgh.” There were about 150 attendees, mostly alumni from Carnegie Mellon University (CMU).  According to Michelle Kovac, Director, Java Marketing, the goal of the event (more...)

Oracle 12c Release 1 is here!

After much anticipation the new Release 1 of Oracle 12c (12.1.0.2) is finally available! Get it here: http://www.oracle.com/technetwork/database/enterprise-edition/overview/index.html What does this mean: Oracle’s ground breaking In Memory Database is now available! As they say…this is BIG. Get more details about In Memory here: http://www.oracle.com/technetwork/database/in-memory/overview/index.html I am very excited about the possibilities of what we can […]

Oracle APAC Alliances & Channels Platform Innovation Programs – Partners’ Immersion and PartnerCasts

| Jul 23, 2014

Contributors: Kean Chye Lim, Li Chiun Sally Liong, Juliana Button

What’s new this FY15 (June 1, 2014 - May 31, 2015) for Oracle Asia-Pacific (APAC) Oracle Fusion Middleware (OFM) & Technology (Tech) partners?

Within the Asia-Pacific (APAC) Alliances & Channels team, the newly formed Platform Innovation Team is focused on working with partners around 3 key initiatives to help our customers as they undertake cloud and digital transformation strategies in the year ahead 

1. Mobility (more...)

Teradata bought Hadapt and Revelytix

My client Teradata bought my (former) clients Revelytix and Hadapt.* Obviously, I’m in confidentiality up to my eyeballs. That said — Teradata truly doesn’t know what it’s going to do with those acquisitions yet. Indeed, the acquisitions are too new for Teradata to have fully reviewed the code and so on, let alone made strategic decisions informed by that review. So while this is just a guess, I conjecture Teradata won’t say anything concrete (more...)

Oracle Database 12c Release 1 (12.1.0.2) is now available

Das neue Patchset 12.1.0.2 steht auf edelivery.oracle.com und OTN für die Plattformen Linux x86-64 und Solaris zur Verfügung. Nicht nur einige Fehlerbehebungen ( Bug Fixes) sind Teil des Patchsets, sondern auch zahlreiche Erweiterungen, wie zum Beispiel:   

It’s here! Oracle Database In-Memory is officially released

Oracle Database 12.1.0.2 was officially release today and is now available for download, which mean Oracle Database In-Memory is officially here!

Along with the software release comes a whole new set of collateral that explains in detail how all of the new Oracle Database In-Memory functionality works. The In-Memory page on Oracle.com has all of the juicy details including the official whitepaper.

Here is a quick look at the Introduction (more...)

Hiding a Java Source

The ability to deploy Java inside the Oracle database led somebody to conclude that the source isn’t visible in the data catalog. Then, that person found that they were wrong because the Java source is visible when you use a DDL command to CREATE, REPLACE, and COMPILE the Java source. This post discloses how to find the Java source and how to prevent it from being stored in the data catalog.

For example, (more...)

Database In-Memory is Generally Available

Oracle Database 12c’s newest patch release 12.1.0.2 is generally available today.  In addition to a number of new enhancements for efficiency, performance, availability, and simpler application development, the most exciting aspect of this new release is the general availability of Oracle Database In-Memory.

If you missed Larry Ellison’s introduction to Oracle Database In-Memory, you can find watch a short summary of his keynote here. Oracle Database In-Memory delivers breakthrough analytical performance (more...)

Oracle Fusion Middleware 11g Release 1 Updates (2014/07/22)

| Jul 22, 2014
Oracle Fusion Middleware 11g Release 1 Media Pack について、2014/07/22 にあった更新内容をお伝えします。

1. Oracle Identity Management
Microsoft Windows x64プラットフォームにおいて、下記製品を最新メディアに更新しました。
  • Oracle API Gateway
  • Oracle Identity Manager Connectors
製品概要については、Oracle API GatewayOracle Identity Managerそれぞれの製品ページをご参照ください。

2. Oracle WebLogic Server on Oracle Database Appliance

Microsoft Windows x64プラットフォームにおいて、Oracle WebLogic Server on Oracle Database Appliance 2.9のメディアを追加しました。

以上です。


Getting Started with Coherence*Web in WebLogic Server 12.1.2 by Tim Middleton

Coherence*Web is a great feature which allows you to store your HTTP sessions in a Coherence Cluster. Doing this allows your to de-couple the HTTP sessions from your JVM’s that are running your web apps, (which can free up JVM memory) and take advantage of the RASP (Reliability, Availability, Scalability and Performance) capabilities of Coherence for storage.

With this separation you can also more easily scale and manage and your HTTP session tier as well (more...)

Oracle Fusion Middleware 12c Updates (2014/07/22)

| Jul 22, 2014
Oracle Fusion Middleware 12c Media Pack について、2014/07/22 にあった更新内容をお伝えします。

1. Oracle B2B
Oracle B2B Document Editor 12.1.3のメディアを追加しました。
Oracle B2B Document Editorは、B2B用のガイドライン作成および実装アプリケーションです。

2. Oracle Tuxedo
メディアの追加および更新がありました。
  • Oracle Tuxedo System and Applications Monitor Plus 12.1.3 for Windows x64
上記メディアを更新しました。
  • Oracle Tuxedo System and Applications Monitor Plus 12.1.1.1 for Oracle Tuxedo 12.1.1 for HP-UX Itanium (32-bit)
  • Oracle Service Architecture Leveraging Tuxedo (SALT) 12.1.1 for HP-UX Itanium (32-bit)

上記メディアを追加しました。

Big Ideas Are Good, but Every Plan Needs Building Blocks by David Talamelli

| Jul 22, 2014

A few years ago I attended a training course which was designed to help participants understand how they think and behave to help them make better decisions both individually and as part of a team. In this training I completed an Emergenetics Profile which helps you understand the way you think. There are 4 Distinct Categories which are Analytical, Structural, Social and Conceptual which are fairly self explanatory. The training was really insightful and helped (more...)

On SSE_ROLE DBA alternative

There is often an awkward quandary among DBA's whenever the development team asks the DBA to create SSE_ROLE per Oracle documentation. This is true especially in production.

Per Oracle Docuentation:
CREATE ROLE SSE_ROLE;
GRANT DBA TO SSE_ROLE;
GRANT SSE_ROLE TO OBAW;

I suggest the following alternative to my clients:
Grant schema with CONNECT, RESOURCE, and SSE_ROLE_ALT. Use SSE_ROLE_ALT instead of SSE_ROLE

Grant below privileges to OBAW:
CREATE TABLE
CREATE TRIGGER
CREATE SEQUENCE
CREATE PROCEDURE
CREATE INDEXTYPE
CREATE CLUSTER

HR and Finance Agree? – Has The World Come To An End?

| Jul 22, 2014

By guest bloggers Alex Anvari and Mike Bollinger

HR and finance executives agree on many people and performance-related issues according to a survey of HR and finance executives by Towers Watson and Forbes Insight. 

The top areas of joint activity, according to the survey were, setting annual budgets for reward programs (cited by 46 percent of finance and 62 percent of HR), determining changes to reward programs (43 percent finance and 42 percent HR), (more...)

REGEXP_LIKE: strange unspecified value in parameter “modifier”

Today I noticed strange thing in predicate section of execution plan for simple query with regexp_like, where was not specified 3rd parameter “MODIFIER”:

SQL> select * from dual where regexp_like(dummy,'.');

D
-
X

SQL> select * from table(dbms_xplan.display_cursor);

PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------
SQL_ID  97xuqf9cmjsta, child number 0
-------------------------------------
select * from dual where regexp_like(dummy,'.')

Plan hash value: 272002086

--------------------------------------------------------------------------
| Id  | Operation         | Name | Rows  | Bytes | Cost (%CPU)| Time     |
 (more...)

Oracle Public Sector Revenue Management v2.4 Dutch UI Language Pack Available Now

We are pleased to announce the general availability of Oracle Tax PSRM v2.4 UI (User Interface) Dutch language pack.

Language Patch Download:

1.   To download the Dutch language pack please log in to My Oracle Support https://support.oracle.com/CSP/ui/flash.html.

2.     Select the 'Patches and Updates' tab

3.     Type in the Patch number: 19230620

4.     Click the Patch number

5.     Download using the yellow download button on the right hand side


Database 12.1.0.1 Certified with EBS on AIX, Itanium, Windows

As a follow up to the prior announcements, Oracle Database 12c Release 1 (12.1.0.1) is now certified with Oracle E-Business Suite 11i, 12.0 and 12.1 on the following additional platforms:

Release 11.5.10.2 + ATG_PF.H.delta.7 (RUP 7):
  • IBM AIX on Power Systems (64-bit) (6.1, 7.1)
  • HP-UX Itanium (11.31)1
Release 12.0 (12.0.6 and higher):

Letölthető a Oracle Database 12.1.0.2

| Jul 22, 2014

Már letölthető az Oracle Database Enterprise Edition 12.1.0.2, jelenleg a következő platformokra (a lista tovább fog bővülni):

Linux x86-64, Oracle Solaris (SPARC systems, 64-bit) és Oracle Solaris (x86 systems, 64-bit).

http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html