Regular expressions have long been used in the Unix world. With Oracle 10g, they have now entered the SQL toolbox. For those unfamiliar with them, regular expressions can be both complex and confusing, but do bring substantial flexibility to the developer. This presentation attempts to introduce them to the competent SQL user who has no experience with regular expressions, either in 10g, or in the Unix world. It is therefore an introduction to regular expressions, and not a complex review. Rather than simply list their parameters, this presentation will demonstrate, using simple worked examples, how the four types of regular expressions can be used in everyday coding situations. It will show how these expressions are built on the existing and familiar SQL character functions, and will explain in detail each of the various parameters associated with the four regular expressions.
This presentation will go on to introduce two additional techniques which will allow you to get extra value from the regular expressions that you build. First, SQL scripts will be introduced which, by prompting the user, will dynamically build up regular expressions, thus saving the user from having to know the detailed syntax of their construction. Secondly, a method will be presented in which the regular expressions you create can be saved into the database for subsequent use.
All the examples presented will be demonstrated using a live SQL*Plus session during the course of the lecture.
Vrsta: Radionica / Workshop
Razina težine: Vrlo detaljno i stručno / Expert
Poželjno iskustvo slušatelja: Iskusni (2-3 g.) / Experianced
Poželjna funkcija slušatelja:
Sistem Analitičar / System Analist
Developer
Dizajner / Designer
Predviđeno vrijeme trajanja rada - aktivnosti: 90 min min
Pogledati na DVD.pdf 28,56 kB
UK OUG
Qualified as a geologist, then moved into IT in the late 1970’s, immediately specialising in database. Joined the British Geological Survey in 1980; he was the prime mover in having relational database adopted as the corporate data repository. Designed, built and extended the corporate Data Architecture covering multiple instances of Oracle. Built advanced replication software maintaining remote instances synchronous. Strong analytical and design skills combined with an active interest in extending the boundaries of SQL. Has presented at conferences (Oracle and others) all over Europe, the UK, and in North America, and is a Director of the UK Oracle User Group with special responsibility for their Membership.
Peter Robson
http://www.JustSQL.com
Edinburgh
Scotland.