Version Control for PL/SQL

Gerger Consulting - Mon, 2016-11-14 15:47
We are hosting a free webinar to talk about how to manage PL/SQL code bases. Attend and learn how you can use Gitora, our new product that links Oracle Database to Git, to manage your PL/SQL source code.

170+ people have already signed up! :-) Register at this link.

Categories: Development

12 Tips for Finding an IT Job on Twitter

Complete IT Professional - Mon, 2016-11-14 05:00
Twitter is one of the most important and most popular social networking sites. It can also be used for finding a job in the IT industry. As of 2016, Twitter has: 310 million monthly active users Average of 500 million tweets per day One great way you can use Twitter is to find a job […]
Categories: Development

50 Awesome Career Tips For IT Professionals

Complete IT Professional - Sun, 2016-11-13 21:00
The IT industry is a large field, and as a result, it can be hard to stand out from the rest of the people in the industry. There are some things you can do to improve your career, improve the way you do work, and make yourself look better for your company. Have a read […]
Categories: Development

Oracle CHARTOROWID Function with Examples

Complete IT Professional - Thu, 2016-11-10 12:11
In this article, I’ll explain what the Oracle CHARTOROWID function is and show you an example. Purpose of the Oracle CHARTOROWID Function The purpose of the CHARTOROWID function is to convert a value from a several character data types into a ROWID data type. The supported data types that this function can convert are: CHAR […]
Categories: Development

The Complete Guide to the Oracle INSERT INTO Statement

Complete IT Professional - Mon, 2016-11-07 05:00
The Oracle INSERT INTO statement is one of the most popular commands in Oracle, and it’s one of the first commands you learn to use. Read how to insert data and how to use the full functionality of the INSERT statement in this guide. What Is the INSERT INTO Oracle Statement? The Oracle INSERT INTO […]
Categories: Development

Oracle ASIN, ACOS, ATAN, ATAN2, and COSH Functions

Complete IT Professional - Thu, 2016-11-03 06:00
In this article, I’ll explain how to use the Oracle ASIN, ACOS, ATAN, ATAN2, and COSH functions with some examples. I’ve grouped all of these functions into a single article because they are quite similar and are related functions. Purpose of the Oracle ASIN, ACOS, ATAN, ATAN2, and COSH Functions The purpose of these functions […]
Categories: Development

How To Create a Pivot Table Structure in SQL

Complete IT Professional - Mon, 2016-10-31 06:00
As part of my web app, I needed to create a pivot-table style output for my reports. I’ll explain what the requirements were and what my solution was in this article. What Did I Need To Do? For the web app, I needed to output a table of data. This table needed to display row […]
Categories: Development

Oracle GROUP_ID Function with Examples

Complete IT Professional - Thu, 2016-10-27 06:00
In this article, I explain what the GROUP_ID function does and show you some examples. Purpose of the Oracle GROUP_ID Function The GROUP_ID function is used to assign a number to each group that results from a SELECT query clause with a GROUP BY clause. It’s used to identify any duplicate groups in your output, […]
Categories: Development

A Guide to the Oracle Data Types

Complete IT Professional - Mon, 2016-10-24 06:00
In this article, I explain what the different data types are in Oracle database and everything you need to know about them. What You’ll Learn about Oracle SQL Data Types There are many data types in the Oracle database. There are character, number, date, and other data types. When you create a table, you need to […]
Categories: Development

Creating Oracle Application Builder Cloud Service App Based on Oracle ADF Business Components

Shay Shmeltzer - Thu, 2016-10-20 11:29

Oracle Application Builder Cloud Service (ABCS for short) enables you (and your business users) to create rich web and mobile apps in a quick visual way from a browser with no-coding required (but coding is possible).

The UI that ABCS creates is based on Oracle JET, which many of our customers love because its responsiveness and lightness.

Some Oracle ADF customers have been on the hunt for a new client-side UI solution for their apps, and Oracle JET is certainly a technology that will work for those use cases.

A nice feature for Oracle ADF customers is that their data-access and business-service layer is built in a reusable way that is decoupled from the UI. And now, with the ability to expose ADF Business Components as REST service, they can use any modern UI framework to develop the UI including Oracle JET. There are already many blog entries with code samples on how to write JET apps that connect to ADF Business Components

But what if we could give you the simplicity of ABCS for the UI creation, the power of JET for the UI experience, and the ability to leverage your existing investment in Oracle ADF all without writing a single line of code manually?

Well, in the demo below I'll show you how you can reuse the logic you have in Oracle ADF Business Component and build a JET based UI on top of them in a declarative way with Oracle Application Builder Cloud Service.

Basically you get the best of each tool - and you don't need to write a single line of code !


In the 9 minutes demo I'll show you how to:

  • Create an ADF Business Components layer on top of Oracle Database in the Cloud - (0:00)
  • Expose the ADF Business Components as REST service - (1:45)
  • Deploy the REST service to Java Cloud Service (JCS) - (2:19)
  • Create an Oracle Application Builder Cloud Service application - (6:00)
  • Add an ADF BC REST Service as a data source to the app - (6:30)
  • Create the user interface to your application - (7:20)

(Times are indicated in case you want to skip sections you are already familiar with) 

If you are interested in a bit of a background on why this is so simple, the answer is that ABCS was built to enable easy integration with Oracle SaaS leveraging the REST services they expose. To quickly build the full app with all the defaulting you are seeing in there (full CRUD with a simple drag and drop) ABCS needs to know some basic information about the data that it needs to render (primary key, data types, etc). Since Oracle SaaS is built on Oracle ADF, we built into ABCS the capability to analyze the describe that ADF BC REST services provide. This makes it dead simple to consume ADF REST service in ABCS, whether these services come from Oracle's apps - or your own ADF apps :-) 

As you can see there is a great synergy between Oracle ADF, Oracle Application Builder Cloud Service and Oracle JET. 

Want to try it on your own? Get a trial of Oracle Application Builder Cloud Service here

Categories: Development

Oracle EMPTY_CLOB Function with Examples

Complete IT Professional - Thu, 2016-10-20 06:00
In this article, I’ll explain what the EMPTY_CLOB function does and show you an example of how to use it. Purpose of the Oracle EMPTY_CLOB Function The EMPTY_CLOB function is used to initalise a CLOB column to EMPTY. It can be used in several places: In an INSERT statement In an UPDATE statement Initialising a […]
Categories: Development

Why I Moved from CompleteITProfessional to DatabaseStar

Complete IT Professional - Sun, 2016-10-16 13:26
Complete IT Professional has been renamed and rebranded to Database Star. I’ll explain what that means and why I made this change in this article. What Was The Change? You’re probably reading this on the new website, wondering why you’re here instead of on Well, the reason is that I have decided to […]
Categories: Development

List with Details on a Single Page in Oracle Application Builder Cloud Service

Shay Shmeltzer - Thu, 2016-10-13 11:11

This question came up a couple of times from users so I figured I'll document how to achieve a layout that shows a list of items and allows you to pick an item from this list to show the details of this item on the same page.

list with details image

The default layout that ABCS creates is a list on one page with the ability to select an item and go see the details or edit that record on another page.

To combine the two into a single page, start from the edit or the details page that ABCS created.

On this page you then add the table or list for the same object, and set the link on a field to do the edit or details - this basically means that you'll do a navigation to the same page.

If you now run the page you'll be able click items in the table and see their details on the same page.

Here is a quick demo of how it is done:

Note that if you want this to be the default view that people see when navigating to your app - just update the navigation menu of your application to reflect this. 

Categories: Development

OTN Appreciation Day : APEX

Dimitri Gielis - Tue, 2016-10-11 15:39
If you're following some Oracle blogs or Twitter, you'll see many blog posts starting with "OTN Appreciation Day : " today. You can read the story behind this initiative on Tim Hall's blog. "The blog post content should be short, focusing more on why you like the feature, rather than technical content."
In my life Oracle played (and is still playing) an important role... and it all started because I love working with data - which lead me to the Oracle database, the *best* database in the world.

So I just have to write about a feature of the Oracle Database; but which one to pick? The way Oracle implemented SQL, or the programming language inside the database PL/SQL or the tools and options that make the database awesome?... I thought some time about it and for me personally next to the database itself, it was really APEX that changed my life, so I just have to write about it.

In this post I want to share why I love Oracle Application Express (APEX) and why I consider this the best feature of the Oracle Database *ever*.

The goal, I believe, of a database is to capture data and do something with it; either to get insight in your data or share it again in different formats with others... and Oracle Application Express is just the easiest way to do this! In no time you create a web application with some forms that capture data directly in your database. And in even less time you share and get insight in your data through beautiful reports and charts. You just need a browser... it's secure, fast, scalable and you can use the full power and features of the database - APEX is the window to your data!

Categories: Development

OTN Appreciation Day: Easy Execution Plans

Complete IT Professional - Tue, 2016-10-11 13:54
As part of the #ThanksOTN idea on Twitter, my favourite Oracle feature is the ability to easily view and analyse execution plans for queries. Time and time again I’ve needed to see how a query is running, and Oracle databases make it easy to view the execution plan. You can view it in either a text format […]
Categories: Development

Automatic Time-Based Dismiss for Oracle ADF Popups

Shay Shmeltzer - Mon, 2016-10-10 11:09

This blog entry is about a nice little new feature that was introduced into ADF in the version, and didn't get a mention in the "what's new" document.

Self dismissing messages  are popping up everywhere these days (when you get an email, when you have a new calendar invite etc), and you might want to use this UI pattern in your ADF apps too.

There is a new property for af:popup components - autoDismissalTimeout - that allow popups to automatically dismiss after a certain number of seconds that you can specify. This is very useful for all sort of messages that you want to show to the user, but you don't want to require the user to do any activity to dismiss.

Here is an example of such a message that you can associate with a save button:

popup sample

And here is the code you'll need to do this:

            <af:popup id="p1" animate="true" autoDismissalTimeout="2">

                <af:panelGroupLayout id="pgl1" layout="horizontal">

                    <af:image source="stat_confirm_16.png" id="i1"/>

                    <af:outputFormatted value="Your changes have been saved" id="of1"/>



One more (small) reason to adopt the new versions of Oracle ADF! 

Categories: Development

4 Things To Spend Money On for Work

Complete IT Professional - Mon, 2016-10-10 06:00
There are many things that your workplace will provide as part of your employment. Notebooks, pens, computer, and a chair. There are some other things that, if you spend money on, they can really improve the quality and efficiency of your work. 1 – A Decent Pen Every office I’ve worked in has had a […]
Categories: Development

Oracle EMPTY_BLOB Function with Examples

Complete IT Professional - Thu, 2016-10-06 06:00
In this article, I’ll explain what the Oracle EMPTY_BLOB function does and show you an example of how to use it. Purpose of the Oracle EMPTY_BLOB Function The EMPTY_BLOB function is used to initalise a LOB column to EMPTY. It can be used in several places: In an INSERT statement In an UPDATE statement Initialising […]
Categories: Development

Overview of Oracle Character Sets

Complete IT Professional - Mon, 2016-10-03 06:00
I’ve been working with databases for a long time, and the topic of character sets took me a while to understand. This article will answer some of the common questions, and questions I had about Oracle character sets and how they relate to the Oracle database. What is a Character Set? As defined by Webopedia: […]
Categories: Development

Oracle TO_SINGLE_BYTE Function with Examples

Complete IT Professional - Thu, 2016-09-29 06:00
The Oracle TO_SINGLE_BYTE function is useful for databases with different character sets. Learn how to use it and see some examples in this article. Purpose of the Oracle TO_SINGLE_BYTE Function The purpose of the TO_SINGLE_BYTE function is to convert a string with multi-byte characters into single-byte characters. To use this function, your database character set needs […]
Categories: Development


Subscribe to Oracle FAQ aggregator - Development