35+ Oracle Subdomains You May Not Know About

Here is a list of public Oracle.com subdomains that I know about. In no specific order:

Do you know an Oracle.com subdomain that is not listed above? Feel free to share it with us.

Update: Thanks to Colin for letting us know about this query which gives us more than 100 subdomains.

Filed in Links with 9 Comments | Tags: Links

16 Links to Help You Learn And Use Regular Expressions

Regular expressions can save you hours or even days of work in some cases. For anyone not yet familiar with regular expressions, I definitely recommend to get to know at least the basics. That’s what Tanel Poder advised his readers and I agree with him. To that end, here is a list of resources (in no specific order) that will help you and me understand and learn regular expressions:

The Regex Coach – interactive regular expressions: A graphical application for Windows which can be used to experiment with (Perl-compatible) regular expressions interactively.
RexV.org: This site is a regular expression evaluator for three different regular expression systems, PHP PCRE, PHP Posix and Javascript.
Regular-expressions.info: On this site, you can find a quick start guide, tutorials, references and ready-to-use regular expression examples.
Quick Reference Guide: Regular expressions cheat sheet (PDF).
Know your regular expressions: Essential aids in building and testing regular expressions on UNIX systems.
The absolute bare minimum every programmer should know about regular expressions.
Learning Regular Expressions: Video tutorial.

And here is a list of Oracle related regular expressions links:

Understand Oracle 10g SQL Regular Expression support: The Oracle database has built-in regular expressions built upon the POSIX standard.
Writing Better SQL Using Regular Expressions: The regular expressions feature in Oracle Database 10g is a powerful tool for manipulating textual data.
Using Regular Expressions in Oracle Database: This chapter from the Oracle Database Application Developer’s Guide introduces regular expression support for Oracle Database.
Multilingual Regular Expression Syntax: Lists the full set of operators defined in the POSIX standard that Oracle follows.
Regular Expression Operator Multilingual Enhancements: Oracle’s implementation of the POSIX operators extends beyond the matching capabilities specified in the POSIX standard.
REGEXP_INSTR: Extends the functionality of the INSTR function by letting you search a string for a regular expression pattern.
REGEXP_SUBSTR: Extends the functionality of the SUBSTR function by letting you search a string for a regular expression pattern.
REGEXP_REPLACE: Extends the functionality of the REPLACE function by letting you search a string for a regular expression pattern.
REGEXP_LIKE: It is similar to the LIKE condition, except REGEXP_LIKE performs regular expression matching instead of the simple pattern matching performed by LIKE.

Note that Oracle regular expressions support started with the Oracle database version 10gR1 and above.

Filed in Links with 4 Comments | Tags: Links, regular-expression

Have You Heard of Tumblelogs?

I’m not a big fan of blogrolls. A blogroll is a collection of links to other blogs. I believe what’s more interesting and useful is to have a a collection of links to other blog posts and web pages, or a linkblog. Some bloggers use the shared items in Google Reader as their linkblog. Robert Scoble uses this approach for his famous linkblog.

But even a linkblog can be limiting. What if you want to blog not only links, but also photos, quotes, dialogues and video, quickly and easily. Well, there is a special type of blog, called tumblelog, that does exactly that. Unlike blogs, there is no commenting on tumblelogs.

I like this tumblelog idea. So I set up one, Eddie Awad Randomized (feed). I’ll be posting interesting, educational, useful or just plain fun tumbles, Oracle and non-Oracle related. I also set it up to to automatically import my shared items in Google Reader. But unlike Google Reader’s shared items, I can search my tumblelog using any known blog search service.

Eddie Awad Randomized is powered by tumblr, a free and extremely easy online tool for creating tumblelogs.

Note: I’m writing this blog post using Windows Live Writer, I like it.

Filed in Links, Oracle, Technology with 5 Comments | Tags: blog, Links

5 Links from Around the Web (2007-05-25)

1 – SQL Injections: How Not To Get Stuck

SQL injection is one of the most common security vulnerabilities for web applications today. This article shows ways to solve the problem, including a new technique called “Disabling Literals”, and lists new attacks.
2 – PL/SQL Interface Generator

Oracle PL/SQL Code Generator for Table Encapsulation that would handle all DML operations. It would generate production level code for a table that could be incorporated in any application.
3 – Code Generation: Declaring War on Deja Code

One way to avoid “deja code”, that feeling you’d written this algorithm before, is to generate code rather than write it manually.
4 – Business Logic: To Store or not to Store, that is the Question

Choice between stored procedures, functions, views, triggers and Inline SQL.
5 – Database Design Basics

Database design is more art than science. An excerpt from Professional Oracle Programming.

5 Links from Around the Web (2007-05-04)

1 – Oracle 10g Security: Fine-Grained Auditing

This article demonstrates how to implement FGA in Oracle 10g and illustrates how to take advantage of the newest Oracle 10g Release 2 (10gR2) FGA features.
2 – Hammerora – The Open Source Oracle Load Test Tool

Multi-user Oracle database load testing, HTML and web load testing, pre-bullt workloads and Oracle trace replay and no license Fees, 100% open source.
3 – Don’t Let Referential Integrity Degrade Your Database Performance

Foreign key (FK) constraints without supporting indexes can cause severe performance problems during SQL queries and massive DML (Data Manipulation Language) operations, such as DELETEs or UPDATEs.
4 – Trees in SQL: Nested Sets and Materialized Path

This article investigates two approaches to modeling a tree in the database, materialized path and nested sets.
5 – Primary Keys: IDs versus GUIDs

GUID primary keys are a natural fit for many development scenarios, such as replication, or when you need to generate primary keys outside the database.

More from my bookmarks on del.icio.us…