ORATECHINFO.CO.UK
OraTechInfo.co.ukOraTechInfo.co.uk : Oracle Developer and DBA resources
http://oratechinfo.co.uk/
OraTechInfo.co.uk : Oracle Developer and DBA resources
http://oratechinfo.co.uk/
TODAY'S RATING
>1,000,000
Date Range
HIGHEST TRAFFIC ON
Tuesday
LOAD TIME
0.8 seconds
PAGES IN
THIS WEBSITE
18
SSL
EXTERNAL LINKS
22
SITE IP
104.27.147.35
LOAD TIME
0.766 sec
SCORE
6.2
OraTechInfo.co.uk | oratechinfo.co.uk Reviews
https://oratechinfo.co.uk
OraTechInfo.co.uk : Oracle Developer and DBA resources
oratechinfo.co.uk
Useful Metalink Notes
https://oratechinfo.co.uk/metalink_notes.html
No self-respecting Oracle DBA or Developer could live without the most content-rich Oracle resource ever, Oracle Metalink. This is a list of Metalink notes which I personally find / have found extremely useful. Note, you will need an Oracle Metalink account to access these documents. Database / OS / Application performance tuning. Understanding and Tuning Buffer Cache and DBWR. Understanding and Tuning the Shared Pool. How to Remove a Single ORACLE HOME and Its Traces on Microsoft Windows Platforms.
Using NULLs
https://oratechinfo.co.uk/nulls.html
Using NULL in a mathematical expression always returns NULL. Appending NULL to a non-null string does not affect the string. Aggregate functions tend to "ignore" NULLs. GROUP BY treats NULL as a seperate "value". NULL has to be tested using the IS [NOT] NULL clause. Completely NULL values will not be indexed. Default Datatype of NULL is VARCHAR2. NULL is NOT CHR(0)! NULLs affect NOT IN expressions. Rule 3: Systematic Treatment of Null Values. The problem is when you try and use. SQL SELECT a, COUNT(a), C...
Object Relational Features
https://oratechinfo.co.uk/oo.html
Using ORDERED and PUSH SUBQ. Sparse VARRAY (or not). Collections are data structures of a similar nature to arrays in other languages (and indeed they are best used in the same manner). Associative Arrays (INDEX BY tables). INDEX BY tables are collections and can only be declared within a PL/SQL environment. They are recognised by the use of INDEX BY [ BINARY INTEGER PLS INTEGER VARCHAR2(size) ] after the TYPE declaration. They are utilised by the standard dot-notation syntax, i.e. FOR i IN 1.l tab&#...
SQL tracing
https://oratechinfo.co.uk/tuning.html
Displaying the execution plan. Extended SQL TRACE (event 10046 analysis). This page gives examples of how to analyse a particular SQL process in order to gain a better understanding of how Oracle is executing the process and, hopefully, identifying where any particular performance bottlenecks are occurring. Displaying the execution plan. Script. Typically, this is created as SYS and then a public synonym is created for it, but it can just be created in the necessary schema, if so required. Note, you can ...
Oratechinfo.co.uk : SQL/XML
https://oratechinfo.co.uk/sqlxml.html
Generating XML using SQL/XML. UPDATEXML and XML namespaces. DELETEXML and XML namespaces. Extracting data using SQL/XML (post-11g). The importance of datatype. Flattening the XML structure. Using namespaces in XMLEXISTS. Extracting data using SQL/XML (pre-11g). Extract method of XMLTYPE. SQL/XML and XPath points of note. Limitations of ORDER BY. Generating "NULL" XML Elements. Pretty" printing using XMLSERIALIZE. Part 14 of the SQL:2003 standard). However, you have to be aware that SQL/XML is SQL driven,...
TOTAL PAGES IN THIS WEBSITE
18
Volder's Oracle Notes: Wrong encoding with HTTPURITYPE()
http://volder-notes.blogspot.com/2008/04/wrong-encoding-with-httpuritype.html
Wednesday, April 30, 2008. Wrong encoding with HTTPURITYPE(). Several days ago my colleague asked me - do you have any idea why the following query returns Currency Name in the wrong encoding:. SQL SELECT EXTRACTVALUE(VALUE(P), '/Valute/NumCode') NUMCODE,. 2 EXTRACTVALUE(VALUE(P), '/Valute/CharCode') CHARCODE,. 3 EXTRACTVALUE(VALUE(P), '/Valute/Nominal') NOMINAL,. 4 EXTRACTVALUE(VALUE(P), '/Valute/Name') NAME,. 5 EXTRACTVALUE(VALUE(P), '/Valute/Value') VALUE. Date req=22.03.2008'). 840 USD 1 Aieea? The H...
Volder's Oracle Notes: November 2007
http://volder-notes.blogspot.com/2007_11_01_archive.html
Thursday, November 29, 2007. Regexp 3: number of pattern occurence. In that post I'll talk about a problem, which is very popular, according to the number of posts in forums with similar questions. Usually it is formulated as: "How to count the number of occurences of a substring with special pattern inside the string". Actually, everything we were talking about in two previous posts - can be very useful in solving such a task. Let our input data be the same as in the previous post:. 3 select t.*,. We'll...
Volder's Oracle Notes: Fragments of string between special patterns
http://volder-notes.blogspot.com/2008/03/fragments-of-string-between-special.html
Saturday, March 22, 2008. Fragments of string between special patterns. Although my solution wasn't rated highly on the forum. I decided to put it here :). There is a string value given, comprising a number of elements that are put into particular patterns on both sides. We need to get all such patterns and inside value out of the string. Eg the beginning pattern is '. SQL with t as (select 'xyz testdata 123' col1 from dual union all. 2 select 'zzz test data ssf' from dual union all. 6 select t.*,. But t...
Steve Bamber | Just because something is obvious it doesn't mean it's true
http://thebambers.me.uk/oracle
Oracle RDBMS 12.1.0.1 SE ACL Performance. March 22, 2016. We have come across an issue with Oracle RDBMS 12.1.0.1 Standard Edition (SE) that impacts the performance all requests to external network resource from the database, e.g. calls to webservices. The issue appears to be due to a dependency in the Oracle code on the Result Cache (a feature that is unavailable in SE). There is a simple test case that highlights the problem i.e. The CPU time spent on the internal Oracle routine will also be much lower...
Volder's Oracle Notes: December 2007
http://volder-notes.blogspot.com/2007_12_01_archive.html
Wednesday, December 19, 2007. Reports: getting total of all children values in a tree. Well, actually, this note is a continuation of a model series on reports. So the structure of an article is the same: the problem description - non-model solution - model clause solution. But also this note is very similar to summation of tree values. I've written a little bit earlier. So let's get started. Our input for this post would be a table t. And an additional table t hrchy. SQL drop table t hrchy;. SQL select ...
Volder's Oracle Notes: April 2008
http://volder-notes.blogspot.com/2008_04_01_archive.html
Wednesday, April 30, 2008. Wrong encoding with HTTPURITYPE(). Several days ago my colleague asked me - do you have any idea why the following query returns Currency Name in the wrong encoding:. SQL SELECT EXTRACTVALUE(VALUE(P), '/Valute/NumCode') NUMCODE,. 2 EXTRACTVALUE(VALUE(P), '/Valute/CharCode') CHARCODE,. 3 EXTRACTVALUE(VALUE(P), '/Valute/Nominal') NOMINAL,. 4 EXTRACTVALUE(VALUE(P), '/Valute/Name') NAME,. 5 EXTRACTVALUE(VALUE(P), '/Valute/Value') VALUE. Date req=22.03.2008'). 840 USD 1 Aieea? The H...
BAAG Comrades at BAAG Party – Battle Against Any Guess
http://www.battleagainstanyguess.com/members
BAAG Party – Battle Against Any Guess. Home of the BAAG Party. The Statspack for PostgreSQL — Meet Pgstatspack. SQL Server Performance Diagnostic — Still Guessing? BAAG Members page change. Avoiding Guesswork in Complex Environments. On Avoiding Guesswork in Complex Environments. On Avoiding Guesswork in Complex Environments. On RTFM – stuff you never wanted to know about reading the manual! On BAAG is born. On Avoiding Guesswork in Complex Environments. On Avoiding Guesswork in Complex Environments.
Volder's Oracle Notes: October 2007
http://volder-notes.blogspot.com/2007_10_01_archive.html
Thursday, October 25, 2007. Using collections with 10g features. After a small lull I decided to post some thoughts on collections. Especially those features that were introduced starting from 10g Oracle version. Actually, the legs are growing from that thread. On OTN forum. A lot of solutions were given, and for sure I would use one of them on the OP's place, but I just decided to show how It can be done using collections. Input data (from the forum):. So we have a table:. SQL create table t as. Then we...
Volder's Oracle Notes: March 2008
http://volder-notes.blogspot.com/2008_03_01_archive.html
Saturday, March 22, 2008. Fragments of string between special patterns. Although my solution wasn't rated highly on the forum. I decided to put it here :). There is a string value given, comprising a number of elements that are put into particular patterns on both sides. We need to get all such patterns and inside value out of the string. Eg the beginning pattern is '. SQL with t as (select 'xyz testdata 123' col1 from dual union all. 2 select 'zzz test data ssf' from dual union all. 6 select t.*,. But t...
TOTAL LINKS TO THIS WEBSITE
22
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.
Welcome oratechgroupinc.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.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
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.
Oratech
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
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.
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.
ORA Technologies - Home
Welcome to ORA Technologies. ORA Technologies was created in 2004 to provide innovative products and services to address engineering and environmental issues in the coastal environment while maximizing the ecological benefit. Our first product, the Oysterbreak, was developed to slow coastal erosion while enhancing local ecology. ORA Technologies also has a close relationship to Louisiana State University, where technologies can be transferred to the public and accepted by the academic community.
SOCIAL ENGAGEMENT