Regular Expression Library Site

Hi

I want report today the site http://regexlib.com/ about "Regular Expression".

A very good source of more than 3500 regular expression from thousand contributors.

Site presents a good search engine and is well done.

So to enjoy regex.

Stay Tuned.

Oracle Nested Table - Create, Insert and Select

Hi all

Today i want to speak about oracle nested table.
Basically you can define in oracle a field that is a table inserted in other table. In Oracle system tables there are two tables used to manage this particular type of columns :

• USER_NESTED_TABLES              : Nested Table List
• USER_NESTED_TABLE_COLS    : Nested Table List Columns

Now an example to test it.

1) Creation a Type :

CREATE OR REPLACE TYPE VALUELIST AS TABLE OF VARCHAR2(20);

2) Creation Table :

CREATE TABLE NESTED_TABLE
(  ID            NUMBER           NOT NULL,
   FIELD1   VALUELIST)
NESTED TABLE FIELD1 STORE AS field1_tab;

3) Inserting values in table :

INSERT INTO nested_table VALUES (1, valuelist('Red'));

INSERT INTO nested_table VALUES (2, valuelist('White', 'Brown'));

INSERT INTO nested_table VALUES (3, valuelist('Blue', 'Orange','Yellow'));

4) Select values :

SELECT id, COLUMN_VALUE FROM nested_table t1, TABLE(t1.field1) t2;

5) Result :

ID    COLUMN_VALUE

1 Red

2 White

2 Brown

3 Blue

3 Orange

3 Yellow

In select statement you must reference a pseudo-column called "COLUMN_VALUE". To select values from a nested table, always you must explain mother table too.

Stay tuned.

Easter egg

Hi all

Today i want speak about "Easter egg".
In Information Technology, "Easter eggs are secret responses that occur in response to an undocumented set of commands." how is correct defined in Wikipedia.

Basically an "Easter egg" is  a programmer's signature, a way to be recognized.

Here some internet examples :

You Tube : Try to write "do the harlem shake" in the search bar and find it.
http://theoatmeal.com/ : Try to see source html code
http://www.entercomputers.com/ : Visit this website and type 'penguin' on the hompage. Note animated penguin. Then wait for something else to happen.
http://www.miniusa.com : Type ‘reverse’ in the search field and then hold down Shift and click on the gear lever.

There are many internet sites about, for example here.

Stay tuned.

cron4j - Java cron scheduler like unix/linux cron utility

Hi all

Today i want to speak about an open source java library called "cron4j".
It's an Italian open source project, that allows scheduled tasks using a cron-like syntax in java.

There is a good manual here that explains how to implement it with examples.

Here is a little explanation of unix/linux cron utility.

Stay tuned

Regular Expression

Hi all

Today i want speak about "Regular Expression".

As well described on Wikipedia : "In computing, a regular expression is a specific pattern that provides concise and flexible means to "match" (specify and recognize) strings of text, such as particular characters, words, or patterns of characters."

A good reference site for "Regular Expression" is http://www.regular-expressions.info/, there are presents examples, references, books, etc ....


Behind my desk I posted this Quick Guide really useful, above posted :

To test my regular expression i use a good web site : http://tools.netshiftmedia.com/regexlibrary/#, is a javascript regular expression validator that permits insert two test strings.

Regular expression are been inserted in Oracle Database from 10th version with four functions :

• REGEXP_LIKE
• REGEXP_INSTR
• REGEXP_REPLACE
• REGEXP_SUBSTR

Here you can find more information about.

It's all.

Stay tuned.

Oracle OCI C - Wrapper OCILIB

Hi all

Today i want report a great open source project.
I've used and improved it for several years in many personal and professional processes.

For me is the best Oracle OCI C wrapper, easy to use and with a very good documentation.

I test it on several environment : HP/UX PaRisc, Itanium, Linux, Windows XP,7 and with differents ORACLE DB versions : 9,10,11.

I recommend it, you can find it in this link.

Stay tuned

Open Source Blogging Platform

Hi all

Today i want speak about an Open Source Blogging Platform named Bloglooks used in my friend blog http://blog.casaricci.it/.

It is a very very light and minimal Platform built on the PHP framework Yii.

It  use as backend any database supported by Yii .
For style is used Bootstrap.

Main functions :

* Multilingual (Also on articles and pages)
* Manual change language (Browser's default language)
* User privileges (User, editor, admin)
* Comments (Only by registered users; possibility of approvation by editor or admin)
* Integration with Google+ for pictures
* Markdown syntax
* RSS and Atom feeds

Stay tuned.