Guest User

Untitled

a guest
Apr 26th, 2012
29
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.21 KB | None | 0 0
  1. How do I cast a NUMBER value to a single CHAR in Oracle?
  2. char alpha = (char)123;
  3.  
  4. rank := 10;
  5. CAST(rank as CHAR(1))
  6.  
  7. TO_CHAR(rank,'99')
  8.  
  9. CAST(rank as CHAR(2))
  10.  
  11. SUBSTR(CAST(rank as CHAR(2)), 2, 1)
Advertisement
Add Comment
Please, Sign In to add comment