CodeSnip: Practical Use of Translate Function in Oracle: ASP Alliance

Print Add To Favorites Email To Friend Rate This Article
CodeSnip: Practical Use of Translate Function in Oracle

page 1 of 4

Published: 13 Mar 2008

Abstract
This code snippet combines the utilities of the length function and the translate function in order to count the number of delimited entities saved as a single string. Deepankar first gives an overview of the problem and then examines it with the help of SQL statements.

by Deepankar Sarangi
Feedback

Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 19744/ 50

Article Contents:

Introduction

This code snippet will allow the user to find out the total number of comma separated phrases being stored as a single string. Anybody trying to get the total number of phrases present in that column will face difficulty, as a group of phrases in a row would appear as a single phrase. This code snip offers a solution to similar kind of problems. Also, the viewer can find the number of entities present in a single row by using group by clause for each row separately.

View Entire Article

(Page 2) »

User Comments

No comments posted yet.