ansaurus

Question

Answer 1

A:

What exactly would you expect? Looking at your question, it seems to me that ASCII() would give you what you need, see this ASCII tutorial. You can loop

Or are you referring to the Unicode value?

Ernst de Haan 2010-08-20 07:40:44

I want to iterate through a string and find all the character codes of the characters present in that string, I have yet to have a look at the link but I think ASCII() takes in a character as an argument for instance you would have to do ASCII('H') to get the character code of 'H'.

Kevin Boyd 2010-08-20 07:57:16

Btw I have looked at the link and most of the examples are SQL I'm looking more for PLSQL. For eg. in actionscript I would have done something like this var str:String = "HELLO";var cCode:Number;for(var i=0; i<str.length; i++){ trace(str.charCodeAt(i));}will give result as 72, 69, 76, 76, 79

Kevin Boyd 2010-08-20 08:06:08

You can use almost all SQL commands in PL/SQL directly, and where you cannot, you can use them by embedding SQL.

JulesLt 2010-08-20 08:27:19

@JulesLt: Yes, possibly, I'm not that conversant with PL/SQL, however Michael's answers comes close to what I was looking for.

Kevin Boyd 2010-08-20 08:30:08

The DUMP SQL command may be of use to.

JulesLt 2010-08-20 08:38:43

Answer 2

+2 A:

  create or replace function asciistr2(s IN varchar2)
  RETURN varchar2
  IS
    result varchar2(32767) := '';
  BEGIN
    FOR i IN 1..Length(s)
      LOOP
      dbms_output.put_line(ASCII(substr(s,i,1)));
      result := result || ASCII(substr(s,i,1));
      END LOOP;
      return result;
  END;


  Select asciistr2('HELLO') from dual

Result: 7269767679

dbms_output

Michael Pakhantsov 2010-08-20 08:18:32

ansaurus

tags:

views:

answers:

How to find character code in PL/SQL?

related questions