tag:blogger.com,1999:blog-7235729615549403152025-08-13T03:14:07.829+05:30Some things about Oracle that I jot about, keep for my records. Some articles in this blog are not owned by me. They are for my reference only. Anantha Narayananhttp://www.blogger.com/profile/01235733287809115092noreply@blogger.comBlogger237125tag:blogger.com,1999:blog-723572961554940315.post-46220516289908194092024-07-03T12:27:00.004+05:302024-07-03T12:27:34.418+05:30

 If you have a data with Comma, or any other character delimited use the following query to convert it to individual rows.-- Created on 03/07/2024 by ANANTHAN DECLARE  -- Local variables here  CURSOR c1 IS WITH rws AS(    SELECT 'one,two,three' str    FROM   dual)    SELECT regexp_substr(str, '[^,]+', 1, LEVEL) split_val   

Anantha Narayananhttp://www.blogger.com/profile/01235733287809115092noreply@blogger.com0tag:blogger.com,1999:blog-723572961554940315.post-81771679170911276602020-09-29T12:25:00.007+05:302020-09-29T12:26:24.778+05:30

I was getting the above error "Your session has expired" immediately after upgrade of Oracle Apex from Version 5 to 20 in my premises. Searched a lot and did not find any resolution. After trying to login in same browser, tried a private browsing mode in Chrome and Firefox. It logged in. That is when i realized that it might be due to session cache/cookie. As a resolution I cleared all session

Anantha Narayananhttp://www.blogger.com/profile/01235733287809115092noreply@blogger.com0tag:blogger.com,1999:blog-723572961554940315.post-79824042908495259512019-04-01T12:45:00.000+05:302019-04-01T12:45:53.750+05:30

The following is a query from a friend, Reproducing it here: I have a menu structure using a hierarchical query. i have search field to enter some string and search.I should get the result in the same menu format with with the node and its parents.Can you please help me with the query for search ?eg.A1 A11 A12 A123 A13B1 B123C1 C11 C12If I search for %123% the result -A1 A12

Anantha Narayananhttp://www.blogger.com/profile/01235733287809115092noreply@blogger.com0tag:blogger.com,1999:blog-723572961554940315.post-64002359449630772002017-11-13T11:58:00.003+05:302017-11-13T11:58:39.414+05:30

SQLPLUS command line provides a show user help which can print which user you are logged in as. Just learned new today that it is not hitting the DB to get the results. Tom, who else can bring it to light. I am just 12 years down the line to have read his message. The content points to this article The SQLPLUS caches the username as soon as a "connection" is established and saves it for reuse

Anantha Narayananhttp://www.blogger.com/profile/01235733287809115092noreply@blogger.com0tag:blogger.com,1999:blog-723572961554940315.post-73761333906140417672017-08-24T11:18:00.002+05:302024-07-03T12:23:58.356+05:30

Though Oracle doesn't support Forms 10g in Windows 10: 64 bit, I had installed it and was working till last month. Then suddenly one fine day, the report builder window won't show up. Though it was running in the task bar, I couldnt do anything with it. Forms builder was working properly. Then taking cue from this Oracle form community post, I copied the cauprefs.ora from my colleague. Boom,

Anantha Narayananhttp://www.blogger.com/profile/01235733287809115092noreply@blogger.com18tag:blogger.com,1999:blog-723572961554940315.post-19723427765797825302017-06-14T16:19:00.002+05:302017-06-14T16:19:30.311+05:30

Oracle Apex supports or offers a GIF image and an overlay while loading content using Dynamic Action/AJAX. While creating a dynamic action you have an option to select "Show Processing" for supported actions. This shows a nice overlay over the screen and a GIF image out of the box. You may have scenarios to show a loading while doing some javascript/jquery actions on your own. Will it not be

Anantha Narayananhttp://www.blogger.com/profile/01235733287809115092noreply@blogger.com0tag:blogger.com,1999:blog-723572961554940315.post-82156586981797756202016-10-24T11:14:00.001+05:302016-10-24T11:15:34.840+05:30

This tip is courtesy +V. Kapoor from http://www.foxinfotech.in. Thank you, you saved my day. I had a situation where the database procedure SRW is wrapped and I needed to log the dbms_output.put_line output produced by the package into a table. Thanks to the tip provided, I was able to do so. I had to call the following procedure dbms_output.get_lines(vcol, n); This procedure

Anantha Narayananhttp://www.blogger.com/profile/01235733287809115092noreply@blogger.com0tag:blogger.com,1999:blog-723572961554940315.post-36918716468830256282016-07-13T11:06:00.000+05:302016-07-13T11:06:37.183+05:30

Starting Oracle Apex 4.1, application pages by default will not open inside an iframe (inline frame). There is a new security setting introduced, which is restricting this feature. As commented by +Patrick Wolf  in community.oracle.com the following setting has to be changed to enable this feature: This is what he had to say: "There is a new security feature to prevent

Anantha Narayananhttp://www.blogger.com/profile/01235733287809115092noreply@blogger.com0tag:blogger.com,1999:blog-723572961554940315.post-79586158591852948492016-05-11T23:17:00.000+05:302016-05-11T23:17:20.144+05:30

Its been some time since I have written in this blog. Its mainly because of my work schedule. Cutting short personal note, let me introduce the problem. I have a plain HTML page which has two drop-down which is my interest in the article. The first one is Country, second one is Region/State. My requirement is to change the Regions when Country is selected/changed. I was trying to

Anantha Narayananhttp://www.blogger.com/profile/01235733287809115092noreply@blogger.com0tag:blogger.com,1999:blog-723572961554940315.post-1181740420770841902016-01-13T18:47:00.002+05:302016-01-13T18:47:44.924+05:30

This was a strange error which was daunting me for couple of hours today. The field name reported by Forms Builder had no formula attached to it. The property of all fields in the block was also same. But since this was a warning, I tend to ignore. But after some more time, bogged over with the unnecessary popup while creating FMX. Some googling gave me an answer that this was a Form

Anantha Narayananhttp://www.blogger.com/profile/01235733287809115092noreply@blogger.com0tag:blogger.com,1999:blog-723572961554940315.post-74363208924070056282015-06-25T12:02:00.001+05:302015-06-25T12:04:44.648+05:30

I was struggling to find a fix for the problem. Only now I recognized it was a bug in Oracle APEX Version 4.2.3.00.08. The scenario: 1. I have two regions with Interactive & Classical Report 2. When a value is modified in select item in page, I need to refresh these reports. (Used dynamic action to refresh regions on page item change) 3. I used jQuery tabs for the reports (

Anantha Narayananhttp://www.blogger.com/profile/01235733287809115092noreply@blogger.com0tag:blogger.com,1999:blog-723572961554940315.post-88312030548822750092015-05-15T23:16:00.000+05:302015-05-15T23:16:27.477+05:30

This post is due to lack of clear instructions available where I searched for. These are notes which I used to perform a hard disk extension in Ubuntu host for a Windows Vista is guest/vm. Summary of steps: Step 1: Convert vmdk file to vdi (if you are using vmdk as hard drive) Step 2: Resize vdi file to required hard drive size Step 3: Convert the resized vdi file to a new vmdk file (so that

Anantha Narayananhttp://www.blogger.com/profile/01235733287809115092noreply@blogger.com0tag:blogger.com,1999:blog-723572961554940315.post-81870434800196762642015-04-17T13:11:00.001+05:302015-04-17T13:11:12.687+05:30

The new age Oracle Apex is here to download. Till 16th April it was only available as a preview in apex.oracle.com. Starting yesterday it is available for download. For the first time, first day first show I could download Apex from otn and install in my local Express Edition database. The installation was smooth only 3 steps. The upgradation steps are clearly mentioned in documentation here.

Anantha Narayananhttp://www.blogger.com/profile/01235733287809115092noreply@blogger.com0tag:blogger.com,1999:blog-723572961554940315.post-12155629746800680522014-07-21T17:03:00.002+05:302014-07-22T12:48:49.681+05:30

Q: How can I obtain image attributes such as height, width, format from BLOB column? A: Using Oracle Multimedia ORDImage object type it is possible to get such attributes. Consider the following example: DECLARE   lv_blob                  BLOB;   unused_attributes        CLOB;   img_mimetype       &

Anantha Narayananhttp://www.blogger.com/profile/01235733287809115092noreply@blogger.com0tag:blogger.com,1999:blog-723572961554940315.post-9918614452746638942014-07-03T14:12:00.003+05:302014-07-03T14:12:55.174+05:30

Now-a-days if you search for any source code, this word is always there. "GIT". What is so special about it? Well check out the Wikipedia page to know about its history. I would like to borrow one sentence from Wikipedia though: Git was initially designed and developed by Linus Torvalds for Linux kernel development in 2005 The light bulbs glowed for the first time. I always fancied Linux and

Anantha Narayananhttp://www.blogger.com/profile/01235733287809115092noreply@blogger.com0tag:blogger.com,1999:blog-723572961554940315.post-56003411944711116772014-07-01T13:32:00.003+05:302014-07-02T21:37:43.793+05:30

Packt Publishing is celebrating 10 years of its presence by a unique promotional way.  To celebrate this huge milestone, from June 26th Packt is offering all of its eBooks and Videos at just $10 each for 10 days – this promotion covers every title and customers can stock up on as many copies as they like until July 5th. #Packt10Dollar Hurry up, and buy your stocks before the

Anantha Narayananhttp://www.blogger.com/profile/01235733287809115092noreply@blogger.com0tag:blogger.com,1999:blog-723572961554940315.post-83491407013348722402014-06-27T12:50:00.001+05:302014-06-27T12:50:17.356+05:30

I was getting this curious error lately in a development package. I could not resolve what could be the reason for this for sometime. ORA-00900: invalid SQL statement I got some head on from this website, but it did not help my case as both of the cases mentioned by him was not valid for me. I was not using any dblink or neither because of Y2K error. I started to investigate upon it and with

Anantha Narayananhttp://www.blogger.com/profile/01235733287809115092noreply@blogger.com0tag:blogger.com,1999:blog-723572961554940315.post-34561618219382358412014-05-30T14:55:00.001+05:302014-05-30T14:55:24.715+05:30

Its a fact, users are lazy. They want to avoid multiple clicks of button. This time it is to avoid clicking on Actions Menu > Download > Click to download CSV. The requirement was to click one button, download the CSV. Oracle Apex allows this using a simple technique. I was searching many blogs, OTN etc where people were asking you to create a new region, then change the settings of the

Anantha Narayananhttp://www.blogger.com/profile/01235733287809115092noreply@blogger.com0tag:blogger.com,1999:blog-723572961554940315.post-80591673654071208992014-05-27T12:22:00.003+05:302014-05-27T12:23:52.232+05:30

Version: Oracle Application Express 4 and above. Recently I had been asked by my colleague to how to configure header and footer for PDF printing of Interactive reports in Oracle Apex. We have been using Apex 4.2.5, but this tip will work for versions above 4. If PDF download is not working in interactive reports in your setup, refer this article to configure PDF printing. By default if you

Anantha Narayananhttp://www.blogger.com/profile/01235733287809115092noreply@blogger.com0tag:blogger.com,1999:blog-723572961554940315.post-2521377927714250592014-05-06T11:17:00.005+05:302014-05-06T11:17:55.578+05:30

Digital Rights Management (DRM) is a technique used by manufacturers or publishers to control use of their products after sale. If you buy a book, you are not allowed to copy the contents (even take a copy of a page you feel is important). Today on 6th May lot of organizations are raising a voice against the DRM. As individuals it is our aim to support this voice, as we will be benefited. Raise

Anantha Narayananhttp://www.blogger.com/profile/01235733287809115092noreply@blogger.com0tag:blogger.com,1999:blog-723572961554940315.post-72766779093535560092014-04-02T13:10:00.002+05:302014-04-02T13:10:41.119+05:30

Getting Started with Oracle VM VirtualBox This book gives a general introduction to Oracle VM VirtualBox software, which is used in virtualization. Using this software you will be able to run operating systems which are different from the one installed in your hard disk. It can be installed on your Mac, Linux, or even Windows machines. It adds the capability to run multiple operating system

Anantha Narayananhttp://www.blogger.com/profile/01235733287809115092noreply@blogger.com0tag:blogger.com,1999:blog-723572961554940315.post-61439941901598559122014-01-23T18:44:00.003+05:302014-01-23T18:45:06.922+05:30

I googled for this and got this from some website. Do not remember the website from where I got this query. Thanks for the original author. Pasting the query for my personal records: SELECT owner,        table_name,        trunc(SUM(bytes) / 1024 / 1024) meg FROM   (SELECT segment_name table_name,               &

Anantha Narayananhttp://www.blogger.com/profile/01235733287809115092noreply@blogger.com0tag:blogger.com,1999:blog-723572961554940315.post-76115708384673536072014-01-06T13:34:00.002+05:302015-06-25T11:51:46.742+05:30

This tip was posted in Oracle Apex Knowledge Group by Richard Martens. Its my sincere pleasure in thanking the author for this simple tip. The original blog is available here. I am posting the steps first, and a slight deviation which makes the setup one time only through this article. The idea is to create a region first and all sub-regions as tabs. If this design suits your application then

Anantha Narayananhttp://www.blogger.com/profile/01235733287809115092noreply@blogger.com0tag:blogger.com,1999:blog-723572961554940315.post-26880956889982560932014-01-02T15:59:00.002+05:302014-01-02T15:59:41.076+05:30

Oracle Application Express (APEX) offers a lot of regions to be displayed in a single page without cluttering the screen display. One such way of making a page to display lot of contents is using the Region Display Selector. In this tip however I am not going to show how to display the "Region Display Selector" but an inherent problem with this control. I have a screenshot of this control

Anantha Narayananhttp://www.blogger.com/profile/01235733287809115092noreply@blogger.com0tag:blogger.com,1999:blog-723572961554940315.post-36565247230670170722013-12-18T18:01:00.001+05:302013-12-23T19:00:37.230+05:30

I had recently attended OTN Database 12c Developer Day, at Bangalore. I must say it was very informative and gave me new insights on the new database unveiled recently by Oracle Corporation. Rather than focussing more about the event, I will focus what was being the agenda or what what I learned from this event. I must admit I am getting old because this cloud business is too hard to

Anantha Narayananhttp://www.blogger.com/profile/01235733287809115092noreply@blogger.com0