Fix completion insight in JDeveloper 12.1.3: show return type again

Hi!

If you work with JDeveloper 12.1.3 you may missing the return type of methods in completion insight.

For an example you hit CTRL-SPACE after following code

completion_insigt_return_type_wrong

you see that at the start and at the end of the popup the available method names and parameter. If you have worked before with older versions of JDeveloper, you know that there is shown the return type of the method at the end. What a loose of (more...)

Cardinality Schätzungen für TEMP TABLE TRANSFORMATION

Randolf Geist hat vor einigen Wochen in zwei Artikeln weitere Details zum Verhalten der Cardinality-Schätzungen im Rahmen der TEMP TABLE TRANSFORMATION geliefert - in Ergänzung zu zwei (geringfügig) älteren Artikeln, die ich hier gelegentlich verlinkt habe und in denen vor allem darauf hingewiesen wurde, dass die Transformation nicht kostenbasiert ist, sondern automatisch angewendet wird (sofern die erforderlichen Voraussetzungen erfüllt sind), dass sie zu einer Materialisierung aller Spalten der CTE führt - und nicht nur der tatsächlich (more...)

ODCI dynamic table function parser

Supposing you've got data as a text string with "row" and "column" delimiters and you would like to parse out those columns and rows. The external table syntax would actually be great for this, but that requires writing the text out to a file first, and then you can import it back again as columns and rows.

There are various other alternatives using SQL and/or XML manipulations, but one method that I don't see much (more...)

Epoch

Note to self because it’s just one of those date/timezone-related topics which just doesn’t seem to stick…

Epoch/Unix time – See https://en.wikipedia.org/wiki/Unix_time

Unix time (also known as POSIX time or erroneously as Epoch time) is a system for describing instants in time, defined as the number of seconds that have elapsed since 00:00:00 Coordinated Universal Time (UTC), Thursday, 1 January 1970,

Firstly when converting from Oracle date or timestamp – we need to (more...)

DevCS / ADF Spotlight Event: Tuesday, June 30

Tue, Jun 30, 12:00 PM - 12:30 PM EDT

Online Webcast

 


ADF Spotlight Webcast Serie presents

 

Topic: Better Team Development with the Cloud
Speaker:  Dana Singleterry (Oracle Product Management)
Category: Was gibt es Neues

 

The Oracle Developer Cloud service provides a cloud-hosted platform for your development team to manage the full development lifecycle. In this session we'll show how you can simplify tracking requirements and bugs, efficiently manage code versions, streamline code (more...)

Leere Index-Blocks nach einem Rollback

Im OTN-Forum wurde vor einigen Tagen die Frage gestellt, wie es dazu kommen kann, dass ein Index nach einer abgebrochenen großen Update-Operation zahlreiche vollständig leere Blocks enthält. Dazu gab es im Forum ein paar kluge Antworten - und eine weniger kluge von mir, die zwar das gundsätzliche Problem benannte (nämlich die Tatsache, dass Index-Einträge nicht direkt gelöscht werden, sondern als gelöscht markiert), aber in der Erläuterung so unvollständig blieb, dass ich selbst nicht mehr sagen (more...)

KScope Day 2

I struggled a little bit this morning, for the first time in a few days the alarm woke be up with a start. I'm not sure my brain was ready. Kudos to those that tackled the 5k, I had the energy a few days ago...

Printing with node.js

Dimitri provided a great intro to help us all understand what node.js is all about and how to learn more, covering
- Installing node
- (more...)

KScope Day 1

Day 1? Really, is that all? There are so many things going on it feels like day 3.

And I'm not even participating in everything since I'm also coming back to do some family time each day.

Chi Gung

I gave this a go this morning after not being able to find Kent on the first day. It was interesting and there were some good exercises that everyone should consider doing in the morning, though (more...)

Listen to Kscope15 on Twitter

If you're at Kscope15 (even if you're not!), do you realise there is another set of conversations going on beyond the talks and beyond the between-session banter?

It's online of course, and it's on Twitter. It's live; it's interactive; and it's worth 'listening' to, if not contributing as well.

Visit this URL to read what's going on, even if you're not registered.
https://twitter.com/search?q=%23Kscope15
It might change your mind on registering for (yet (more...)

Escope very early status

Just a brief summary of the status of Escope so far - I know it's very very early and too early to even tell whether it'll become real or not, but anyway ... ;-)


  1. For those who don't know yet, we're trying to see if it is possible to create a conference in Europe like the Kscope conference by ODTUG. See my early thoughts here:
    http://dspsd.blogspot.com/2015/06/feasibility-survey-of-possible-european.html
  2. We're gathering feedback from as many European (more...)

KScope15 APEX Symposiums

Kscope15 officially kicked off on Sunday with a set of symposiums, I stayed in the APEX room the whole day, though I really wanted to hear what Steven Feuerstein had to say after lunch in the other room. I also hear a great discussion was had in the ADF room on tablet first vs mobile first.

APEX Episode 5 (A new frontier)

Joel Kallman kicked off the movie themed symposiums with a great talk about (more...)

Grundlagen des kostenbasierten Optimizers

Jonathan Lewis hat für AllThingsOracle eine neue Serie Basics of the Cost Based Optimizer gestartet und liefert damit vermutlich eine neue Standardreferenz zum Thema. Allerdings weist der Autor darauf hin, dass die Serie eher einführenden Charakter besitzt und nicht allzu sehr auf die technischen Details eingeht, weshalb ich meine Zusammenfassungen eher knapp zu halten gedenke:

How to make dream of Escope come true?

In my last post, I wrote about a dream of a European version of ODTUG Kscope conference - working title "Escope." ;-) We're trying to determine whether it would be feasible to create such a conference - if you haven't already, go and fill out the survey and help us find out if there's basis for the dream. And send the survey link to you colleagues and friends and network - the more (more...)

Do you want a Data Vault 2.0 Bootcamp in The Woodlands, Texas?

Survey time peeps! Simple Yes/No question: Would you like me to hold a DV 2.0 Bootcamp (and private certification) west of the Mississippi? If I set one up a in “America’s Hometown” (really it is even trademarked), The Woodlands, Texas (20 minutes north of Houston Bush Intercontinental Airport), would you come? Since I am an […]

Our Top 10 ODTUG #Kscope15 Sessions for Mobile / ADF/ Cloud / Forms Developers

It’s that time of year again; Kscope time, and I’m sure you are as excited as we are. You are most likely spending every moment of your free time reading the never-ending list of sessions tryinaurakscopeg to decide which ones to attend. Although there are over 300 to choose from, it’s time to bite the bullet and make decisions, because schedules must be made. To help you on your way, Mia, AuraPlayer’s CEO, has compiled a (more...)

Just found


now I need a floppy drive for 3,5"

:-)
Gerd

Typen des Dynamic Sampling Hint

Jonathan Lewis weist - erneut - darauf hin, dass der dynamic sampling Hint in zwei Versionen existiert: als cursor level Hint und als statement level Hint, und dass die Anzahl der gesampelten Blocks von der Version abhängt: Level 4 auf cursor level verwendet 64 Blocks als Sample - sofern bestimmte Voraussetzungen gegeben sind, während Level 4 auf table level 256 Blocks verwendet, und das unabhängig von weiteren Voraussetzungen. Deshalb plädiert der Autor dafür, den Typ (more...)

Oracle Cloud Platform Launch Event on Monday June 22 – Integrate, Accelerate and Lead with the Oracle Cloud Platform

On next Monday June 22nd, our executives will be unveiling the new Oracle Cloud Platform. We encourage all employees, customers and partners to attend. The details including registration are available here.

Surfs Up! #KScope15 Beach Club: Opening Soon!

I know this is last minute but wanted to remind everyone that the Annual ODTUG KScope event starts in less that a week! As always, I will be there with my ACE Director hat on (literally). I will be giving My Talks at KScope during the week. One on SQL Developer Data Modeler (SDDM), and […]

Installing Oracle XE, ORDS and Apex on CentOS – Part Two: Installation

This is part two in a series of blog posts about how to install Oracle 11g Express Edition (XE) with Oracle Application Express (Apex) on a CentOS Linux server, with Apex served by Oracle REST Data Services (ORDS) running on top of Tomcat and Apache.

Let's get right to it, starting with Oracle XE.

Installing Oracle XE

This is actually quite straightforward, assuming you have followed the prerequisite steps in part one.



As part of (more...)