Home » SQL & PL/SQL » SQL & PL/SQL » non-alpha,non-numeric characters
non-alpha,non-numeric characters [message #365448] Tue, 02 June 1998 17:33 Go to next message
Carol Duncan
Messages: 1
Registered: June 1998
Junior Member
What's the best way to select columns that contain characters other than A-Z or 0-9? I have some tables that were loaded from data that was originally EBCDIC. Some of the data contain characters that I can't identify (but I know they're not Nulls, Blanks, or Tabs).

Report message to a moderator

Re: non-alpha,non-numeric characters [message #365578 is a reply to message #365448] Wed, 02 December 1998 08:52 Go to previous message
Sheon
Messages: 4
Registered: November 1998
Junior Member
Try selecting the data as ascii charaters.

Select ascii(column_name) ....

Report message to a moderator

Previous Topic: Reference Cursor Variable for Dynamic Tables?
Next Topic: Day, Month, and Year values from PL/SQL8
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 13:52:58 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.