Development

Oracle VAR_POP Function with Examples

Complete IT Professional - Fri, 2017-01-20 05:00
This article will explain the Oracle VAR_POP function and show you some examples. Purpose of the Oracle VAR_POP Function The VAR_POP function finds the population variance of a set of numbers, excluding NULLs. What does this mean? The population variance is a calculation that determines the difference or variation in a complete set of numbers. […]
Categories: Development

Weekly Link Roundup – Jan 20, 2017

Complete IT Professional - Thu, 2017-01-19 18:02
Here’s my weekly link roundup for Jan 20, 2017. What Is This Link Roundup? A “link roundup” is a type of post on a website where the author collates a list of articles they have read recently, and adds them all into a single post. The aim is to make the readers of the site […]
Categories: Development

Oracle VAR_SAMP Function with Examples

Complete IT Professional - Thu, 2017-01-19 05:00
In this article, I’ll explain the Oracle VAR_SAMP function and show you some examples. Purpose of the Oracle VAR_SAMP Function The VAR_POP function will return the sample variance of a set of numbers, after excluding NULLs. What does this mean? The sample variation calculates the variation of a sample of numbers from the overall set. […]
Categories: Development

Extending Oracle HCM with Oracle Application Builder Cloud Service - It's Simple

Shay Shmeltzer - Wed, 2017-01-18 13:37

I blogged before showing how easy it is to extend Oracle Sales Cloud using Oracle Application Builder Cloud Service.

We do get a lot of customers of Oracle HCM that approach us asking if they can use the same tools to extend Oracle HCM apps. While Oracle Application Builder Cloud Service (ABCS) has the list of Oracle Sales Cloud services pre-populated in the service catalog , you can pretty easily connect ABCS to Oracle HCM services too and get data and build an application around this data.

In the video demo below I'm building an application that records the details of the cars employees are allowed to bring onto campus. I leverage a REST service exposed by Oracle HCM to get the list of employees. ABCS also automates querying using the same service so you can search for a specific employee.

ABCS lets me create an app with the same look and feel as Oracle SaaS displaying the specific fields that interest me in the specific layout I want. Further more I can add custom data object that tracks the details of the cars and associate it with the HCM data.

HCM App

Note that in the security section I'm using basic security with a fixed user for the sake of simplicity in the demo. Note however that in the selection list I can also use the currently logged in Oracle Cloud user - to synch the user of my ABCS and their HCM authorization.

HCM Security Setting

Check it out:

Want to try it on your own - get a trial account of Oracle Application Builder Cloud Service here

Categories: Development

Extending Oracle HCM with Oracle Application Builder Cloud Service - It's Simple

Shay Shmeltzer - Wed, 2017-01-18 13:37

I blogged before showing how easy it is to extend Oracle Sales Cloud using Oracle Application Builder Cloud Service.

We do get a lot of customers of Oracle HCM that approach us asking if they can use the same tools to extend Oracle HCM apps. While Oracle Application Builder Cloud Service (ABCS) has the list of Oracle Sales Cloud services pre-populated in the service catalog , you can pretty easily connect ABCS to Oracle HCM services too and get data and build an application around this data.

In the video demo below I'm building an application that records the details of the cars employees are allowed to bring onto campus. I leverage a REST service exposed by Oracle HCM to get the list of employees. ABCS also automates querying using the same service so you can search for a specific employee.

ABCS lets me create an app with the same look and feel as Oracle SaaS displaying the specific fields that interest me in the specific layout I want. Further more I can add custom data object that tracks the details of the cars and associate it with the HCM data.

HCM App

Note that in the security section I'm using basic security with a fixed user for the sake of simplicity in the demo. Note however that in the selection list I can also use the currently logged in Oracle Cloud user - to synch the user of my ABCS and their HCM authorization.

HCM Security Setting

Check it out:

Want to try it on your own - get a trial account of Oracle Application Builder Cloud Service here

Categories: Development

Demo: Version Control for PL/SQL in 30 Minutes

Gerger Consulting - Mon, 2017-01-16 12:38
Hi Everyone! We prepared a 30 minute demo video to show you how Gitora can help you manage your PL/SQL code base. Check it out below:

Categories: Development

What’s The Difference Between Oracle ROWNUM vs Oracle ROW_NUMBER?

Complete IT Professional - Mon, 2017-01-16 05:00
Have you seen ROWNUM and ROW_NUMBER in Oracle and wondered what the difference is? Learn what they are and the differences between Oracle ROWNUM vs Oracle ROW_NUMBER in this article. What Is Oracle ROWNUM? You might think that ROWNUM is a function in Oracle. However, it’s not a function. It’s a “pseudocolumn”. It acts like […]
Categories: Development

APEX 5.1 New Features

Denes Kubicek - Mon, 2017-01-16 01:57
APEX 5.1 ist endlich da. Oracle Application Express wird mit jedem Release besser und zieht immer mehr Entwickler weltweit in seinen Bann. Es ist einfach, einfache wie auch komplexe Applikationen auf Basis des Oracle Stacks zu entwickeln. Es macht sogar richtig Spaß !

Mit APEX 5.1 sind als wichtiges neues Feature die Interactive Grids mit dazu gekommen. Wir haben sehr lange auf eine moderne Möglichkeit gewartet, Excel - ähnliche Funktionen auf einer Webseite mit APEX zu implementieren. Jetzt ist es endlich soweit :) . Sogar Master-Detail-Detail-Detail-... Beziehungen sind umsetzbar, unsere Anwender werden sich freuen.

Darüber hinaus gibt es auch in vielen anderen Bereichen wichtige Neuerungen, die uns das Leben erleichtern. Gleichzeitig sind aber auch einige wichtige Dinge zu beachten, damit wir ein reibungsloses Upgrade durchführen können.

In diesem Kurs lernen Sie die neuen Funktionalitäten von Oracle Application Express 5.1 kennen, insbesondere wie Sie diese erfolgreich in der Praxis einsetzen.

Lernen Sie von und diskutieren Sie mit den weltweit bekannten Oracle APEX Experten:

Denes Kubicek, langjährige Projekterfahrung in den Bereichen Oracle und APEX mit multisite Applikationen, Preisträger des "Oracle APEX Developer of the Year 2008" Awards des Oracle Magazines, ein Oracle ACE Director und sehr bekannt im Oracle APEX OTN Forum für seine Beispielapplikation und

Dietmar Aust, erfahrener Oracle Consultant mit Spezialisierung auf Oracle APEX, Oracle ACE und aktiv in den OTN Foren zu APEX und Oracle XE, mit regelmäßigen Präsentationen auf den einschlägigen Oracle Konferenzen (DOAG, ODTUG, Oracle Open World).



Categories: Development

Announcing “Database Star Academy”

Complete IT Professional - Fri, 2017-01-13 20:03
All of the online courses I have created used to be on a separate site of mine called Software Developer Academy. These have now all been moved to a new section under my main site, called Database Star Academy. Read on to find out more. What Is Database Star Academy? It’s the name of a membership section on […]
Categories: Development

Oracle TO_MULTI_BYTE Function with Examples

Complete IT Professional - Fri, 2017-01-13 05:00
In this article, I’ll be covering the Oracle TO_MULTI_BYTE function, and look at some examples. Purpose of the Oracle TO_MULTI_BYTE Function The TO_MULTI_BYTE function is used to convert a character string from single-byte characters to multi-byte characters. Your database must contain both single-byte and multi-byte characters for this function to be useful. If there are […]
Categories: Development

Oracle COVAR_POP Function with Examples

Complete IT Professional - Thu, 2017-01-12 05:00
In this article, I’ll explain what the COVAR_POP function does and show you some examples. Purpose of the Oracle COVAR_POP Function The Oracle COVAR_POP function calculates the population covariance of a set of number pairs. What is a “population covariance”? Good question. Here’s an article that explains what the definition is. Just like the COVAR_SAMP […]
Categories: Development

My first blog post with classeur.io

Dimitri Gielis - Mon, 2017-01-09 18:18

I’m trying to write this blog post with classeur.io.

Just like Martin I’m also searching for alternative ways to write blog posts. I don’t want to completely migrate my blog to a new platform, so I’m searching for a way to write in Markdown and deploy to Blogger.

Why Markdown?
Since our development of APEX Office Print (AOP) we also use Markdown for our documentation as it makes including code samples easier, it can be version controlled and overall it’s pleasant to write in. Whenever we deploy a new version, we publish the markdown as HTML. For example you see the result of our documentation here. SSjj… we like Markdown so much that we are even looking into supporting Markdown to write your template in AOP, next to Word, Excel and Powerpoint, but more on that in the February timeframe. :)

So I’m giving classeur.io a try, it’s just another Markdown editor, but it can publish directly to Blogger. It allows me to include code samples like this:

declare
l varchar2(100);
begin
l := 'hello world';
sys.htp.p(l);
end;

Or if I want to reference somebody I can use a quote:

Oracle Application Express (APEX) changed my life. – Dimitri Gielis

And a list … for example the top 3 reasons I’m looking at a different way to blog:

  1. Faster to write a post
  2. Reuse my writings in different ways
  3. Easier to share code

So this post is really to try the different options of classeur.io which should show up in Blogger after I hit the publish button.

Here’s an image which I plan to use in my next post:
enter image description here

If you see this and the post looks ok, my test went well :)

Categories: Development

What are the Differences Between a Primary Key vs Foreign Key?

Complete IT Professional - Mon, 2017-01-09 05:00
I explain what a primary key and foreign key is, as well as the differences between primary key vs foreign key in this article. What Is a Primary Key? What is the primary key definition?  A primary key is one or more columns in a table that are used to uniquely identify the row. When […]
Categories: Development

Oracle COVAR_SAMP Function with Examples

Complete IT Professional - Fri, 2017-01-06 05:00
In this article, I’ll explain what the Oracle COVAR_SAMP function does and show you some examples. Purpose of the Oracle COVAR_SAMP Function This function returns the covariance of a set of number pairs. What does that mean? Here’s an explanation of what a covariance is. This function, like the CORR and COVAR_POP function, can be run […]
Categories: Development

Oracle VSIZE Function with Examples

Complete IT Professional - Thu, 2017-01-05 05:00
In this article, I’ll explain what the Oracle VSIZE function does and show you some examples. Purpose of the Oracle VSIZE Function The VSIZE function returns the number of bytes of an expression using the internal representation. That sounds a lot like the LENGTH function, doesn’t it? I’ll explain the differences shortly after we cover […]
Categories: Development

PostgreSQL for Oracle Developers and DBA's

Gerger Consulting - Tue, 2017-01-03 16:16
PostgreSQL is not very well known among Oracle developers and DBA’s. Yet, the skill set of an Oracle developer or a DBA is easily portable to PostgreSQL.
There is no one better than Joshua D. Drake to teach you PostgreSQL and show you how you can migrate from Oracle to PostgreSQL.
Attend Joshua's free webinar and earn how you can benefit from PostgreSQL, the leading free and open source alternative to the Oracle Database.

About The Presenter:

Joshua D. Drake is an Open Source Consultant specializing in Linux and PostgreSQL. He has been consulting on PostgreSQL since 1996. Throughout his PostgreSQL career he has performed a variety of functions within the community including submitting a patch or two, releasing an O'Reilly book on PostgreSQL as well as being part of the sysadmins and advocacy teams. Further he ran a biannual conference series dedicated to PostgreSQL between the years of 2007 - 2011. He is former Director (2008-2016) for SPI (the non-profit for PostgreSQL.org). He is also a Founder, and current Director of United States PostgreSQL. Lastly, he is a core member of PgConf US.

About The Webinar:

Even if your organization is an Oracle customer. there are many use cases where PostgreSQL can be an affordable alternative to the Oracle Database. In this webinar, Joshua will discuss the in and outs, ups and downs of migrating from Oracle to PostgreSQL.

The presentation will include PostgreSQL differences, limitations and discussion of commercial needs such as custom features and support.

Attendees should plan on walking away with a comprehensive understanding of the differences of the two products and how to make PostgreSQL work best for their projects.

The webinar is free but space is limited.

Categories: Development

Singular vs Plural and Other Database Table Naming Conventions

Complete IT Professional - Mon, 2017-01-02 05:00
Are you wondering if you should name your Oracle database tables in the singular form or plural form? Learn what the preferred convention is and some reasoning behind it, as well as other database table naming conventions, in this article. Why Do We Need SQL Table Naming Conventions? You might be wondering why we need conventions or […]
Categories: Development

Oracle INSTRB, INSTRC, INSTR2, and INSTR4 Function with Examples

Complete IT Professional - Fri, 2016-12-30 05:00
In this article, I’ll explain what all of the variations of the INSTR function (INSTRB, INSTRC, INSTR2 and INSTR4) do, and show you some examples Purpose of the Oracle INSTR2, INSTR4, INSTRB, and INSTRC Functions These INSTR functions are variations of the basic INSTR function, which searches inside a string for a substring, and returns […]
Categories: Development

Oracle LENGTH2, LENGTH4, LENGTHB, and LENGTHC Function with Examples

Complete IT Professional - Thu, 2016-12-29 05:00
In this article, we’ll look at the variations of the Oracle LENGTH function – LENGTH2, LENGTH4, LENGTHB, and LENGTHC. Purpose of the Oracle LENGTH2, LENGTH4, LENGTHB, and LENGTHC Function The purpose of these LENGTH function variants is the same as the basic LENGTH function – to find the length of a specified string. However, the […]
Categories: Development

Success Story: Version Control for PL/SQL

Gerger Consulting - Mon, 2016-12-26 15:43
It’s been a little over three months since we released Gitora 2.0 and the first success stories have started to emerge. Here is one of them:


Rhenus Logistics, the leading logistics company from Germany uses Gitora to manage their Oracle Database.
Problem
Rhenus IT uses both Java and PL/SQL to serve their users and customers. They have a team of about 10 PL/SQL developers. The team manages more than 20,000 database packages, views, functions, procedures, object types and triggers spread over 30+ database schemas.
Rhenus IT wanted to move to a continuous delivery environment in which they can be more agile and deliver solutions to the business faster. Managing the PL/SQL code was the hardest piece of the puzzle.
Solution
After experimenting with other solutions in the market, Rhenus decided to move forward with Gitora.


Gitora enabled Rhenus Developers to:
  • Use Git, the prominent open source version control system used by millions of developers.
  • Move their database code between development and various staging databases automatically.
  • Move code between source and target databases very fast because Gitora only executes differences between source and target databases, without comparing the code bases in both databases first (which can be very time consuming).
  • Enforce check-in, check-out of database objects at the database level.
  • Automate build process for the database code using Gitora API’s.
  • Implement an affordable continuous delivery solution compared to alternatives.
Michiel Arentsen, the System Architect at Rhenus who implemented the solution at Rhenus has started an excellent blog in which he writes about his Gitora implementation. We highly recommend you to check it out. Below are the list of blog posts he wrote which should be very useful to anyone who is currently implementing Gitora at his/her company:
Categories: Development

Pages

Subscribe to Oracle FAQ aggregator - Development