Oracle Database vs Sun MySQL

AshokIndustry Trends, Technical TipsLeave a Comment

Well, this is a topic we have reviewed numerous times over the years for projects and customers. The fact is, like most important decisions, picking a winner is based mostly on your specific needs. Of the many aspects we review, we will discuss one line of thought in this article.

If there is in-house expertise in Oracle, and management is happy with the skills, productivity of existing staff, and license fees, stick with it. I don’t know many — actually, I don’t know any — CIOs or Directors in IT Management that have been berated for choosing Oracle as an enterprise-wide database platform.

That said, if the strategic decision to use Oracle database for all purposes hasn’t been made, MySQL is worth a very serious look, especially for …

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.

Who is M&S?

AshokIndustry Trends, News and UpdatesLeave a Comment

We are asked this question quite a lot. Find out some unique insights on M&S Consulting in this article.

The M&S business model is created from the group up to deliver repeated success, consistently: a great benefit to our organization and yours.

Oracle Portal 10.1.4 or 10.1.4.1 Upgrade to 10.1.4.2 – Features and Bug Fixes

AshokTechnical Tips4 Comments

You may have applied or are considering applying the Oracle Application Server 10.1.2.3 patch for a variety of reasons. As a result, if you are running Oracle Portal 10.1.4 or 10.1.4.1, your Portal will be upgraded to 10.1.4.2.

Portal 10.1.4.2 New Features

There isn’t much to be found in terms of documented new features for Portal 10.1.4.2, but I understand the following to be new to this release:

  • Portal Repository JSR-170 adapter
  • You can now copy pages across page groups
  • New HTML DOCTYPE specification

Portal 10.1.4.2 Bug Fixes

Of the many bug fixes documented for Oracle AS 10.1.2.3 and Portal 10.1.4.2, following are just a few that you might be pleased about:

  • Omniportlet onclick was still opening the link in the same browser window.
  • Customize/Personalize links on a portlet were accessible even after the Global Inactivity Timeout has occurred.
  • When a WSRP portlet tried to upload content of size > 64k as multipart request, then an error was displayed saying > 64K is being uploaded.
  • All old-style URLs may now be redirected directly to the new URL without going via the splash screen.
  • More in the full article…

Flash-Based Oracle MetaLink Sucks

AshokTechnical Tips4 Comments

I am a big fan of RIA, Flex, and Flash UIs in general. So, why do I feel that the flash-based version of Oracle MetaLink sucks? Here is a quick top 5: I usually develop on a machine other than my own: using remote desktop with anything flash-based is fairly useless in my experience. Waiting for animations to refresh on the screen is dreadful. I have more problems. I can’t say I liked the UI of the old MetaLink, but my experience was consistent and stable. I end up having to log-in more with the Flash version…rarely, but randomly…while I … Read More

Escalate Oracle SR (TAR) – How To

AshokTechnical Tips2 Comments

I’m not sure why, but I find myself having to do this quite often these days; not so much to actually escalate the severity of tickets, but just to get some more responsiveness. Has anyone else noticed a general slow down from Oracle Support as of recently?

I thought I would note the phone steps for escalation to make it easy for people. Between escalation through support and the various channels we have with Oracle, we have become very good at getting issues to resolution very quickly.

…details are provided in the full article

So, as an example, I recently dialed: 800-223-1711, 1, 1, 1, 1, 999999#