floretli.blogspot.com

Wenlai's Tech Notes

After over 20 years in computer software world, I feel I need to share my expertise online - and it will be my own notes too. Generally I want to discuss topics that deep in the technology - normally you may encounter after a couple of years in that area. There are many entry-level materials on the web already, but I feel many times I struggle a long time to find a workable solution. This blog is for those who have same feelings.

http://floretli.blogspot.com/

OVERVIEW OF floretli.blogspot.com

TRAFFIC RANK

>1,000,000

REVIEWS

0

PAGES IN THIS WEBSITE

19

LINKS TO THIS WEBSITE

CONTACTS

ADDRESSES

SOCIAL LINKS

ONLINE SINCE

WEBSITE DETAILS

SEO

PAGES

SIMILAR SITES

TRAFFIC RANK FOR FLORETLI.BLOGSPOT.COM

TODAY'S RATING

>1,000,000

TRAFFIC RANK - AVERAGE PER MONTH

BEST MONTH

May

AVERAGE PER DAY Of THE WEEK

HIGHEST TRAFFIC ON

Thursday

TRAFFIC BY CITY

Sign up

CUSTOMER REVIEWS

Average Rating: 4.1 out of 5 with 17 reviews

5 star

9

4 star

4

3 star

2

2 star

0

1 star

2

Hey there! Start your review of floretli.blogspot.com

AVERAGE USER RATING

Write a Review

WEBSITE PREVIEW

LOAD TIME

0.2 seconds

FAVICON PREVIEW

16x16
32x32

CONTACTS AT FLORETLI.BLOGSPOT.COM

ADD CONTACT

Login

TO VIEW CONTACTS

Remove Contacts

FOR PRIVACY ISSUES

CONTENT

PAGES IN
THIS WEBSITE

19

SSL

EXTERNAL LINKS

3

SITE IP

216.58.194.161

LOAD TIME

0.211 sec

SCORE

6.2

PAGE TITLE

Wenlai's Tech Notes | floretli.blogspot.com Reviews

<META> DESCRIPTION

After over 20 years in computer software world, I feel I need to share my expertise online - and it will be my own notes too. Generally I want to discuss topics that deep in the technology - normally you may encounter after a couple of years in that area. There are many entry-level materials on the web already, but I feel many times I struggle a long time to find a workable solution. This blog is for those who have same feelings.

<META> KEYWORDS

1 wenlai's tech notes

2 here

3 posted by

4 floretli

5 no comments

6 labels oracle

7 string aggregation

8 also

9 throws sqlexception {

10 should not call

CONTENT

Page content here

KEYWORDS ON PAGE

wenlai's tech notes,here,posted by,floretli,no comments,labels oracle,string aggregation,also,throws sqlexception {,should not call,next,got value 1,got value 2,do {,labels java,jdbc,jdbctemplate,rowcallbackhandler,spring,sqlplus user/pwd@/ host 1521/sid

SERVER

GSE

CONTENT-TYPE

utf-8

GOOGLE PREVIEW

Wenlai's Tech Notes | floretli.blogspot.com Reviews

https://floretli.blogspot.com

After over 20 years in computer software world, I feel I need to share my expertise online - and it will be my own notes too. Generally I want to discuss topics that deep in the technology - normally you may encounter after a couple of years in that area. There are many entry-level materials on the web already, but I feel many times I struggle a long time to find a workable solution. This blog is for those who have same feelings.

INTERNAL PAGES

floretli.blogspot.com

1

Wenlai's Tech Notes: Accessing Non-exsits Item in Oracle Associative Array

http://floretli.blogspot.com/2008/03/accessing-non-exsits-item-in-oracle.html

Friday, March 14, 2008. Accessing Non-exsits Item in Oracle Associative Array. Look at this piece of code:. Set serveroutput on declare type MONTH TYPE is table of varchar(20) index by binary integer; month table MONTH TYPE; begin month table(1) := 'Jan'; month table(2) := 'Feb'; if month table(3) is null then dbms output.put line( 'March is not defined.' ); end if; end; /. You may think the print line. However, you'll get an error:. ERROR at line 1: ORA-01403: no data found ORA-06512: at line 9.

2

Wenlai's Tech Notes: November 2007

http://floretli.blogspot.com/2007_11_01_archive.html

Wednesday, November 14, 2007. Another Way to Reorgnize Table in Oracle. After inserting/deleting from a table for a long time, the table may contain much spared space that hurts the full table scan greatly. Instead of export and import, or recreate it. Move it from one tablespace to another is another way. Here's a case I did recently. I noticed a table is slow when running full table scan, however it contains only 30K rows, and each row is not that big. OK, move it to another tablespace:.

3

Wenlai's Tech Notes: December 2006

http://floretli.blogspot.com/2006_12_01_archive.html

Wednesday, December 13, 2006. Row Locks When Inserting - Oracle. My co-worker told me his application hanging while inserting a row into a table. By looking at the Oracle Enterprise Manager, I noticed it's caused by foreign key. Here I show an example. Open a SQL Plus, create the tables and foreign key. Now try to insert a row without referring type. Expecting an error:. Open another session using SQL Plus, insert a row in test test type table but don't commit:. Commit the changes and cleanup:.

4

Wenlai's Tech Notes: March 2008

http://floretli.blogspot.com/2008_03_01_archive.html

Friday, March 14, 2008. Accessing Non-exsits Item in Oracle Associative Array. Look at this piece of code:. Set serveroutput on declare type MONTH TYPE is table of varchar(20) index by binary integer; month table MONTH TYPE; begin month table(1) := 'Jan'; month table(2) := 'Feb'; if month table(3) is null then dbms output.put line( 'March is not defined.' ); end if; end; /. You may think the print line. However, you'll get an error:. ERROR at line 1: ORA-01403: no data found ORA-06512: at line 9.

5

Wenlai's Tech Notes: July 2010

http://floretli.blogspot.com/2010_07_01_archive.html

Thursday, July 22, 2010. Interval Partitions in Oracle 11g. Among many other enhancements in Oracle 11g, interval partition is definitely a good one for DBAs. There is a good article here. Discussing it (and other partition enhancements). In one of our projects, we are looking for sub-partitions within an interval partition, and it's well able to handle. Here's an extended discussion of the link. This time we have a interval partition, and list subpartitions inside. Links to this post.

UPGRADE TO PREMIUM TO VIEW 14 MORE

TOTAL PAGES IN THIS WEBSITE

19

OTHER SITES

floretjewellery.com

Floret Jewellery. UK based custom jewellery designer

Telephone 0777 162 6508.

floretlafayette.com

Floret Lafayette | For the Love of Flowers

3581 Mt. Diablo Blvd, Suite C Lafayette, CA 94549 (925) 310.4546. Proudly powered by WordPress. Theme: Sugar and Spice by WebTuts.

floretlaw.com

FLORET | Advocatenkantoor | Den Haag

FLORET is een advocatenkantoor dat is gespecialiseerd in het mededingingsrecht en het procederen tegen toezichthouders. FLORET advocaat van OversluitClaim. FLORET treedt op voor Stichting OversluitClaim in de collecieve actie tegen de te hoge oversluitvergoedingen die de banken en andere verstrekkers van hypothecair Lees meer. FLORET staat CZAV en CAV bij in melding joint-venture bij ACM. FLORET heeft Agri and Food ondernemingen bijgestaan in kartelprocedures bij Rechtbank Rotterdam. Meer nieuws en zaken.

floretlaw.nl

FLORET | Advocatenkantoor | Den Haag

Wij zijn een advocatenkantoor gespecialiseerd in het mededingingsrecht en het procederen tegen toezichthouders. Onze jarenlange ervaring hebben wij opgedaan in de advocatuur, het bedrijfsleven en bij de Autoriteit Consument en Markt (ACM). Deze brede achtergrond stelt ons in staat snel tot de kern te komen en effectief te zijn in ons optreden. FLORET staat CZAV en CAV bij in melding joint-venture bij ACM. FLORET heeft Agri and Food ondernemingen bijgestaan in kartelprocedures bij Rechtbank Rotterdam.

floretle.deviantart.com

Floretle (Ria) - DeviantArt

Window.devicePixelRatio*screen.width 'x' window.devicePixelRatio*screen.height) :(screen.width 'x' screen.height) ; this.removeAttribute('onclick')" class="mi". Window.devicePixelRatio*screen.width 'x' window.devicePixelRatio*screen.height) :(screen.width 'x' screen.height) ; this.removeAttribute('onclick')". Join DeviantArt for FREE. Forgot Password or Username? Top 10 saddest anime deaths. Deviant for 2 Years. 10 Month Core Membership. Daily Pageviews ». Last Visit: 4 hours ago. Why," you ask? Jan 12, ...

floretli.blogspot.com

Wenlai's Tech Notes

Sunday, January 31, 2016. Better String Aggregation since Oracle 11gR2. In my previous blog. String aggregate in Oracle. I mentioned the restriction of that function is no ordering. Actually since Oracle 11g Release 2, Oracle introduced a new function LISTAGG which provides the same functionality, and also with ordering. You can find details. Anyway, I'll show some quick examples in this blog too. To achieve the same result, the query below can be used:. And below is the result. Links to this post. You c...

floretlys-79.com

Fleuriste à Absie 79 Deux-Sèvres, fleurs fraîches et bouquets de fleurs : Fleuriste Flor & Lys (79)

La boutique de L'Absie sera fermée pour congés annuels du lundi 3 au l. Pour recevoir toutes nos promotions :. Agrave; L Absie, fleuriste (79) Deux-Sèvres : fleurs coupées, bouquets, compositions florales. Avec une fleuriste diplômée dynamique et passionnée, la boutique Flor and Lys. Est toujours à la recherche de nouvelles idées. Située en plein centre de L Absie, nous mettons tout notre savoir-faire à votre service afin de répondre au mieux à vos attentes. Ou vous faire plaisir :. 05 49 63 04 93. Diman...

floretmagic.com

floretmagic.fr | Magicien Mentalist

Magie parcs et jardins. Nos domaines d’intervention. Magie et Mentalisme entreprises. K Barré Magic Show. La magie est juste une parenthèse. Dans l’univers cartésien du spectateur. La magie est l’essence de tous les arts. Quand on est transporté en écoutant un morceau de musique, c’est de la magie. Quand on se prend pour le héros d’un livre en étant plongé dans un roman, c’est de la magie. Nous vous invitons à entrer dans notre univers. Vous découvrirez les diverses prestations que nous proposons,. Spéci...

floretmart.com

BRAINBLOW TECHNOLOGIES

We believe in Success without Boundaries. We Follow the principles of Honesty, Sincerity, and commitment". Our team of Professionals include Phds, MBAs, PMPs, Engineers with industry recognized certifications". Customer focus is always our top most Priority. Headquartered in Suburbs of Houston, Texas-USA, BrainBlow Inc. S vision is to support customers around globe by empowering them with right solutions that fit their needs using our vast experience and expertise. Management and IT consulting. We follow...

floretmedia.com

Digital Marketing Agency - Internet Marketing Company Bangalore

User Research and Analysis. YouTube and Video Marketing. Apparel,Textiles and Accessories. Bags, Shoes and Accessories. Home, Lights and Construction. Machinery, Industrial Parts and Tools. A digital response to your business challenges. Crafting experiences with beautifully executed, creative design. Branding identity designs that creates a buzz. Building brands for winning and growing customers. Thoughtfully crafted online store, the unique enabler of your business. Helping you seize essential advantage.