September 2002
Intermediate to advanced
1024 pages
30h 52m
English
Content preview from Oracle PL/SQL Programming, Third Edition
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
NLS Functions
Oracle provides a subset of string functions oriented toward work with the national language character set. These functions (summarized in Table 8-4) handle cases where the underlying character set matters to the results. For example, if you were using an ASCII character set as your database character set and an EBCDIC character set as your national language character set, you would find that the two character sets had different letters associated with the code 65. You can use CHR to translate 65 to the associated character in the database character set, and the NLS function NCHR to translate 65 to a character in the national language character set.
Table 8-4. National language support functions
|
Name |
Description |
|---|---|
|
NCHR |
Returns a value from the national language character set. |
|
NLS_INITCAP |
Uppercases the first letter of each word (like INITCAP) and allows you to specify a linguistic sorting sequence. |
|
NLS_LOWER |
Lowercases a string in accordance with language-specific rules. |
|
NLS_UPPER |
Uppercases a string in accordance with language-specific rules. |
|
NLSSORT |
Returns a string of bytes that can be used to sort a string in accordance with language-specific rules. |
|
TO_NCHAR |
Converts database character set data into its national character set equivalent. |
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.