oracle-wtf.blogspot.com
Oracle WTFEvery three years or so, I like to post something mildly amusing for no real reason.
http://oracle-wtf.blogspot.com/
Every three years or so, I like to post something mildly amusing for no real reason.
http://oracle-wtf.blogspot.com/
TODAY'S RATING
>1,000,000
Date Range
HIGHEST TRAFFIC ON
Saturday
LOAD TIME
0.4 seconds
16x16
32x32
PAGES IN
THIS WEBSITE
15
SSL
EXTERNAL LINKS
173
SITE IP
172.217.11.33
LOAD TIME
0.359 sec
SCORE
6.2
Oracle WTF | oracle-wtf.blogspot.com Reviews
https://oracle-wtf.blogspot.com
Every three years or so, I like to post something mildly amusing for no real reason.
oracle-wtf.blogspot.com
Oracle WTF: The Girl With The ANSI Tattoo
http://oracle-wtf.blogspot.com/2012/05/girl-with-ansi-tattoo.html
Wednesday, May 23, 2012. The Girl With The ANSI Tattoo. I enjoyed the David Fincher remake. Of The Girl With The Dragon Tattoo. More than I thought I would. Rather than a shallow and cynical Hollywood cash-in, it's actually a tense, atmospheric, only slightly voyeuristic crime thriller. My favourite part, though, was when Lisbeth Salander begins to solve a 40 year old murder cold case using SQL. Naturally I couldn't help stitching a few screenshots together in Photoshop, and this is what I got:. Also it ...
Oracle WTF: Looping the hard way
http://oracle-wtf.blogspot.com/2014/01/looping-hard-way.html
Sunday, January 05, 2014. Looping the hard way. The task was to construct partition names from 'P001' to (for some reason) 'P336', as part of a larger maintenance script. Here's what they came up with:. Declare p varchar2(4); i number := 1; begin loop if i. 336; dbms output.put line(p); end loop; end;. Posted by William Robertson. You expect DBAs to be conversant in using LPAD? January 27, 2014 12:39 pm. Subscribe to: Post Comments (Atom). Mail us your WTFs. Google definitions for "WTF".
Oracle WTF: Concatenation, Concatenation, Concatenation
http://oracle-wtf.blogspot.com/2011/03/concatenation-concatenation.html
Saturday, March 26, 2011. Concatenation, Concatenation, Concatenation. I'm still not sure what this one does, but you have to be impressed by 11 nested CONCATs. And by the way, you also have to be impressed by the inventor of the. Function who evidently considered two arguments sufficient, unlike, say. Who knows what goes through these people's heads.). Thanks BB for this one, which she or he (I can't say more for witness protection reasons) sent me a while ago and I almost forgot about. Could have had m...
Oracle WTF: How to Merge a Row
http://oracle-wtf.blogspot.com/2012/05/how-to-merge-row.html
Saturday, May 19, 2012. How to Merge a Row. The tough challenge that seems to have been faced by this developer was that the ID, name and value passed into the procedure needed to be either applied as an update if the name existed, or else inserted as a new row. You might think you could just use MERGE. Or maybe attempt the update, capturing the ID value with a RETURNING clause, then if that found no rows insert a new row using. For the ID. But wait, that wouldn't be complicated enough, would it? The nam...
Oracle WTF: Create Your Own DUAL Table
http://oracle-wtf.blogspot.com/2006/03/create-your-own-dual-table.html
Tuesday, March 07, 2006. Create Your Own DUAL Table. If you want to retrieve a sequence value into a PL/SQL variable, you have to SELECT FROM DUAL. (Or use RETURNING INTO of course, but never mind that now.). According to some, this is not only an inconvenient restriction, but also prone to failure if SYS.DUAL contains more than one row. Posted by William Robertson. Well at least we can rest assured that that. Table can't get corrupted. Oh, hang on a minute. SQL delete onerow;. SQL select * from onerow;.
TOTAL PAGES IN THIS WEBSITE
15
miscellaneous — Oratable
http://www.oratable.com/category/miscellaneous
I want to learn Oracle. Where should I begin? Here is a simple guide to learning Oracle as a developer from scratch, on your own. For an absolute beginner to Oracle, it helps you navigate your way around the sea of information available at your disposal. Read the Full Article. ORA-01450: Maximum Key Length Exceeded – Possible Causes and Fix. I want to learn Oracle. Where should I begin? What are CBO and RBO? UTL HTTP to Call a Web Service from PL/SQL. The Difference Between DECODE and CASE.
The Magic Shed – munky on oracle
https://munkyben.wordpress.com/2013/03/14/the-magic-shed
March 14, 2013. March 14, 2013. In keeping with my last post, this is another ‘back to basic’s kind of thing. It’s basically a small metaphor of why we should use constraints, datatypes and other normal database design fundamentals when storing data and is aimed either at the complete newbie to database design or as a handy explanation to your Excel loving business users for more experienced developers…. The first weekend she carefully placed her pots on one shelf, her compost bags in one corner, her too...
Lisa Dobson's blog for all things Oracle... | Page 2
https://lisadobson.wordpress.com/page/2
Lisa Dobson's blog for all things Oracle…. UKOUG Inspiring Presentation Awards The Winners. December 3, 2010. This is the Conference Review Part 2, but I wanted to do a separate post for the IPA’s. On Tuesday night at the conference, we had the first ever UKOUG Inspiring Presentation Awards. The awards and the evening’s social event were very kindly sponsored by OTN. So a big thank you to Vikki Lira from the Oracle ACE Program. For helping out and making it all happen. Technology – John Scott. UK Apps Ma...
Exciting changes at UKOUG! | Lisa Dobson's blog for all things Oracle...
https://lisadobson.wordpress.com/2011/03/21/exciting-changes-at-ukoug
Lisa Dobson's blog for all things Oracle…. UKOUG Director Elections – Please Vote! My new blog… →. Exciting changes at UKOUG! March 21, 2011. First of all, a big Thank you to everyone who voted to keep me on the Board of Directors. I’m very grateful for all of the support and very pleased to be able to continue as a Director. We had our first Board meeting on Thursday and were able to welcome two new Directors to the Board, Jeremy Duggan and Robert Stanton. Elections were held and Debra Lilley. It’s goin...
dba_free_space query slow | ur is not a word
https://urisnotaword.wordpress.com/2014/09/30/dba_free_space-query-slow
Ur is not a word. Another scratchpad of Oracle notes. Laquo; checking used cursor counts. Empty tablespace. datafiles won’t resize ORA-03297. Dba free space query slow. September 30, 2014 by urisnotaword. We run regular queries against dba data files and dba free space to check tablespace growth/available space. they seem to have been running fine until seemingly out of nowhere, this query began to timeout on our monitoring setup. Select a.tablespace name tbs. NVL(bfree,0.0) free. Enter your comment here.
empty tablespace. datafiles won’t resize ORA-03297 | ur is not a word
https://urisnotaword.wordpress.com/2015/04/09/empty-tablespace-datafiles-wont-resize-ora-03297
Ur is not a word. Another scratchpad of Oracle notes. Laquo; dba free space query slow. Empty tablespace. datafiles won’t resize ORA-03297. April 9, 2015 by urisnotaword. The short history is that we have a tablespace that was filled with 150G. Doing some cleaning and relocating shrunk this down to what should be zero. In reality, the tablespace could be dropped as it is no longer in use, but we’ll be using it again soon so I just wanted to reclaim a large portion of space. ERROR at line 1:. Fill in your...
Oracle S.O.P | Amat Victroria Curam | Page 2
https://oraclesop.wordpress.com/page/2
Oracle S.O.P. Skip to primary content. Skip to secondary content. Newer posts →. Here’s how to extract the sql commands to recreate any tablespace. Useful when creating a partial database copy. You can modify the query to only get a specific set of tablespaces you need. Set heading off set echo off set pages 999 set long 90000 spool ddl tablespaces.sql select dbms metadata.get ddl('TABLESPACE',tb.tablespace name) from dba tablespaces tb;. Registering with the listener. ALTER SYSTEM REGISTER;. Gzip -c tes...
samygejz | Oracle S.O.P
https://oraclesop.wordpress.com/author/samygejz
Oracle S.O.P. Skip to primary content. Skip to secondary content. In this article, I’ll demonstrate multiple solutions to move datafiles. Method 1: using symbolic links. Stop the Mysql instance. Then move the files and put symbolic links to lure Mysql into thinking the files are still in place. Mkdir /new dir/datafiles/my db. Cp -Rvp my db/* /new dir/datafiles/my db/. Rm my db/* & rmdir my db/. Ln -s /new dir/datafiles/my db/ my db. Method 2: changing the configuration file. The Incorrect key file error:.
TOTAL LINKS TO THIS WEBSITE
173
Заглавная страница — OracleWiki
Declaration of LanguageRu: getMagicWords() should be compatible with and Language: getMagicWords() in /home/bc/sites/oracle-wiki.ru/www/languages/LanguageRu.php. Non-static method MagicWord: get() should not be called statically, assuming $this from incompatible context in /home/bc/sites/oracle-wiki.ru/www/includes/Parser.php. Non-static method MagicWord: get() should not be called statically, assuming $this from incompatible context in /home/bc/sites/oracle-wiki.ru/www/includes/Parser.php. Non-static me...
Home
Oracle Wisdom has been established by experienced mediums and oracle readers Michael and Trisha, to help people with the problems of this life, and to support and assist you in your communication with and work with spirit. Click on one of the boxes here, to be taken to the web page dealing with our use of oracles, such as Tarot, mediumship, healing, and past life regression. Come with us to begin your journey.
oracle-with-dotnet.blogspot.com
.NET alkalmazás fejlesztése Oracle DB-hez
A tématársammal ( http:/ oracleondotnet.blogspot.com/. Tóth Lászlóval közösen készített féléves beszámolónk az alábbi linken érhető el:. Http:/ web.pr.hu/tlaci515/oracle lab.pdf. A szakirodalom tanulmányozását követően az általam kifejtendő kulcs-technonológiákról készítettem ezt a kis összefoglalót:. Az ODP.NET egy natív .NET adathozzáférési driver az Oracle adatbázishoz, mely más .NET driver-ekhez képest:. Nagyobb teljesítményt nyújt az Oracle adatbázis optimalizált elérése révén .NET környezetből.
Oracle Woman
Um espaço voltado para as novidades da Oracle, com foco no E-Business Suite. Terça-feira, 24 de janeiro de 2017. Oracle anuncia expansão do programa de aceleração de startups para promover inovação global na nuvem. Oracle dará mentoria e apoio às startups com soluções na nuvem em sete novas cidades na Ásia, Europa, América Latina e Oriente Médio. Redwood Shores, Califórnia — 24 de janeiro de 2017. Oracle anuncia hoje a ampliação do programa. Oracle Startup Cloud Accelerator. A Ricardo Eletro, terceira ma...
Oracle WTF
Every three years or so, I like to post something mildly amusing for no real reason. Saturday, October 14, 2017. Over on Stack Overflow. Has a question about why SQL*Plus doesn't parse every line of a PL/SQL block in case it's a comment in order to avoid unnecessary prompts for substitution variables. Here's his mcve. SQL begin 2 null; - &commented out 3 end; 4 / Enter value for commented out: wtf PL/SQL procedure successfully completed. Oh, wait - it's not that. It's actually this:. Following our exit f...
oracle-x-blackcanary.deviantart.com
Oracle-x-BlackCanary (Barbara x Dinah) | DeviantArt
Window.devicePixelRatio*screen.width 'x' window.devicePixelRatio*screen.height) :(screen.width 'x' screen.height) ; this.removeAttribute('onclick')". Deviant for 7 Years. This deviant's full pageview. This is the place where you can personalize your profile! By moving, adding and personalizing widgets. You can drag and drop to rearrange. You can edit widgets to customize them. The bottom has widgets you can add! Some widgets you can only access when you get Core Membership. Why," you ask? July 4, 2012.
Oracle-X - The Intuitive Tool of the Future
Shop - Oracle-X Cards. How To - Learn and Understand. Spreads - Read and Interpret. FAQ - Common Questions. Each new Oracle-X base deck is unique, it contains a combination of cards not to be found in any other unopened new deck. No two identical base decks have been or will be created. Oracle-X has been designed from the onset to be both customisable and expandable. This allows you, as the owner of your deck, to shape it exactly the way your intuition is guiding you. Visit the Oracle-X Shop.
Oracle-X - The Intuitive Tool of the Future
Shop - Oracle-X Cards. How To - Learn and Understand. Spreads - Read and Interpret. FAQ - Common Questions. Each new Oracle-X base deck is unique, it contains a combination of cards not to be found in any other unopened new deck. No two identical base decks have been or will be created. Oracle-X has been designed from the onset to be both customisable and expandable. This allows you, as the owner of your deck, to shape it exactly the way your intuition is guiding you. Visit the Oracle-X Shop.
