kasom

195 Flips | 5 Magazines | 6 Likes | 121 Followers | @kasom | Keep up with kasom on Flipboard, a place to see the stories, photos, and updates that matter to you. Flipboard creates a personalized magazine full of everything, from world news to life’s great moments. Download Flipboard for free and search for “kasom”

Session using a database link hangs on “SQL*Net more data from dblink”

I have a client who recently move a database server from on-premise to a Cloud provider. A database on this database server had a database link to …

Consuming a REST Web Service returning JSON in APEX

In APEX you can define a web service that returns XML as below - all declarative, just a few steps through a wizard.<br>Then generate a report on top of …

Authenticate APEX via Token

This requirement pops up every now and then, time to put it in a blogpost so I can find it myself again when needed :-)In various integration …

Software Engineering

Webserver Logfile Analysis with Oracle APEX

Recently I wanted to set up better monitoring for our several FOEX webservers and decided not to use an off-the-shelf solution, since I wanted to …

The Performance of the FIRST and LAST Functions - @DBoriented

Overview<p>One of the first posts I wrote in this blog (almost five years ago) was about the FIRST and LAST aggregate functions.<br>These functions are, in …

Control file recovery - ORACLE-HELP

Today we are going to have look at the backbone of an Oracle Database. Being DBA we all are most aware of the recovery of the controlfile . It is the …

Undo Segment is in Needs Recovery - ORACLE-HELP

Whenever we face any DBA interviews we have to go through some intersting topics interviewers ask. Undo Management is the most important part of …

APEX 18.1 Early Adopter 2: REST Services and PL/SQL

When Application Express 5.2 Early Adopter 1 release came out, the new REST service support was introduced with two blog postings:<p>Based on the first …

Oracle APEX and 12.2 upgrade

<b>Oracle APEX 5.1.x and Oracle 12.2 upgrade</b><p><b></b><p><b>Doc ID 2339601.1 apex_web_service issue</b><p>Oracle 12.2 multiple domain certificates issue<p>This is something to be …

HOW TO CONVERT SCN TO DATE AND DATE INTO SCN - ORACLE-HELP

SQL>select current_scn from v$database; 7705798324 SQL> select timestamp_to_scn(to_timestamp('24/09/2012 14:24:54','DD/MM/YYYY HH24:MI:SS')) as scn …

Databases

Oracle Week 2017: Docker Concepts for Oracle/MySQL DBAs and DevOps (slides)

How we use cookies<p>We may request cookies to be set on your device. We use cookies to let us know when you visit our websites, how you interact with …

Google Analytics

Blockchain with Oracle and APEX

Thus the whole IT world talks about blockchains, the bitcoin price is as high as never (which underlying technology is a blockchain mechanism) and …

APEX Plugin: Password Strength Estimator

Home APEX APEX Plugin: Password Strength Estimator<p>I needed a simple password strength prompt for users when they need to create or change their …

How to obtain the Database Total Used, Allocated and Max Size

From time to time, it’s useful to know the total allocated size of a database at OS level, how much of it has been used and what the maximum total …

Build the Oracle APEX application: the framework

Over the years while developing Oracle APEX application, I noticed in every application I was following the same steps. It was a routine I followed …

Oracle REST Data Services and Docker

TL;DR 1) check out https://github.com/krisrice/docker-ords-sqlcl-apex 2) Download ORDS , SQLcl; optionally APEX 3) Build w/DB connection details …

Index compression–quick tip

If you’re appropriately licensed and want to use advanced index compression, you can take advantage of the setting a tablespace to automatically add …

Databases

excel2collection functionality of ORDS will not work with APEX 5.1 or later

If you're using the functionality of Oracle REST Data Services (ORDS) with Oracle Application Express to parse a Microsoft Excel file and store the …

Correlating APEX Sessions to Database Sessions

I received the following question via email today:<i><br>"Had a question from a client yesterday concerning the subject: I want to know which database</i> …

APEX 5.1 NF : Show Custom Application Icons in the APEX Builder

It just isn't fair. If you install a Packaged Application - and you should because there is a lot to learn from those apps - in your APEX Workspace …

How to Display a BLOB image in an APEX Report

Do you want to display an image on a report in APEX ?<p>Is the image stored as a BLOB data type in your schema or the blob is returned by some functions?<p>…

Navigating through your APEX Calendar - the easy way

The renewed Calendar Region in APEX is awesome. With just one SQL statement you can provide your users with a calendar view of their data that looks …

Unexpected behaviour using SSO Authentication for APEX

A customer of mine switched to a Singe Sign On Authentication Scheme for their APEX application - using Oracle Access Manager, but that's irrelevant …

Create a Navigation Bar based on a SQL statement

Creating a Navigation Bar using static values is very straightforward. Just create a list similar to this example below - and you can easily define …

DB_LINK w/o tnsnames.ora

A question popped up, which I thought was interesting. <b>How can you create a DB_LINK in Oracle without the DBA changing the tnsnames.ora file?</b> It’s …

APEX session isolation across multiple browser tabs - Problem Solved (in APEX 5.1)

Since the genesis of Oracle Application Express, customers have asked for a way to open multiple browser tabs (or windows) of an APEX application and …

INSERT into a View with a GROUP BY Clause - @DBoriented

When I wrote the previous post, about updatable views, I noticed an interesting issue.<p>The documentation says:<p>If a view is defined by a query that …

Reset Interactive Report (IR)

Resetting an Interactive Report (IR) can be done in 4 different ways.<br>User Reset, URL Link, Page Process, Dynamic Action<b><br>First of all</b><br>It is always a …

Playing with Oracle REST Data Services (ORDS)

I think it’s been about 18 months since I first wrote about installing ORDS 3, but since then I’ve done little more than dabble. For historical …