FreeQL – Free Oracle SQL Select Statements

AshokOfferingsLeave a Comment

M&S Consulting has begun a revolutionary service where we will write Oracle SQL statements for FREE. We have named this service FreeQLTM.

ms_freeql_logov1

Who can use FreeQL?

Anybody can request an Oracle SQL statement to be written, as complex as you desire. You must provide a valid, non-free email address that we will use to communicate with you. That means that we will not entertain requests from gmail, hotmail, yahoo, etc.

What’s the catch?

With years in the business writing high performing, very practical SQL statements for Oracle customers (many in the business intelligence space), we want to share our knowledge and get the word out about our skills, ability, and friendly business style.

You are welcome to sign up for our newsletter or make a small payment if you desire, though that is not a requirement.

I’m in. Now what?

Simply populate the FreeQL form and we will respond to you with SQL. Everyone wants something without spending money…and we’re here to give it to you!

Oracle SUBSTR Function – SQL Syntax Examples

AshokTechnical TipsLeave a Comment

The Oracle SUBSTR SQL Function is very common, and many times misused.

Below shows the SUBSTR function along with the arguments it takes:

1

substr(string, POSITION)
1

substr(string, POSITION, substring_length)

The Oracle SUBSTR function returns a portion of string, beginning at character position, substring_length characters long.

Following are important rules to follow along with syntax exemplifying the implications of the rules.