Splitting String Using Delimiter in Oracle
Let us suppose we have a string like *'GO 4 EXPERT|99999|20130101|20131231'* and we have a requirement to split the string based on delimiter.
And the required output is as below
Read more...
Splitting String Using Delimiter in unix
Now let us try to do same in Unix as we have discussed in the following Article - Splitting String Using Delimiter in Oracle.
In Unix it is pretty simple. We can use below commands to split ...
Read more...
Finding Count of Outgoing and Incoming calls from a Caller Log table in Oracle
In day to day life we all use mobile phones and make outgoing and incoming calls. Normally our each call will be stored in the caller log in telecommunication tables.
We will call to call center to enquire about the no. of incoming calls and outgoing calls we have done. They will enter our no....
Read more...
Using Memcache in Ruby Programs
Memcache is a high-performance open-source caching server daemon and it's robust, fast & distributed system. Memcached has a client-server model, the memcached daemon listens of default port 11211, which obviously can be configured to our requirements.
In this article we will be looking at a...
Read more...
Creating & Extracting 7z Archives on Linux
7z is a compressed archive format which has a modular structure so the user can select the compression method, encryption method, block compression, unicode file names and support for very large files. 7z has been gaining popularity, and it offers great amount of compression of files so it's...
Read more...
ATOI and ITOA Custom Implementations
I wanted to make a remake of my previous BAD versions of these 2 functions.
I think they are working great now, and they're portable the same as the originals from STD library.
ATOI ...
Read more...
Another Hex to String
This is a basic attempt to accomplish this, there is already a real big load of code about this matter... I wanted to use a different approach, I created 1 table that contains all the 256 bytes, and i used it to make the conversion.. you look at the code, better
The tables ...
Read more...
Does AddThis Slow Down Your Page Loading Time ? AddThis BottleNeck Experiment
Go4Expert had AddThis as social Media option but recently removed it for bottleneck issues. Let me share my experiment results so it is helpful to other webmasters who are concerned about page loading time and AddThis.
When I had issues with AddThis, my first...
Read more...
Tips to Using Facebook & Twitter for Marketing
In today’s business world, social media tools have become the buzzword for success. Companies are increasingly going online to promote their businesses and acquire new customers. Facebook is the most popular social media site on the planet. If you own a business, using...
Read more...
Total Scenario of Callerlog Table
Finding Count of Outgoing and Incoming calls from a Caller Log table in Oracle has not covered total scenario and the query is not universal. Let us suppose the callerlog table with below data ...
Read more...
Share Cross-Domain Data using CORS in JavaScript
AJAX was a boon to web development and web applications like GMail etc. millions of site have since implemented AJAX based features on their websites, the idea of asynchronously accessing content was wonderful but AJAX was limited only to the same domain (same origin) as the page requesting the...
Read more...
Do It Yourself Market Research of your Customers
Market research helps in understanding the needs and requirements of the customer in the present world. These results help you to propose new products and services that might fetch better profits. On the other hand, they help you to identify the products that are in great demand and help you to...
Read more...
Difference between rank, dense_rank and row_number function in Oracle
We will try to understand the difference by looking into below examples.
Let us suppose we have a table called *rnk_tbl* with below data
EMP_NO MNG_NO DPT_NO EFF_DT END_DT
123 789 345 01/01/2011 12/31/2011
Read more...
|
 Subscribe via RSS
Get live updates in your web browser window. |
 Follow us on Twitter
Are you on Twitter? Follow us and get updated. |
 Like us on facebook
Share Go4Expert with your buddies on facebook. |
 Find us on Google+
Add Go4Expert to your Circle at Google+. |
 Unsubscribe
If you no longer wish to receive this newsletter or want to edit your preferences you can do it here. | |
