ODIEWEBLOG.WORDPRESS.COM
Odie's Oracle Blog | XML functionalities in the database, and related stuff…XML functionalities in the database, and related stuff... (by Marc)
http://odieweblog.wordpress.com/
XML functionalities in the database, and related stuff... (by Marc)
http://odieweblog.wordpress.com/
TODAY'S RATING
>1,000,000
Date Range
HIGHEST TRAFFIC ON
Sunday
LOAD TIME
1.8 seconds
16x16
32x32
PAGES IN
THIS WEBSITE
5
SSL
EXTERNAL LINKS
27
SITE IP
192.0.78.13
LOAD TIME
1.828 sec
SCORE
6.2
Odie's Oracle Blog | XML functionalities in the database, and related stuff… | odieweblog.wordpress.com Reviews
https://odieweblog.wordpress.com
XML functionalities in the database, and related stuff... (by Marc)
odieweblog.wordpress.com
PL/SQL RPN calculator – version 2 | Odie's Oracle Blog
https://odieweblog.wordpress.com/2014/11/24/plsql-rpn-calculator-version-2
Odie's Oracle Blog. XML and JSON functionalities in the database, and related stuff…. PL/SQL RPN calculator – version 2. PL/SQL RPN calculator – version 2. November 24, 2014. This post presents a new version of my PL/SQL RPN calculator. It now includes :. A recursive-descent parser to validate the input expression. An improved evaluator based on a compiled “type-aware” RPN expression. Program and additional objects available here : rpn util v2.zip. Update 2016-08-07 : RPN UTIL v2 is now deprecated. The t...
JSON_TABLE Chaining | Odie's Oracle Blog
https://odieweblog.wordpress.com/2015/04/12/json_table-chaining
Odie's Oracle Blog. XML and JSON functionalities in the database, and related stuff…. April 12, 2015. Here’s the first article of the JSON category, focusing on JSON TABLE for unnesting nested JSON arrays. We’ll first create a table to hold some JSON documents :. Create table tmp json ( id integer , doc clob check (doc is json) ) lob (doc) store as securefile (cache);. And some docs :. 1- “Naive” unnesting method. However, that query does not work and returns :. So, what’s the official, supported w...
JSON Update for the Impatient | Odie's Oracle Blog
https://odieweblog.wordpress.com/2015/07/30/json-update-for-the-impatient
Odie's Oracle Blog. XML and JSON functionalities in the database, and related stuff…. JSON Update for the Impatient. JSON Update for the Impatient. July 30, 2015. Waiting for a future(? Oracle implementation in the database, this post presents a JSON Update API for SQL and PL/SQL. The API comprises two parts :. A JSON model, using the org.json. Reference implementation written in Java. The PL/SQL package, JAR and Java source code are available here : json util.zip. 8211; Download the zip file. C: Users M...
How To : Parse repeating groups correlated by position as relational data | Odie's Oracle Blog
https://odieweblog.wordpress.com/2015/06/19/how-to-parse-repeating-groups-correlated-by-position-as-relational-data
Odie's Oracle Blog. XML and JSON functionalities in the database, and related stuff…. How To : Parse repeating groups correlated by position as relational data. How To : Parse repeating groups correlated by position as relational data. June 19, 2015. Here’s a new post in the category “How to deal with that unfriendly design? Again, since the title is not very explicit, an example will surely explain it all :. This is the result we want out of that data :. Root ids id 1 /id id 2 /id id 3 /id! Up to 2016-0...
PL/SQL RPN calculator | Odie's Oracle Blog
https://odieweblog.wordpress.com/2013/02/03/plsql-rpn-calculator
Odie's Oracle Blog. XML and JSON functionalities in the database, and related stuff…. February 3, 2013. Some non-XML stuff for a change :). This is something I’ve developed recently to evaluate stored expressions (formulas) using variables. The “calculator” is written in PL/SQL and implements an RPN. Evaluation technique, as well as a method to convert infix expressions to RPN using the shunting-yard algorithm. The evaluation function does not. Involve any dynamic SQL. PL/SQL RPN calculator version 2.
TOTAL PAGES IN THIS WEBSITE
5
Sync tables: generate MERGE using Unique constraint | An Oracle Programmer
https://stewashton.wordpress.com/2015/01/15/sync-tables-generate-merge-using-unique-constraint
SQL and PL/SQL techniques and solutions. About this blog and test environment. Sync tables: generate MERGE using Unique constraint. In my post “ Compare and sync tables: Generating the code. 8220;, I use the primary key constraint on the target table. A reader called “Bal” asked how to use a unique constraint instead. Here is a list of my posts about comparing and synchronizing tables. I’m going to create a target table with a unique constraint, but without any NOT NULL constraints on the columns. 0 ) wh...
Merging Overlapping Date Ranges with MATCH_RECOGNIZE | An Oracle Programmer
https://stewashton.wordpress.com/2015/06/10/merging-overlapping-date-ranges-with-match_recognize
SQL and PL/SQL techniques and solutions. About this blog and test environment. Merging Overlapping Date Ranges with MATCH RECOGNIZE. I forgot to add a MATCH RECOGNIZE solution to my last post on merging overlapping date ranges. That should take me just a few minutes, right? Wrong: it’s not that easy and here’s why. For test data, please refer to the previous post. To Merge or not to Merge? We sort by start date, then end date. The current row should be merged if its start date is less than or equal to.
Splitting a Table into Rowid Ranges of Equal Size | An Oracle Programmer
https://stewashton.wordpress.com/2015/07/01/splitting-a-table-into-rowid-ranges-of-equal-size
SQL and PL/SQL techniques and solutions. About this blog and test environment. Splitting a Table into Rowid Ranges of Equal Size. In the OTN forum, Jonathan Lewis recently asked for an efficient SQL solution to split a table into 12 ROWID ranges having the same ( -1) number of blocks. I’m posting here a slightly cleaned-up version of my answer so I can change it if necessary after the question gets archived. If you stop at the ANSWER clause, you will see the number of blocks in each bucket. What is the r...
Join Tables on Date Ranges | An Oracle Programmer
https://stewashton.wordpress.com/2015/03/21/join-tables-on-date-ranges
SQL and PL/SQL techniques and solutions. About this blog and test environment. Join Tables on Date Ranges. A recent question on the OTN SQL forum. Asked how best to join two tables related by ID and date range, in order to insert one row per date into a data warehouse. One solution was to expand the data from each table, creating one row per date, then join on date. I think it’s more efficient to join on date range, then expand. Here’s how. Input Tables and Requirement. The start date in table 1. If you ...
MATCH_RECOGNIZE: gaps in date ranges | An Oracle Programmer
https://stewashton.wordpress.com/2015/06/14/match_recognize-gaps-in-date-ranges
SQL and PL/SQL techniques and solutions. About this blog and test environment. MATCH RECOGNIZE: gaps in date ranges. To find gaps between date ranges, there is an elegant solution using analytic functions. We can follow the same logic with. Using a technique that avoids the problems with. Comparisons I just wrote about. Here are some simple test data. Please note that I use exclusive end dates: the second to last range ends when March 2d starts, so there should be a gap from March 2d to March 3d. Will ou...
SQL for date ranges, gaps and overlaps | An Oracle Programmer
https://stewashton.wordpress.com/2014/03/11/sql-for-date-ranges-gaps-and-overlaps
SQL and PL/SQL techniques and solutions. About this blog and test environment. SQL for date ranges, gaps and overlaps. Update 2014-07-04] Since this is my most popular post, I’m adding an index to all my posts about date ranges:. This post right here explains terms like “gap, meet, overlap”, shows how to design date ranges in tables and explains what null values should mean. SQL and date ranges: don’t make NULL mean something. Gaps in Date Ranges: when are you free? Merging contiguous date ranges. Is jus...
February | 2016 | Simply Oracle...
https://rboracle.wordpress.com/2016/02
My professional notes, Ranit Biswas. Monthly Archives: February 2016. Installing Python packages…. February 25, 2016. This is my first post on Python. So, kinda glad about it. Actually, I didn’t want to put this as a post, and not at all with this very content. But finally decided to jot it before I forget. So, first things first…. To install a Python package on v3.4.2, from Windows 7 (Professional) command prompt –. 1 Installing “httplib2” package. C: Users Energy py -m pip install httplib2.
BigData: interesting articles… | Simply Oracle...
https://rboracle.wordpress.com/2015/01/06/bigdata-interesting-articles
My professional notes, Ranit Biswas. BigData: interesting articles…. January 6, 2015. 1 Tips for landing a job in the big data industry. 2 Is healthcare ready for Big Data? Beginning HBase… →. Leave a Reply Cancel reply. Enter your comment here. Fill in your details below or click an icon to log in:. Address never made public). You are commenting using your WordPress.com account. ( Log Out. You are commenting using your Twitter account. ( Log Out. Notify me of new comments via email.
Silver Pockets Full – | Simply Oracle...
https://rboracle.wordpress.com/2014/10/29/silver-pockets-full
My professional notes, Ranit Biswas. Silver Pockets Full –. October 29, 2014. Yesterday, I came across Chet Justice’s blog post. On the phenomenon of “Silver Pockets Full”. Interesting! It claims that – a month with 5 Fridays and 5 Saturdays and 5 Sundays – occurs once in every 823 years. So, the problem statement. Was to find out the correctness of this supposition. And, also to find out the next months which satisfies this criteria. Let’s try it out. Oracle database bookmarks –. Enter your comment here.
TOTAL LINKS TO THIS WEBSITE
27
odieux (:B) | DeviantArt
Window.devicePixelRatio*screen.width 'x' window.devicePixelRatio*screen.height) :(screen.width 'x' screen.height) ; this.removeAttribute('onclick')". Deviant for 13 Years. This deviant's activity is hidden. Deviant since May 17, 2004. This is the place where you can personalize your profile! By moving, adding and personalizing widgets. You can drag and drop to rearrange. You can edit widgets to customize them. The bottom has widgets you can add! We've split the page into zones! Why," you ask? Oct 30, 2008.
O.D.I EVENTOS
Todas as empresas que tem CIPA (Comissão interna de Prevenção de Acidentes) são obrigadas anualmente a realizar a SIPAT (Semana interna de Prevenção de Acidentes), para dinamizar a sua. Uma forma MÁGICA de fazer o seu treinamento. Os funcionários participarão em grupos de uma oficina de mágica. Através de provas inteligentes e desafiadoras e que em caso. CIRCUITO DE COMPETÊNCIAS/HABILIDADES. Neste jogo interagimos com nosso programa de Quiz eletrônico medindo o conhecimento dos participantes, quando.
Safety Leadership Videos For High Risk Occupations
Safety Leadership Videos For High Risk Occupations. Based on the Material of Jeff "Odie" Espenship. This is our current lineup. Click on the DVD thumbnail for more information and to purchase. Running Time: 12 minutes Price $395. Even your most experienced, most competent operator can be your biggest nightmare if that person sees themselves as above the rules. This is the story of Bud Holland who crashed a B-52 because he thought he could operate beyond the limits. Where were the supervisors? 8221; when ...
Flo's Pages
Si tu hésites entre suivre et relancer, relance - Chris Jesus Ferguson. 2009 Florent Odièvre Contact.
OdieWare - Bud Odekirk's Homepage
This page uses frames, but your browser doesn't support them.
Odie's Oracle Blog | XML functionalities in the database, and related stuff…
Odie's Oracle Blog. XML functionalities in the database, and related stuff…. JSON Update for the Impatient. July 30, 2015. Waiting for a future(? Oracle implementation in the database, this post presents a JSON Update API for SQL and PL/SQL. The API comprises two parts :. A JSON model, using the org.json. Reference implementation written in Java. The package is used as is, except for the additional org.json.JSONArray.insert() method I’ve added to handle insert operations in arrays. June 19, 2015. Here...
Coming Soon - Future home of something quite cool
Future home of something quite cool. If you're the site owner. To launch this site. If you are a visitor. Please check back soon.
o d i e w o r k s
全身脱毛ができる家庭用脱毛器のオススメ
OdieWu
Hi, I'm Odie. A UX/UI Designer and Illustrator. As a UX/UI Designer. I am interested in both traditional and digital illustration. I am a big fan of Moleskine, Maker pen and Watercolor. I am currently available for work!
Persepsi Adalah Realita | More Than Word
124; Comments RSS. Social Networking Indo punya. Sebuah persepsi baru,kenyataan bahwa mereka berpihak atau tidak itu sebuah realita.Kehidupan adalah sebuah Frasa. Suka atau tidak suka pilihan tetaplah dipilih. Maka lahirlah sebuah persepsi baru,kenyataan bahwa mereka berpihak atau tidak itu sebuah realita.Kehidupan adalah sebuah Frasa. Suka atau tidak suka pilihan tetaplah dipilih. Maka lahirlah sebuah Kehidupan adalah sebuah Frasa. Kehidupan adalah sebuah Frasa. Berikan Balasan Batalkan balasan. Ikuti P...
SOCIAL ENGAGEMENT