CodeSnip: Practical Use of Translate Function in Oracle
page 1 of 4
Published: 13 Mar 2008
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
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 19650/ 42


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-2024  |  Page Processed at 2024-06-22 9:43:11 PM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search