christopherbeck.wordpress.com
My First APEX Plug-In – Color Picker. | Christopher Beck's Blog
https://christopherbeck.wordpress.com/2010/07/02/my-first-apex-plug-in-color-picker
Christopher Beck's Blog. Yet another tech blog on Oracle, APEX and PL/SQL development ( and other rants, just to keep it interesting ). My First APEX Plug-In – Color Picker. My First APEX Plug-In – Color Picker. July 2, 2010. For anyone who does not know by now, APEX 4.0. Has been released. And if you have not yet downloaded and upgraded, I say, “What are you waiting for? 8221; Click here NOW. And download it. I’ll wait. Insert jeopardy music here*. There are a ton of new features. The Plug-In I built wa...
joelkallman.blogspot.com
Let's Wreck This Together...with Oracle Application Express!: April 2014
http://joelkallman.blogspot.com/2014_04_01_archive.html
Turning customers into rockstars, with the Oracle Database, PL/SQL and Oracle Application Express. Wednesday, April 09, 2014. Oracle Application Express 4.2.5 now available. Oracle Application Express 4.2.5 is now released and available for download. If you wish to download the full release of Oracle Application Express 4.2.5, you can get it from the Downloads page. Look up patch number 17966818. As is stated in the patch set note. That accompanies the Oracle Application Express 4.2.5 patch set:. As usua...
joelkallman.blogspot.com
Let's Wreck This Together...with Oracle Application Express!: March 2014
http://joelkallman.blogspot.com/2014_03_01_archive.html
Turning customers into rockstars, with the Oracle Database, PL/SQL and Oracle Application Express. Thursday, March 20, 2014. Yet Another Post How to Link to Download a File or Display an Image from a BLOB column. On an internal mailing list, an employee (Richard, a long-time user of Oracle Application Express) asked:. We are attempting to move to storing (the images) in a BLOB column in our own application tables. Is there no way to display an image outside of page items and reports? Firstly, a way not.
christopherbeck.wordpress.com
Email BLOB Attachments From The Database | Christopher Beck's Blog
https://christopherbeck.wordpress.com/2009/12/01/email-blob-attachments-from-the-database
Christopher Beck's Blog. Yet another tech blog on Oracle, APEX and PL/SQL development ( and other rants, just to keep it interesting ). Email BLOB Attachments From The Database. Email BLOB Attachments From The Database. December 1, 2009. Recently I was developing an oracle database application and had the requirement to send out an email with an attachment. Initially it sounded pretty easy. I’ll just use the APEX MAIL. Package. There is an API to add attachments. But wait, you can only add VARCHAR. 8211;...
christopherbeck.wordpress.com
Enhanced APEX Shuttle Item | Christopher Beck's Blog
https://christopherbeck.wordpress.com/2009/04/28/enhanced-shuttle-item
Christopher Beck's Blog. Yet another tech blog on Oracle, APEX and PL/SQL development ( and other rants, just to keep it interesting ). Enhanced APEX Shuttle Item. Enhanced APEX Shuttle Item. April 28, 2009. Http:/ apex.oracle.com/pls/otn/f? As the user types in the textbox the shuttle automagically filters itself. I use an onKeyUp event on the textbox P10 SEARCH BY to trigger the AJAX call. OnKeyUp="populateShuttle( this,'P10 SHUTTLE');". It fetches all the values that match the filter. So that how I am...
krisrice.blogspot.com
Kris' blog: April 2014
http://krisrice.blogspot.com/2014_04_01_archive.html
Educating developers on what Oracle tools and products our team makes, hopefully. Monday, April 28, 2014. KScope14's Sunday Database Symposium. This is the 3rd year. And I have organized the Sunday Symposium. This year has a bunch of great speakers with great content. So, if you are debating at all getting to KScope a day early to make the symposium, here's the agenda for the DB Symposium and debate no more get there early! Starting off the APEX and DB tracks will be combined. Split to separate DB track.
montylatiolais.blogspot.com
NTILE vs WIDTH_BUCKET and the Winner is...PIVOT | Monty Latiolais
http://montylatiolais.blogspot.com/2015/07/ntile-vs-widthbucket-and-winner-ispivot.html
Thursday, July 9, 2015. NTILE vs WIDTH BUCKET and the Winner is.PIVOT. At a recent meeting of developers, a requirement was discussed where a finite number of columns are to be populated in alphabetical order - think the opposite of telephone book. As is often the case, there are multiple ways to do this, but at it's heart, this really is a pure pivot. I think we should rule out both NTILE and WIDTH BUCKET. SELECT ename ,. NTILE(5) OVER ( ORDER BY ename ) AS quartile FROM. SELECT ename ,. SELECT ename ,.
montylatiolais.blogspot.com
Monty Latiolais: November 2013
http://montylatiolais.blogspot.com/2013_11_01_archive.html
Wednesday, November 6, 2013. Who is the drummer for AC/DC? A year from now Jeff Smith will ask me if I know who is the drummer for rock band AC/DC. It is no other than Phil Rudd. Who I might add will be charged one year from today for putting a hit on two people in New Zealand. Subscribe to: Posts (Atom). Fulshear, TX, United States. Come on in and sit a spell. Here you'll find an assortment of tips, tricks, techniques and general musings to aid and assist Oracle developers. View my complete profile.
montylatiolais.blogspot.com
Monty Latiolais: May 2015
http://montylatiolais.blogspot.com/2015_05_01_archive.html
Sunday, May 17, 2015. I Happened Fifty Years Ago. About three hours east from where I sit is Lake Charles, Louisiana. It was there, fifty years ago today,.I came to be. Even then, the hat. I must admit the first few years remain a bit fuzzy. My earliest memory is still about the time I turned three. I remember living in the Riverside section of Orange, Texas. I remember well the day my sister arrived. Here is where the plot thickens.so pay attention. We lived in the coast range of Oregon between Newport ...
montylatiolais.blogspot.com
Monty Latiolais: July 2015
http://montylatiolais.blogspot.com/2015_07_01_archive.html
Wednesday, July 15, 2015. A Few Lines of SQL Tames a Weird Requirement. A few days back I answered a question on the OTN SQL Discussion Forum and thought it blog worthy. The requirement itself is kind of strange, but I'll try and explain it. Basically there is an outbound trip and an inbound trip. Each record has a direction identifier, a sequence and various waypoints aka tp points. The data looks like this:. Create table a(dirid number, seq number, tp number);. Insert into a values (1,1,101);. Lastly, ...
