kunalshrivastava.blogspot.com

Kunal's Blogs

Thursday, 13 August 2009. Oracle Function to Extract the First , Middle and Last Name from Name Column. The Below Oracle Function can extract the First Name, Middle Name and Last Name from Name Column where these values are seperated by single or multiple spaces. Just Pass the column Name and 1,2,3 to get first, middle and last name from the String. FUNCTION FNC GET NAME(LV NAME VARCHAR2, LV NO NUMBER). POS FIRST SPACE NUMBER(3);. POS SECOND SPACE NUMBER(3);. LA NAME VARCHAR2(150);. IF LV NO = 1 THEN.

http://kunalshrivastava.blogspot.com/

OVERVIEW OF kunalshrivastava.blogspot.com

TRAFFIC RANK

>1,000,000

REVIEWS

0

PAGES IN THIS WEBSITE

9

LINKS TO THIS WEBSITE

CONTACTS

ADDRESSES

SOCIAL LINKS

ONLINE SINCE

WEBSITE DETAILS

SEO

PAGES

SIMILAR SITES

TRAFFIC RANK FOR KUNALSHRIVASTAVA.BLOGSPOT.COM

TODAY'S RATING

>1,000,000

TRAFFIC RANK - AVERAGE PER MONTH

BEST MONTH

March

AVERAGE PER DAY Of THE WEEK

HIGHEST TRAFFIC ON

Tuesday

TRAFFIC BY CITY

Sign up

CUSTOMER REVIEWS

Average Rating: 3.7 out of 5 with 15 reviews

5 star

4

4 star

6

3 star

3

2 star

0

1 star

2

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

AVERAGE USER RATING

Write a Review

WEBSITE PREVIEW

LOAD TIME

0.5 seconds

FAVICON PREVIEW

16x16
32x32

CONTACTS AT KUNALSHRIVASTAVA.BLOGSPOT.COM

ADD CONTACT

Login

TO VIEW CONTACTS

Remove Contacts

FOR PRIVACY ISSUES

CONTENT

PAGES IN
THIS WEBSITE

9

SSL

EXTERNAL LINKS

0

SITE IP

172.217.9.225

LOAD TIME

0.489 sec

SCORE

6.2

PAGE TITLE

Kunal's Blogs | kunalshrivastava.blogspot.com Reviews

<META> DESCRIPTION

Thursday, 13 August 2009. Oracle Function to Extract the First , Middle and Last Name from Name Column. The Below Oracle Function can extract the First Name, Middle Name and Last Name from Name Column where these values are seperated by single or multiple spaces. Just Pass the column Name and 1,2,3 to get first, middle and last name from the String. FUNCTION FNC GET NAME(LV NAME VARCHAR2, LV NO NUMBER). POS FIRST SPACE NUMBER(3);. POS SECOND SPACE NUMBER(3);. LA NAME VARCHAR2(150);. IF LV NO = 1 THEN.

<META> KEYWORDS

1 kunal's blogs

2 return varchar2 is

3 begin

4 return null;

5 else

6 end if;

7 then

8 elseif

9 exception

10 when others then

CONTENT

Page content here

KEYWORDS ON PAGE

kunal's blogs,return varchar2 is,begin,return null;,else,end if;,then,elseif,exception,when others then,posted by,shunty,no comments,hi all,author shrivaku,public type declarations,return clob;,return clob is,select text,from user source,end loop;,end if

SERVER

GSE

CONTENT-TYPE

utf-8

GOOGLE PREVIEW

Kunal's Blogs | kunalshrivastava.blogspot.com Reviews

https://kunalshrivastava.blogspot.com

Thursday, 13 August 2009. Oracle Function to Extract the First , Middle and Last Name from Name Column. The Below Oracle Function can extract the First Name, Middle Name and Last Name from Name Column where these values are seperated by single or multiple spaces. Just Pass the column Name and 1,2,3 to get first, middle and last name from the String. FUNCTION FNC GET NAME(LV NAME VARCHAR2, LV NO NUMBER). POS FIRST SPACE NUMBER(3);. POS SECOND SPACE NUMBER(3);. LA NAME VARCHAR2(150);. IF LV NO = 1 THEN.

INTERNAL PAGES

kunalshrivastava.blogspot.com

1

Kunal's Blogs: Macro to set Outlook Subject Reminder

http://kunalshrivastava.blogspot.com/2009/05/macro-to-set-outlook-subject-reminder.html

Thursday, 28 May 2009. Macro to set Outlook Subject Reminder. Below is the way we can set Macro in Microsoft Out look so that when ever we forget to put Subject Line in a newly composed Mail, we can get an Alert form Outlook saying Subject Line is Missing! To do this, just follow the simple steps mentioned below and see the result. 1 Open your outlook. 2 Press Alt F11. This opens the Visual Basic editor and then Press Ctrl R which in turn open Project-Project 1 (left side). Dim strSubject As String.

2

Kunal's Blogs: August 2009

http://kunalshrivastava.blogspot.com/2009_08_01_archive.html

Thursday, 13 August 2009. Oracle Function to Extract the First , Middle and Last Name from Name Column. The Below Oracle Function can extract the First Name, Middle Name and Last Name from Name Column where these values are seperated by single or multiple spaces. Just Pass the column Name and 1,2,3 to get first, middle and last name from the String. FUNCTION FNC GET NAME(LV NAME VARCHAR2, LV NO NUMBER). POS FIRST SPACE NUMBER(3);. POS SECOND SPACE NUMBER(3);. LA NAME VARCHAR2(150);. IF LV NO = 1 THEN.

3

Kunal's Blogs: Oracle Function to Extract the First , Middle and Last Name from Name Column

http://kunalshrivastava.blogspot.com/2009/08/oracle-function-to-extract-first-middle.html

Thursday, 13 August 2009. Oracle Function to Extract the First , Middle and Last Name from Name Column. The Below Oracle Function can extract the First Name, Middle Name and Last Name from Name Column where these values are seperated by single or multiple spaces. Just Pass the column Name and 1,2,3 to get first, middle and last name from the String. FUNCTION FNC GET NAME(LV NAME VARCHAR2, LV NO NUMBER). POS FIRST SPACE NUMBER(3);. POS SECOND SPACE NUMBER(3);. LA NAME VARCHAR2(150);. IF LV NO = 1 THEN.

4

Kunal's Blogs: Alternative of Like Clauses for Oracle performance improvement

http://kunalshrivastava.blogspot.com/2009/02/alternative-of-like-clauses-for-oracle.html

Monday, 9 February 2009. Alternative of Like Clauses for Oracle performance improvement. I had a problem of some queries taking a very long time to fetch records from Database. The Query was some thing like. Select * from emp where empName like 'kunal%'. For this i tried every thing for the improvement in speed. But finally i tried to change the Like Clause with substr function and got a drastic improvement in speed. The below is the Query i modified. Select * from emp where substr(empName,1,4) = 'kunal'.

5

Kunal's Blogs: Use of Macro in PL/SQL Developer as a ShortCut to write long Statements

http://kunalshrivastava.blogspot.com/2009/05/use-of-macro-in-plsql-developer-as.html

Wednesday, 27 May 2009. Use of Macro in PL/SQL Developer as a ShortCut to write long Statements. We can use Macro as a shortcut for writing frequently used statements, functions and scripts in PL/SQL Developer also. Try the below Process. 1 Open PL/SQL Developer. Double Click on PL/SQL Developer Icon. 2 Go to File à New à SQL Window. 3 A new SQL Window opens up. Press F11. Notice that the Macro Record Button in the tool Bar gets pressed as shown below. Go Back to the PL/SQL Window. One important thing to...

UPGRADE TO PREMIUM TO VIEW 4 MORE

TOTAL PAGES IN THIS WEBSITE

9

OTHER SITES

kunalsharma.com

Kumar Kunal Kamal

Skip to main content. September 26, 2017. Theme images by Michael Elkan.

kunalsharmamest3.blogspot.com

Kunal Sharma MEST 3 Blog

Kunal Sharma MEST 3 Blog. Thursday, 25 June 2015. Aesthetics: 5/10 A Realised Product. Understanding: 6/10 Demonstrates Understanding. Production Values: 4/10 Appropriate Standards. WWW: Collage Of Pictures Presents Good Understanding Of Internet. EBI: Audio Broken, Needs Fixing. Wrote a great informative script with great understanding and creative use of pictures. Although with the failure of the audio it didn't help contribute to informing our audience,. Subscribe to: Posts (Atom).

kunalsheth.in

Life’s short Live it up!

Life’s short Live it up! Happy Birthday Old Man! 3 Years to make a post! I think i forget about the blog most of the times… Of my past goals, i did launch my first app GottaGo. 8230; and it feels good to get it out finally! This year there are a couple of things i need to do…. Go back to school! Yes the way the world is changing i need to adapt… Learning is going to be a big part this year…. Launch my 2nd appÂ YellowBus. Reconnect with people and start networking again. Happy Birthday Mr. K! So my romanc...

kunalshri.blogspot.com

HOT SEXY GIRLS

This Blog is dedicated to the beauties all around, so keep reading this. Friday, July 4, 2008. Hi dear readers my account is get disablled and due to this my site and ads are not running,I'm try'g to resolve the matter,be with me ok bye. Links to this post. Tuesday, June 24, 2008. Hey guys, where r u? She is waiting for u go and get it on. Http:/ www.eroticbeauties.net/. I'm tell'ng again is is too good ok. Links to this post. Saturday, June 21, 2008. Want a Neighbor Model. Links to this post.

kunalshrivastava.blogspot.com

Kunal's Blogs

Thursday, 13 August 2009. Oracle Function to Extract the First , Middle and Last Name from Name Column. The Below Oracle Function can extract the First Name, Middle Name and Last Name from Name Column where these values are seperated by single or multiple spaces. Just Pass the column Name and 1,2,3 to get first, middle and last name from the String. FUNCTION FNC GET NAME(LV NAME VARCHAR2, LV NO NUMBER). POS FIRST SPACE NUMBER(3);. POS SECOND SPACE NUMBER(3);. LA NAME VARCHAR2(150);. IF LV NO = 1 THEN.

kunalsidhpura.co.nr

Mystical Brain

I am Software engineer. I am redirecting it to my personal blog. To visit Mystical Brain.

kunalsidhpura.wordpress.com

Mystical Brain | if(Mind == “64 bit”) {bool read = true;}

If(Mind = “64 bit”) {bool read = true;}. Thanks for dropping by Mystical Brain! Take a look around and grab the RSS feed. To stay updated. See you around! Latest Entries ». Integrating BlogEngine.NET and merging the Login module. Filed under: .NET. Mdash; 6 Comments. September 3, 2009. I had been working a lot to integrate blogengine.net in my current site and merging the login module of my site with it. Challenging part was to merge the login module. Thanx to www.ajaymatharu.com. If (db.ValidateUser...

kunalsingh.net

www.kunalsingh.net

Off Road Bike Racing. Off Road Car Racing. On Road Bike Racing. SAND DUNE AUTOCROSS : DEC 27th - 28th. SAND DUNE AUTO X. OFF ROAD SAND DUNE AUTO CROSS EVENT : Register now at. Read more about SAND DUNE AUTO X. When riders pitted for fuel during the gruelling three-hour race there was no time to visit the burger van. Alfredo Gomez made sure his Jelly Baby sugar fix was close to hand when he pulled into the pits. Finishing third they did the trick! Read more about Motorsports. On Mon, 01/29/2018 - 13:16.

kunalsingh.org

kunalsingh.org - Registered at Namecheap.com

This domain is registered at Namecheap. This domain was recently registered at Namecheap. Please check back later! This domain is registered at Namecheap. This domain was recently registered at Namecheap. Please check back later! The Sponsored Listings displayed above are served automatically by a third party. Neither Parkingcrew nor the domain owner maintain any relationship with the advertisers.

kunalsinghchoudhary.blogspot.com

McAfee

Monday, March 10, 2008. Http:/ spreadsheets.google.com/pub? Http:/ spreadsheets.google.com/pub? Links to this post. Sunday, March 9, 2008. When running DMSetup.exe, get "An error 800c0019. 1) Click Start All Programs Accessories Notepad. 2) Select the Notepad program. Windows Vista users need to right click on the Notepad program and choose Run as administrator ). 3) Click on File and then Open. 4) Now browse to C: Windows System32 Drivers etc. 6) Select "Hosts" and click Open. Right click on hosts file.