ricramblings.blogspot.com

Ric Ramblings

Tuesday, July 14, 2015. PL/SQL INLINE fauture, has some limits. Check out this post about inlining of code, inspired by me. Http:/ stevenfeuersteinonplsql.blogspot.com/2015/07/inline-your-subprograms-but-only-within.html. Just don't call me Sheldon. :-). Thursday, June 4, 2015. I'm here to teach, are you here to learn? I teach for a living. I’m not a teacher, I see myself as an instructor, but saying “I instruct for a living” sounds rather odd. The difference mostly is in duration. I love what I do.

http://ricramblings.blogspot.com/

OVERVIEW OF ricramblings.blogspot.com

TRAFFIC RANK

>1,000,000

REVIEWS

0

PAGES IN THIS WEBSITE

19

LINKS TO THIS WEBSITE

CONTACTS

ADDRESSES

SOCIAL LINKS

ONLINE SINCE

WEBSITE DETAILS

SEO

PAGES

SIMILAR SITES

TRAFFIC RANK FOR RICRAMBLINGS.BLOGSPOT.COM

TODAY'S RATING

>1,000,000

TRAFFIC RANK - AVERAGE PER MONTH

BEST MONTH

May

AVERAGE PER DAY Of THE WEEK

HIGHEST TRAFFIC ON

Thursday

TRAFFIC BY CITY

Sign up

CUSTOMER REVIEWS

Average Rating: 3.1 out of 5 with 8 reviews

5 star

1

4 star

3

3 star

2

2 star

0

1 star

2

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

AVERAGE USER RATING

Write a Review

WEBSITE PREVIEW

LOAD TIME

0.5 seconds

FAVICON PREVIEW

16x16
32x32
64x64
128x128

CONTACTS AT RICRAMBLINGS.BLOGSPOT.COM

ADD CONTACT

Login

TO VIEW CONTACTS

Remove Contacts

FOR PRIVACY ISSUES

CONTENT

PAGES IN
THIS WEBSITE

19

SSL

EXTERNAL LINKS

15

SITE IP

216.58.219.193

LOAD TIME

0.531 sec

SCORE

6.2

PAGE TITLE

Ric Ramblings | ricramblings.blogspot.com Reviews

<META> DESCRIPTION

Tuesday, July 14, 2015. PL/SQL INLINE fauture, has some limits. Check out this post about inlining of code, inspired by me. Http:/ stevenfeuersteinonplsql.blogspot.com/2015/07/inline-your-subprograms-but-only-within.html. Just don't call me Sheldon. :-). Thursday, June 4, 2015. I'm here to teach, are you here to learn? I teach for a living. I’m not a teacher, I see myself as an instructor, but saying “I instruct for a living” sounds rather odd. The difference mostly is in duration. I love what I do.

<META> KEYWORDS

1 skip to main

2 skip to sidebar

3 excellent stuff

4 posted by

5 ric van dyke

6 no comments

7 i really do

8 while

9 i'm an ace

10 thanks

CONTENT

Page content here

KEYWORDS ON PAGE

skip to main,skip to sidebar,excellent stuff,posted by,ric van dyke,no comments,i really do,while,i'm an ace,thanks,example,exmple,set termout on,set tab off,set verify off,set serveroutput on,declare,v clob,clob;,begin,loop,end loop;,v sqlid,v sqlhash =

SERVER

GSE

CONTENT-TYPE

utf-8

GOOGLE PREVIEW

Ric Ramblings | ricramblings.blogspot.com Reviews

https://ricramblings.blogspot.com

Tuesday, July 14, 2015. PL/SQL INLINE fauture, has some limits. Check out this post about inlining of code, inspired by me. Http:/ stevenfeuersteinonplsql.blogspot.com/2015/07/inline-your-subprograms-but-only-within.html. Just don't call me Sheldon. :-). Thursday, June 4, 2015. I'm here to teach, are you here to learn? I teach for a living. I’m not a teacher, I see myself as an instructor, but saying “I instruct for a living” sounds rather odd. The difference mostly is in duration. I love what I do.

INTERNAL PAGES

ricramblings.blogspot.com

1

Ric Ramblings: I'm an ACE!

http://ricramblings.blogspot.com/2015/05/im-ace.html

Sunday, May 24, 2015. BIG thanks to Tim Gorman and everyone who submitted an endorsement for me. I very much appreciate being recognized for my years of working with Oracle and my active support of the Oracle community. Let's keep on rockin! Subscribe to: Post Comments (Atom). Ric's Alumni Links (Webinars and more). Getting the Execution Plan. Journey to the center of the database. Laura from OTN interviewing me at Symposium 2016. Classes with Ric from Hotsos. Working with SQL Plan Directives.

2

Ric Ramblings: February 2014

http://ricramblings.blogspot.com/2014_02_01_archive.html

Monday, February 24, 2014. PL/SQL and formating of SQL text. What does the PL/SQL engine do with the SQL in a block? It does some pretty cool things actually. It coverts the entire statement to upper case, except for quoted strings of course, and it strips out all white space down to a single space. So carriage returns, line feeds, tabs and such all become a single space. Also comments are removed, but not HINTS. SQL exec dbms application info.set module('PLSQL','LOWER');. 2 cnt number;. 2 CNT NUMBER;.

3

Ric Ramblings: June 2015

http://ricramblings.blogspot.com/2015_06_01_archive.html

Thursday, June 4, 2015. I'm here to teach, are you here to learn? I teach for a living. I’m not a teacher, I see myself as an instructor, but saying “I instruct for a living” sounds rather odd. The difference mostly is in duration. I only have a class for a couple of days and I don’t give any tests or grades. My goal is to impart knowledge to folks so they are better at their jobs. And I take my job very seriously. I spend hours making sure the content is correct and up to date. I love what I do. Ask the...

4

Ric Ramblings: March 2014

http://ricramblings.blogspot.com/2014_03_01_archive.html

Sunday, March 30, 2014. To BIND or not to BIND. CURSOR SHARING. CURSOR SHARING is a parameter that controls what does the Oracle Optimizer do with literal values in a SQL statement. The default setting is EXACT which I personal think is the best. This doesn't change literals and its up to the coder to put in either literals or binds as needed in the code. A common setting is FORCE which forces the replacement of binds with literals. SQL set lines 200. SQL column SQL TEXT format a85. SQL set feedback on.

5

Ric Ramblings: September 2014

http://ricramblings.blogspot.com/2014_09_01_archive.html

Thursday, September 18, 2014. Fun with your WITH! Here’s a new feature that might have slipped under the radar for you with 12c. You can now have PL/SQL functions defined in the WITH clause. First off this brings some cool functionality to your select statements, but even cooler is that your statement will run faster, a lot faster potential. Here’s a simple test to show this. The ORD9 table has 103,120 rows in 1,390 blocks. Create or replace function rtn date convert (p unix gmt in number). RETURN v date;.

UPGRADE TO PREMIUM TO VIEW 14 MORE

TOTAL PAGES IN THIS WEBSITE

19

LINKS TO THIS WEBSITE

hotsos.com

Welcome to Hotsos

https://www.hotsos.com/developers.html

How We're Different. Why You Need Hotsos. How We're Different. Advanced Optimizer Concepts and Performance (3-Days). Intro to Oracle SQL (2-Days). Optimizing Oracle SQL, Intensive (5-Days). Performance Optimization for Developers, SQL Only (2-Days). Performance Optimization for Developers, SQL PL/SQL (3-Days). Reading Execution Plans (1-Day). Understanding Stats in Oracle (1 Day). Is new 12c functionality being used? Is Your Foundation Solid? A Round Peg in a Square Hole. Too Much of a Good Thing.

hotsos.com

Welcome to Hotsos

https://www.hotsos.com/dbas.html

How We're Different. Why You Need Hotsos. How We're Different. Advanced Optimizer Concepts and Performance (3-Days). Intro to Oracle SQL (2-Days). Optimizing Oracle SQL, Intensive (5-Days). Performance Optimization for Developers, SQL Only (2-Days). Performance Optimization for Developers, SQL PL/SQL (3-Days). Reading Execution Plans (1-Day). Understanding Stats in Oracle (1 Day). Is new 12c functionality being used? Is Your Foundation Solid? A Round Peg in a Square Hole. Too Much of a Good Thing.

rickminutella.blogspot.com

Rick Minutella: Begin Blogging ...

http://rickminutella.blogspot.com/2009/03/i-have-been-thinking-for-quite-while.html

Tales from the Oracle Performance Trenches. Monday, March 16, 2009. Subscribe to: Post Comments (Atom). I have worked at Hotsos Enterprises, Ltd. since 2003. Prior work includes Oracle Corporation from 1988 to 2003 and Raytheon Company from 1984 to 1988. View my complete profile. Some of My Favorite Oracle Performance Sayings. Two ways to improve performance, do it less or do it faster. The fastest way to do something is don't do it. Don't guess, get the data. Vote for your favorite:.

rickminutella.blogspot.com

Rick Minutella: Tuning is a Team Sport

http://rickminutella.blogspot.com/2009/05/tuning-is-team-sport.html

Tales from the Oracle Performance Trenches. Tuesday, May 12, 2009. Tuning is a Team Sport. SELECT TO CHAR(MIN(access event date),'MM/DD/YY') as first event,. TO CHAR(COUNT(*), '999,999,999,999') as page hits. FROM abc access events. WHERE page url = :this url. Note: this url was being passed '/employee/abc/' in my transaction. White Paper When to Use an Index. Table Owner : ABC. Table Name : abc access events. Column List : page url. Table Blocks Below HWM Table Rows. 50,004 9,739,865. Project-status/one...

hotsos.com

Welcome to Hotsos

https://www.hotsos.com/sym12/sym_speakers_nikolaev.html

How We're Different. Why You Need Hotsos. How We're Different. Advanced Optimizer Concepts and Performance (3-Days). Intro to Oracle SQL (2-Days). Optimizing Oracle SQL, Intensive (5-Days). Performance Optimization for Developers, SQL Only (2-Days). Performance Optimization for Developers, SQL PL/SQL (3-Days). Reading Execution Plans (1-Day). Understanding Stats in Oracle (1 Day). Is new 12c functionality being used? Is Your Foundation Solid? A Round Peg in a Square Hole. Too Much of a Good Thing.

hotsos.com

Welcome to Hotsos

https://www.hotsos.com/sym11/sym_speakers_hendriksen.html

How We're Different. Why You Need Hotsos. How We're Different. Advanced Optimizer Concepts and Performance (3-Days). Intro to Oracle SQL (2-Days). Optimizing Oracle SQL, Intensive (5-Days). Performance Optimization for Developers, SQL Only (2-Days). Performance Optimization for Developers, SQL PL/SQL (3-Days). Reading Execution Plans (1-Day). Understanding Stats in Oracle (1 Day). Is new 12c functionality being used? Is Your Foundation Solid? A Round Peg in a Square Hole. Too Much of a Good Thing.

hotsos.com

Welcome to Hotsos

https://www.hotsos.com/media/HotsosOverview

How We're Different. Why You Need Hotsos. How We're Different. Advanced Optimizer Concepts and Performance (3-Days). Intro to Oracle SQL (2-Days). Optimizing Oracle SQL, Intensive (5-Days). Performance Optimization for Developers, SQL Only (2-Days). Performance Optimization for Developers, SQL PL/SQL (3-Days). Reading Execution Plans (1-Day). Understanding Stats in Oracle (1 Day). Is new 12c functionality being used? Is Your Foundation Solid? A Round Peg in a Square Hole. Too Much of a Good Thing.

rickminutella.blogspot.com

Rick Minutella: 007 Secret Agent (a.k.a. 10046 Tracing)

http://rickminutella.blogspot.com/2009/03/whenever-i-speak-of-oracle-10046.html

Tales from the Oracle Performance Trenches. Wednesday, March 18, 2009. 007 Secret Agent (a.k.a. 10046 Tracing). Whenever I speak of Oracle 10046 tracing, I usually say "10 0 46", probably because that is the way others I work with like, Cary Millsap and all of the Hotsos folks, say it. However, during the 2009 Hotsos Symposium. All this writing about 10046 is making me kind of thirsty. Maybe I'll have a Vodka Martini - shaken not stirred. Now if only I can get one of those cool Aston Martin's. I think I'...

rickminutella.blogspot.com

Rick Minutella: Hotsos Symposium Time Again

http://rickminutella.blogspot.com/2010/02/hotsos-symposium-time-again.html

Tales from the Oracle Performance Trenches. Friday, February 19, 2010. Hotsos Symposium Time Again. Again approaching that time of year for the Hotsos Symposium. This will be the eighth year for this grand event which uniquely brings together many of the top Oracle performance experts for 3-4 full days of sessions and networking. For those who don't know, it is March 7 - 11, 2010 in Dallas, TX at the Omni Mandalay Hotel. Keynote Speaker), Tanel Poder. So, I hope to see you at the Hotsos Symposium this ye...

UPGRADE TO PREMIUM TO VIEW 6 MORE

TOTAL LINKS TO THIS WEBSITE

15

OTHER SITES

ricrags.com

Ric Rags - Writer, Voice Actor, and Weight Loss Activist

Writer, Voice Actor, and Weight Loss Activist. I’ve done some really interesting voice over projects recently that have gotten me hooked on the art of voice acting. I have a pretty flexible voice and can do a range of characters and styles. Like anything, voice acting requires time, practice, and heart. I think this is why I love it. Ric Rags Live on YouTube.

ricrahk1.bandcamp.com

RicRahk

Includes high-quality download in MP3, FLAC and more. Paying supporters also get unlimited streaming via the free Bandcamp app. RicRahk drops his new single OnMyBack, a track about using his lyrical skills to put his hometown , Perris CA, on the map. Facebook : www.facebook.com/ricky.r.green. Released 08 December 2013. Produced by and Featuring Yung Miss ( @YungMiss). Feed for this artist. Switch to mobile view.

ricrakcapasse.skyrock.com

Blog de ricrakcapasse - Blog de ricrakcapasse - Skyrock.com

Mot de passe :. J'ai oublié mon mot de passe. Mise à jour :. Abonne-toi à mon blog! Les admiaraeur et trices. Ici c'est ricrack land! On va découvrir le monde du rallye. N'oublie pas que les propos injurieux, racistes, etc. sont interdits par les conditions générales d'utilisation de Skyrock et que tu peux être identifié par ton adresse internet (67.219.144.114) si quelqu'un porte plainte. Ou poster avec :. Posté le lundi 29 septembre 2008 18:09. Modifié le mercredi 26 novembre 2008 12:03. Retape dans le...

ricrallye.com

Accueil

Aller au contenu principal. Les camions de course. Les voitures de course. Les véhicules d’assistance. Les camions d’assistance. Les voitures d’assistance. Pilotage camions et voitures. Initiation à la mécanique. A propos de Ric Rallye. Bonjour et bienvenue sur RIC Rallye,. RIC Rallye vous accompagne dans vos projets, vous proposant des véhicules d’assistance et de course (camions et voitures). N’hésitez pas a nous contacter. Pour des prestations sur mesure. Voir toute la galerie. Mai 20th, 2014.

ricram2000.com

diseño web R I C R A M

Podríamos contarle muchas cosas, pero mejor analize algunas de nuestras propuestas y que nuestra filosofía es constante superación. Si tiene algún comentario o duda sobre nuestro servicio, le agradecemos nos envíe sus datos en el siguiente formulario. Y en cuanto nos sea posible, nos contactamos con usted. Si desea adjuntar Archivos:. MUCHAS GRACIAS, estamos a sus órdenes.

ricramblings.blogspot.com

Ric Ramblings

Tuesday, July 14, 2015. PL/SQL INLINE fauture, has some limits. Check out this post about inlining of code, inspired by me. Http:/ stevenfeuersteinonplsql.blogspot.com/2015/07/inline-your-subprograms-but-only-within.html. Just don't call me Sheldon. :-). Thursday, June 4, 2015. I'm here to teach, are you here to learn? I teach for a living. I’m not a teacher, I see myself as an instructor, but saying “I instruct for a living” sounds rather odd. The difference mostly is in duration. I love what I do.

ricramirez.com

Ric Ramirez - Ric Ramirez Photography

ricramirez.tumblr.com

Sin título

ricramrules.com

Richard's Portfolio

Crisp Responsive HTML Retina Ready Bootstrap Goodness. Web UX and Graphic Designer. Resume and Business Card. The Word on the Street. Your brand or your name is simply your reputation, you have to fight in life to protect that as it means everything. Nothing is more important. The only way you can find a good answer is to clearly understand the question. You can't find the answer by using somebody else's answer to another question. March 29, 2015.

ricranes.com

Imperatore Crane - Serving New England for over 50 years

Cranston, Rhode Island 02920. New Web site in development - Come back soon! Web site development by Karen Martin Media Services.

ricrant.blogspot.com

Ric's Rants

I guess this is just another way to share observations and experiences with anyone who might find them interesting. I don't claim to have any unique insights about the world and I don't want this to become another time sink, but now and then I'll have something to say. Friday, February 4, 2011. Preliminary Lessons from Egypt. What has this to do with us? What are we to do? How are we to effect change from far away without any standing in this fight? Do you think it can't happen here? If you do, why?