How to Find the Row That Has the Maximum Value for a Column in Oracle

Complete IT Professional - Mon, 2016-07-25 06:00
Do you need to find the data for a row which has the maximum value for a specific column in Oracle? Learn how to do it and see some alternative answers in this article. The Table Structure Let’s say you have a table called sales_volume that looks like this: CITY START_DATE SALES El Paso 27/May/15 […]
Categories: Development

Oracle INITCAP Function with Examples

Complete IT Professional - Thu, 2016-07-21 06:00
The Oracle INITCAP function is a handy string manipulation function. Learn what it does and see some examples in this article. Purpose of the Oracle INITCAP Function The Oracle INITCAP function translates a specified string into another string which has the first letter of each word capitalised, and all other letters in lower case. The […]
Categories: Development

Oracle LOWER Function with Examples

Complete IT Professional - Wed, 2016-07-20 16:41
In this article, I’ll take a look at the Oracle LOWER function, explain how it works, and see some examples. Purpose of the Oracle LOWER Function The LOWER function converts all letters within the specified string to lower case.   Syntax The syntax for the Oracle LOWER function is: LOWER ( input_string )   Parameters […]
Categories: Development

Extending Oracle SaaS with Oracle Application Builder Cloud Service - Simplified PaaS for SaaS

Shay Shmeltzer - Tue, 2016-07-19 16:18

One of the focus area for us when developing the new Oracle Application Builder Cloud Service (ABCS) was to create a tool that would make it very simple to enrich Oracle SaaS applications.

This integration is a key part of Oracle's PaaS for SaaS offering - where we have unique capabilities in our Platform as a Service offering for our Software as a Service customers.

With ABCS it is very easy to pick up objects from Oracle SaaS (through the built in service catalog) and then design new web and mobile interfaces that show data from those.

In addition you can then add your own custom fields and related objects with additional data you want to track.

Once your application is complete - you can then either run it as a stand-alone app, or embed it into an Oracle SaaS interface. 

I wrote two blogs and recorded two videos that show you the basics.

Creating Oracle ABCS application connected to Oracle SaaS

Embedding Oracle Application Builder Cloud Service Apps in Oracle Sales Cloud

<span id="XinhaEditingPostion"></span>

These videos are part of the new Oracle Application Builder Cloud Service YouTube Channel

And the blogs are published on the Oracle Application Builder Cloud Service OTN Community

We have more tutorials there to help you go even further - so check them out! 

Categories: Development

How Can You Create A Column With AUTO_INCREMENT in Oracle SQL?

Complete IT Professional - Mon, 2016-07-18 06:00
If you’ve used MySQL, you’re probably familiar with the AUTO_INCREMENT feature. But it’s not available in Oracle. Read this article to find out how you can auto increment a column in Oracle SQL. What Is Auto Increment? An auto increment column, or an identity column in other databases, is a column that has its value […]
Categories: Development

Oracle RAWTOHEX Function with Examples

Complete IT Professional - Thu, 2016-07-14 06:00
The Oracle RAWTOHEX function is a simple conversion function. Learn how to use it and see some examples in this article. Purpose of the Oracle RAWTOHEX Function The purpose of the RAWTOHEX function is to convert from a RAW value into a hexadecimal value. As mentioned in the HEXTORAW function article, a RAW value is […]
Categories: Development

Continuous Integration for Database Developers - Updated

Shay Shmeltzer - Wed, 2016-07-13 17:25

About a year ago I posted a demo showing how to manage the full development lifecycle of your database code with the help of Developer Cloud Service. Since then we released new versions of both Developer Cloud Service and JDeveloper that make the experience even smoother and add more features - so I figured I'll record a small updated demo.

In this demo I'm starting from an existing project that has a list of tasks being tracked in a development sprint in the new Agile tab in Developer Cloud Service - which gives you a great view of your development effort and progress. 

(If you want to see how you create the initial project and add issues to it check out the previous demo). 

A few new things you'll see in this demo:

  • The new Agile/Sprint management dashboard in Developer Cloud Service
  • Task tracking integration in JDeveloper
  • Updating definition of database objects in JDeveloper and generating SQL scripts
  • Branching Git repositories
  • Code review for SQL files
  • Build automation for DB changes with Ant - including deployment to a cloud database

Note that in this video I'm using a cloud instance of an Oracle database where port 1521 is open for SQLNet communication. The instructions for opening this port for communication on an Oracle Cloud Database are here.

Another approach that you can take is to use scripts that execute commands using SSH on the Database Cloud Service - you can see this approach in action in this video showing Developer Cloud Service managing an Oracle APEX Lifecycle.  

The Ant script used in the sample is:

 <?xml version="1.0" encoding="UTF-8" ?>
<project xmlns="" default="init">
  <target name="init">
  <path id="antclasspath">
    <fileset dir=".">
      <include name="ojdbc7.jar"/>
  <target name="deploy">
    <sql driver="oracle.jdbc.OracleDriver" userid="C##xxxx" password="xxxx"
         url="" src="./database/DATABASE1/dbcreate.sql"
         classpathref="antclasspath" onerror="continue"/>

Note that you need the Oracle JDBC jar file to be accessible from the Ant script - I just included it in my git repository.

If you like to try this out with your own database development project - get a trial of Oracle Developer Cloud Service here

Categories: Development

How to Avoid The “ORA-00979 not a group by expression” Error

Complete IT Professional - Mon, 2016-07-11 06:00
Have you tried to run a query and got the “ORA-00979: not a group by expression” error? Learn what it is and how to resolve the error in this article. Generating the ORA-00979 Error This error can be generated when your run SELECT queries on your database. Here’s an example of a query that will […]
Categories: Development

Politicians won't move on climate change cause they know we don't REALLY care.

FeuerThoughts - Sun, 2016-07-10 10:23

Yep. That's the truth (at the least the truth that seems to be taking shape between my ears these days).

I've been thinking about the Great Pacific Garbage Patch of late....

Lots of us seem to know it exists, and we are disgusted by it. Disgusted by us - humans who are disastrously trashing our planet.

And what are we going to do about it?

We are going to demand that Congress DO SOMETHING!

And our demands are going to be expressed in extremely powerful ways:
  • Online petitions
  • Facebook rants
  • Lots and lots of outraged tweets
Oh yes. Those. Lots of them, lots of indignation, shared outrage, thank you Facebook Echo Chamber.

And yet, and yet...somehow those awful Congresspeople ignore the Will of the People. How can this be? 

Time for more outraged and indignant rants and sarcastic memes on Facebook.

How ridiculous on two fronts:

1. Online "activism" is largely ineffective. 

2. Politicians will only listen to us when we take action that demonstrates our seriousness.

And this is where we really fall short.

So you read about all the awful plastic clogging up our oceans, killing fish and whales and dolphins and....everything, really, just about everything.

And what do you actually do?

Do you change even one iota of the way you live your life? It doesn't seem that way to me. We bitch and moan for a while, and then watch Game of Thrones or go to Six Flags or buy another case of plastic bottled water.

And since we don't seem to be willing to make the smallest sacrifices in our lives, politicians know they can just keep on serving their real masters: lobbyists of corporations.

Let's face it: if you consume and discard plastic, it's going somewhere, and it's going to be nasty, no matter the location. 

But if you don't consume that plastic, you will have not contributed to the problem. You will have not made things worse. And if millions of people did this same thing - took action in their life to change patterns of consumption - the impact would be enormous.

Here are some of the things I do to avoid plastic consumption:

1. I never, never, NEVER (well, hardly ever) buy plastic bottled water. And I especially never buy cases of plastic bottled water that is wrapped in plastic. How grotesque. Instead, buy a glass or stainless steel bottle and refill the damn thing, people.

2. I hardly ever buy processed food. I mostly buy food, like broccoli and fruit and eggs. Sure, they all require some processing. But nothing like buying a Lunchable. So gross.

3. I travel with a set of bamboo "silverware" so I can avoid using plastic-wrapped plastic forks and knives. I so detest those.

4. When I get ice cream, I get a cone: no need for a plastic dish, no plastic spoon. Of course, if I go to a lovely ice cream shop like Oberweis and eat my delight there, they use glass bowls and glasses and real silverware. So then I will treat myself to a milkshake or sundae. Yummy and no plastic.

5. I make my own yogurt instead of buying lots of plastic containers of the stuff. It's easy to do: just buy one of these

6. I buy milk in reusable glass containers. Again, thanks Oberweis!

And there's more, but you get the idea. It mostly comes down to being more intentional about how you go through the day: think ahead, always carry your water bottle and bamboo silverware, just say no to treats that come in plastic that you do not really need to eat, etc.

If millions of humans took action like this, the amount of garbage going to landfills and into the ocean would decrease substantially. 

With reduced demand, less plastic would be produced in factories, less pollution would be produced, etc.

But if you do not do things like this, if you direct your outrage to distant politicians who will never pay you attention and do not address some of that outrage at yourself, well...

Then the coral and whales and sharks and fish and birds and eventually even (dare I say it!) humans will suffer. 

Bottom line: if you want politicians to change their behavior, first change yours

That way, when they still don't give a rat's ass about you, at least you will have helped make the planet a little bit healthier.

Multiple by a million or a billion, and maybe the coral will notice.
Categories: Development

Oracle HEXTORAW Function with Examples

Complete IT Professional - Thu, 2016-07-07 06:00
The Oracle HEXTORAW function is a basic conversion function used in Oracle SQL. Learn how to use it and see some examples in this article. Purpose of the Oracle HEXTORAW Function The purpose of the HEXTORAW function is to convert a hexadecimal value into a raw value.   Syntax The syntax for the Oracle HEXTORAW […]
Categories: Development

Getting Started with Oracle JET

Shay Shmeltzer - Wed, 2016-07-06 14:31

Last week I did an "Introduction to Oracle JET" session at the KScope16 conference, and I wanted to share the demo I used there with more people.

Specifically the demo shows how you can adopt the code from the Oracle JET cookbook samples to work in the quick start template project.

In this demo you'll learn how to create your first JET application and build a basic JET page.

Specifically it shows the following steps:


Hopefully this video can help you build your first Oracle JET page.

Now that you watched this video that shows how to use the pre-configured project provided as a quick start, you might want to follow up and watch the video that shows you how to work with the base distribution and hook up the JET libraries. 

Need more help with Oracle JET? Join the JET community on OTN

Categories: Development

What is the DUAL Table in Oracle?

Complete IT Professional - Mon, 2016-07-04 06:00
Have you seen SQL statements with the word DUAL in them? Wondering what it is? Find out what the dual table in Oracle is in this article. The DUAL Table in Oracle You might have seen some SQL statements with the keyword DUAL in them. These would have been SELECT statements, and the DUAL keyword […]
Categories: Development

Oracle SOUNDEX Function with Examples

Complete IT Professional - Thu, 2016-06-30 16:46
The Oracle SOUNDEX function is one of the most interesting functions I’ve used in Oracle. Learn what it is and how it works in this article. Purpose of the Oracle SOUNDEX Function The Oracle SOUNDEX function allows you to check what a value sounds like. It returns a value that represents the phonetic value of […]
Categories: Development

The Importance of Routine

Complete IT Professional - Tue, 2016-06-28 17:08
In the last two weeks, I’ve learnt about the importance of a routine. How does it relate to your career, and why should you care? The Last Two Weeks So, you might have noticed there hasn’t been a post on Complete IT Professional in the last week or so. I mentioned there was a delay […]
Categories: Development

Chicago Oracle Meetup

Gerger Consulting - Tue, 2016-06-28 09:00
Are you in Chicago? We have an Oracle Professionals Meet-Up on June 30. I'll be there and would be happy to get to know you. Register at:

See you there!
Yalim K. Gerger
Categories: Development

How are you?

FeuerThoughts - Tue, 2016-06-28 06:26
I get this question a lot.

You probably do, too.

Sometimes nothing more is meant by it than "Hello."

Sometimes they really mean it, they really want to know.

Generally, my answer is "Great!"

'Cause no matter what relatively small irritations I have in my life, the bottom line is that my life is quite wonderful.

But I've decided that perhaps I should not simply say "Great!" I should explain why my life is so great.

So here goes:


I am an organic life form living on the only planet we know of in the entire universe that supports organic life. How wonderful is that?

Plus, I am self-aware, so I know that I am alive and can appreciate rainbows and the sound of wind moving through trees, and so on.* How incredible is that?

And, best of all, I have two smart, beautiful, hilarious, stubborn and funny granddaughters.**

So how am I?


* Note: just in case that sentence sounds as though I am celebrating the uniqueness of human beings, I must clarify that I happen to believe that many, many living creatures from thousands of species are self-aware and appreciate the world around them. Birds, spiders, squirrels, "etc" ....

** Photos are, of course, required to back this up:

Loey Lucille Silva

Juna Josephine Silva

Categories: Development

Complaining about the weather

FeuerThoughts - Sun, 2016-06-26 09:16
Seems like I hear people complaining about the weather a lot.

Too hot, too cold, too wet, too dry....

Seems to me that we should never complain about the weather. I refuse to complain about the weather. Why would I take this position?

So far there is just one planet that we know about in the universe that supports the kind of life we are: organic, carbon-based life.

"Weather" cannot be separated from this planet. So when you complain about the weather, you are complaining about the only place in the universe humans can even possibly, remotely live. 

Seems a bit mean spirited, from that perspective, to whine about rain (which is needed badly for us and trees and lots of other living things to survive).

Beyond all that, humans have spread across the entire planet, even (and often) to places that are hostile to human survival (places, in other words, that we did not evolve to live in).

In order to live in many of these places, we destroy chunks of those places to make them more hospitable, comfortable and convenient for us.

So it seems to me that when someone complains about the weather, we should ask:

Do you live in a location on Planet Earth that does not require the establishment of a "human survival zone"?

Indicators of Human Survival Zones: air conditioning so your brain doesn't fry; heat so that you don't turn into an ice cube; homes that seal you off completely from your surroundings....

If yes, then our response should be:
Wow! Aren't you lucky? You can breathe, you can drink water, you can eat the food, you can enjoy the natural environment with minimal degradation of that environment, and without dying. Why would you ever complain about the weather?
If no, the our response should be: 
You have no right to complain. You shouldn't even be here. You can only be here by radically changing (usually by destroying) the world around you. Which, by the way, affects the weather. If you don't like it here, then leave. But don't complain.And if none of that seems to be making a dent, you can always fall back on the Rainbow Argument:
How can you complain about the weather (and by extention a planet) that gives you rainbows? 
Categories: Development

[EM-01901] Internal error in EM Patch Advisor for Patchng using EM12cR5

Arun Bavera - Mon, 2016-06-20 23:33

I am trying to patch the DB ( APR2016_PSU ) on OEL 6 with Patch 20807398 from Note:2034610.1 using EM12cR5.

OMS side Patches

Agent Side Patches

OMS PSU APR Patch: 22570344
OMS System Side Bundle Patch: 23218275
Patch: BUG:21364690

Agent-Side (May 31, 2016) Patch 23124338
Agent-Side Monitoring 31, 2016) Patch 23217639
* Agent-Side Discovery (November 30, 2015) Patch 22135601

I get the below error, which is pointing to OMS HOME, I am analyzing Patch 20807398 on a DB Home!


EMlogs shows following exception:

2016-06-21 02:21:29,930 [RJob Step 115760] FATAL patch.InitSADB logp.251 - [EM-01901] Internal error in EM Patch Advisor

java.lang.NumberFormatException: For input string: "6000000000093016041902"

at java.lang.NumberFormatException.forInputString(

at java.lang.Long.parseLong(

at java.lang.Long.valueOf(

I have reviewed these notes:

ERROR: CHK-012: An Unexpected Exception Occurred when Patching Database (Doc ID 1951435.1)

EM 12c: Enterprise Manager 12c Cloud Control Patch Plan Fails when Checking Target Properties with Error: [EM-01901] Internal error in EM Patch A (Doc ID 1946028.1)


Download the patch manually to SoftwareLibrary , seems like this issue is with downloading patch automatically from EM.

Categories: Development

APEX UT - Display Image in a List

Denes Kubicek - Mon, 2016-06-20 07:34
If using universal theme, we can switch from a classic navigation bar to a list and display it where usually a navigation bar is displayes - right top of the page. The problem with the list is that it will escape any html code in the list name. If we want to display an image, we will get the html code. To go arround that problem, we can use the "user defined attributes" for the lists and put the image into the "Badge Value". This list will then display the image almost as expected. We will need to apply additional css to make the background of the "Badge Value" transparent and to adjust the font to the rest of the navigation bar list:

.t-Button--navBar .t-Button-badge {background-color: transparent !important; font-weight: 400 !important; font-size: 1.2rem !important}

This is then how it appears:

Here, we can add the "Badge Value":

Finaly, here we can change our navigation bar from classic to list or oposite:

Categories: Development

NoSQL for Oracle Developers

Gerger Consulting - Fri, 2016-06-17 07:16
Oracle Developers! Want to learn more about NoSQL, but don't know where to start? Look no further.

Attend our free webinar by the venerable Pramod Sadalage. He'll answer all the questions you have about NoSQL but were too afraid to ask. :-) 

After all, he wrote the book.

 Sign up at this link. 
Categories: Development


Subscribe to Oracle FAQ aggregator - Development