SHARE
TWEET

Untitled

a guest Aug 19th, 2019 87 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. select length(trim(req.A)), count(*)
  2.   from tableName req
  3. group by length(trim(req.A));
  4.      
  5. select LENGTHB(req.A) lenb, length(req.A) len, req.* from tableName req
  6. where req.A = 'NHBBBBB1398052635902235'; -- Note to the equal sign and the last charactar (5) of the where clause
  7.      
  8. select LENGTHB(req.A) lenb, length(req.A) len, req.* from tableName req
  9. where req.A = 'NHBBBBB1398052635902235'; -- Note to the equal sign and the last charactar (5) of the where clause
  10.      
  11. 5
  12.      
  13. select LENGTHB(req.A) lenb, length(req.A) len, to_char(req.A) from tableName req
  14. where req.A = 'NHBBBBB1398052635902235';
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top