ORATECHINFO.BLOGSPOT.COM

Oratechinfo.co.uk

The official blog of the popular Oracle Developer / DBA site. Tuesday, 11 March 2014. Multi-table INSERT and handling of NULL values in the WHEN condition. CREATE TABLE mti test ( a VARCHAR2(10), b VARCHAR2(10) ) / CREATE TABLE temp mc ( a VARCHAR2(100) ) / INSERT INTO mti test (a,b) SELECT 'NUMBER', '1' FROM dual UNION ALL SELECT 'CHAR', 'B' FROM dual /. Now, running the following multi-table insert has no problems :. However, now introduce a row with a NULL value for "a", i.e. :. Thursday, 1 July 2010.

http://oratechinfo.blogspot.com/

OVERVIEW OF oratechinfo.blogspot.com

TRAFFIC RANK

>1,000,000

REVIEWS

0

PAGES IN THIS WEBSITE

15

LINKS TO THIS WEBSITE

CONTACTS

ADDRESSES

SOCIAL LINKS

ONLINE SINCE

WEBSITE DETAILS

SEO

PAGES

SIMILAR SITES

TRAFFIC RANK FOR ORATECHINFO.BLOGSPOT.COM

TODAY'S RATING

>1,000,000

TRAFFIC RANK - AVERAGE PER MONTH

BEST MONTH

August

AVERAGE PER DAY Of THE WEEK

HIGHEST TRAFFIC ON

Friday

TRAFFIC BY CITY

Sign up

CUSTOMER REVIEWS

Average Rating: 3.4 out of 5 with 7 reviews

5 star

2

4 star

1

3 star

3

2 star

0

1 star

1

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

AVERAGE USER RATING

Write a Review

WEBSITE PREVIEW

LOAD TIME

0.8 seconds

FAVICON PREVIEW

16x16
32x32
64x64
128x128

CONTACTS AT ORATECHINFO.BLOGSPOT.COM

ADD CONTACT

Login

TO VIEW CONTACTS

Remove Contacts

FOR PRIVACY ISSUES

CONTENT

PAGES IN
THIS WEBSITE

15

SSL

EXTERNAL LINKS

1

SITE IP

173.194.46.107

LOAD TIME

0.75 sec

SCORE

6.2

PAGE TITLE

Oratechinfo.co.uk | oratechinfo.blogspot.com Reviews

<META> DESCRIPTION

The official blog of the popular Oracle Developer / DBA site. Tuesday, 11 March 2014. Multi-table INSERT and handling of NULL values in the WHEN condition. CREATE TABLE mti test ( a VARCHAR2(10), b VARCHAR2(10) ) / CREATE TABLE temp mc ( a VARCHAR2(100) ) / INSERT INTO mti test (a,b) SELECT 'NUMBER', '1' FROM dual UNION ALL SELECT 'CHAR', 'B' FROM dual /. Now, running the following multi-table insert has no problems :. However, now introduce a row with a NULL value for a, i.e. :. Thursday, 1 July 2010.

<META> KEYWORDS

1 oratechinfo co uk

2 and suddenly

3 posted by

4 chadders

5 no comments

6 new look

7 further tidying

8 local name does

9 labels local name

10 sql/xml

CONTENT

Page content here

KEYWORDS ON PAGE

oratechinfo co uk,and suddenly,posted by,chadders,no comments,new look,further tidying,local name does,labels local name,sql/xml,xpath,labels firing,follows,oracle,sequence,triggers,invisible indexes,about invisible,indexes in 11g,blogged with flock

SERVER

GSE

CONTENT-TYPE

utf-8

GOOGLE PREVIEW

Oratechinfo.co.uk | oratechinfo.blogspot.com Reviews

https://oratechinfo.blogspot.com

The official blog of the popular Oracle Developer / DBA site. Tuesday, 11 March 2014. Multi-table INSERT and handling of NULL values in the WHEN condition. CREATE TABLE mti test ( a VARCHAR2(10), b VARCHAR2(10) ) / CREATE TABLE temp mc ( a VARCHAR2(100) ) / INSERT INTO mti test (a,b) SELECT 'NUMBER', '1' FROM dual UNION ALL SELECT 'CHAR', 'B' FROM dual /. Now, running the following multi-table insert has no problems :. However, now introduce a row with a NULL value for "a", i.e. :. Thursday, 1 July 2010.

INTERNAL PAGES

oratechinfo.blogspot.com

1

Oratechinfo.co.uk: May 2007

http://www.oratechinfo.blogspot.com/2007_05_01_archive.html

The official blog of the popular Oracle Developer / DBA site. Thursday, 24 May 2007. I've significantly tidied up and updated the page on cardinality. Correcting a few things I noticed, but generally expanding on a few things, making it more consistent with the other pages. I've also corrected an erroneous link to the old "gathering stats" page that I removed a while ago, but it was part of the whole tidy up exercise anyway. Monday, 21 May 2007. On SQL TRACE et al. Hopefully, I'll get around to reviewing...

2

Oratechinfo.co.uk: June 2007

http://www.oratechinfo.blogspot.com/2007_06_01_archive.html

The official blog of the popular Oracle Developer / DBA site. Wednesday, 27 June 2007. Changes to collections and delimited lists. Made some changes to the page on creating delimited lists to collections ( and vice versa ), including putting a section on how to create a delimited list using just SQL (via the SYS CONNECT BY PATH function), as well as revisiting the wording on quite a few sections on that page. Subscribe to: Posts (Atom). What's there to say? View my complete profile.

3

Oratechinfo.co.uk: July 2010

http://www.oratechinfo.blogspot.com/2010_07_01_archive.html

The official blog of the popular Oracle Developer / DBA site. Thursday, 1 July 2010. Well I've done the lick of paint I've been promising on the main page now. What do you all think? Subscribe to: Posts (Atom). What's there to say? I'm a fairly active dad of two who likes nothing better than wandering around Heritage sites, watching sci-fi programmes or playing Second Life. Well, there is that Computer Programming lark I do to pay for it all. View my complete profile.

4

Oratechinfo.co.uk: A long time and a tidy up

http://www.oratechinfo.blogspot.com/2008/02/long-time-and-tidy-up.html

The official blog of the popular Oracle Developer / DBA site. Saturday, 2 February 2008. A long time and a tidy up. Well, to say it's been a long time since I did anything on oratechinfo.co.uk would be an understatement. To be perfectly honest, it's been a busy few months with one thing or another, so I simply haven't found the time. Anyway. enough of the excuses. I've also changed the XHTML / CSS and firefox links on the front page, removing the thunderbird. Subscribe to: Post Comments (Atom).

5

Oratechinfo.co.uk: April 2007

http://www.oratechinfo.blogspot.com/2007_04_01_archive.html

The official blog of the popular Oracle Developer / DBA site. Thursday, 26 April 2007. At the same time as putting a link to a great white paper (Alberto Dell'erra's investigations into equi-join cardinality when utilising histograms), I thought it'd be a good idea to actually create a "proper" blog, rather than a static blog like it was before. So, here it is. It also means that people can actually post comments, rather than emailing like was done before. Subscribe to: Posts (Atom). What's there to say?

UPGRADE TO PREMIUM TO VIEW 10 MORE

TOTAL PAGES IN THIS WEBSITE

15

OTHER SITES

oratechblogger.blogspot.com

Send email from Oracle 10g Database Server

Send email from Oracle 10g Database Server. Thursday, September 3, 2009. Includes a new package, the UTL MAIL. You must install UTL MAIL and define the SMTP OUT SERVER. First you must connect to the database as user SYS and run the scripts. Open sqlplus and the command to connect is ‘/ as sysdba’. The package UTL MAIL is loaded by running the following scripts:. SQL @$ORACLE HOME rdbms admin utlmail.sql. SQL @$ORACLE HOME rdbms admin prvtmail.plb. SQL @%ORACLE HOME% RDBMS ADMIN utlmail.sql. You define th...

oratechconsultants.com

YourWebHosting

Web hosting, tools, and services. This site is temporarily unavailable. If you manage this site and have a question about why the site is not available, please contact us directly.

oratechgroupinc.com

Welcome oratechgroupinc.com

oratechie.blogspot.com

OraTechie

An Oracle certified DBA working in Oracle databases and applicaiton under various flavors of UNIX for more than a decade now. Have detailed understanding of Oracle database engine and specific expertise in Oracle Real Application Clusters, Advanced Performance Tuning and High Availability Planning / Disaster Recovery. Monday, February 09, 2009. Oracle CBO - optimizer mode hinted. Links to this post. Saturday, February 07, 2009. How to identify the Oracle EM roles assigned to an Oracle EM user? I have see...

oratechinfo.blogspot.com

Oratechinfo.co.uk

The official blog of the popular Oracle Developer / DBA site. Tuesday, 11 March 2014. Multi-table INSERT and handling of NULL values in the WHEN condition. CREATE TABLE mti test ( a VARCHAR2(10), b VARCHAR2(10) ) / CREATE TABLE temp mc ( a VARCHAR2(100) ) / INSERT INTO mti test (a,b) SELECT 'NUMBER', '1' FROM dual UNION ALL SELECT 'CHAR', 'B' FROM dual /. Now, running the following multi-table insert has no problems :. However, now introduce a row with a NULL value for "a", i.e. :. Thursday, 1 July 2010.

oratechinfo.co.uk

OraTechInfo.co.uk

For Oracle Developers and DBAs. Obtaining the execution path / trace file. Mechanisms for efficiently generating and processing XML from SQL. Utilising XMLTYPE for XML Storage. Using Fine-Grained Access Control. Understanding this database exploit. Using database triggers effectively. Converting from one to the other. The OR features of Oracle RDBMS. Why database views are the best thing since sliced bread. How to utilise this useful feature. How much do you understand about NULL? Follow me on Twitter.

oratechla.com

Oratech

oratechlabs.com

HOME

Full Cast and Composite. Full and Partial Dentures. Roland DWX-50 Milling Machine. 3Shape Scanner Dental System. In Lab Turn Around Times. COMMITTED TO THE UNION OF FORM AND FUNCTION. Please make note of our holiday schedule, and plan case submissions accordingly, as lab closures may impact our normal in-lab production schedule. Please note that unforeseen weather conditions may cause Oratech to close. Thanksgiving and Black Friday. Oratech Laboratories Inc., 2015. info@oratechlabs.com.

oratechnet.com

OraTechNet

A complete array of technology solutions for Oracle. Products, from technical planning to self service web applications. Let us impart years of experience to your team. The best teachers are the people with real world experience. Our highly skilled associates with years of experience provide you with an expert team that can get the job done. We're the right one for you. As experts consulting for the Oracle. Our customers turn to us because we offer them more than mastery of Oracle. We believe in Oracle.

oratechnologies.co.uk

Ora-Technologies | Consulting | Training | Staffing | Remote Services

Ora-Tech helps clients deliver innovation to their customers and improve cost and effectiveness. We provide in-company and public training programmes in UK, Ireland and Belgium. Ora-Tech provides specialist staffing solutions for its UK and European clients since 2004. Every Ora-Tech Managed Services engagement begins with a Ora-Tech technical consultant. We are moving to Reading, Berks. Special weekend course for working professionals for 26th 29th April Register. Data Stewardship 14th 15th June.