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): 23239/ 52

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

User Comments

No comments posted yet.






Community Advice: ASP | SQL | XML | Regular Expressions | Windows


©Copyright 1998-2017 ASPAlliance.com  |  Page Processed at 2017-08-21 4:20:56 AM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search