Home » SQL & PL/SQL » SQL & PL/SQL » Reg: ASCII codes & Characters view.
Reg: ASCII codes & Characters view. [message #10932] Tue, 24 February 2004 23:10 Go to next message
BABU SRSB
Messages: 42
Registered: June 2002
Member
Hi all,

Is that any ORACLE inbuild view have all(255) the ASCII codes & characters information. If it is there, then i can fire simple SQL Query to get the corresponding information.

Please tell me, if any body knows this one.

And please don't mention any links, because my side most of the sites are restricted including otn.oracle.com.

Thanks in Advance.

Regards,

Babu SRSB.

 

 

 

 

 

 

 

 

Report message to a moderator

Re: Reg: ASCII codes & Characters view. [message #10946 is a reply to message #10932] Wed, 25 February 2004 05:25 Go to previous messageGo to next message
ashok
Messages: 32
Registered: July 2000
Member
See if this helps ... You will not be able to see the characters if want . But able to work with that .


set serveroutput on size 200000
begin
for i in 1..255
loop

dbms_output.put_line('Acsii Number ::'||i||'Character::'|| chr(i));
end loop;

end;
/

Report message to a moderator

Re: Reg: ASCII codes & Characters view. [message #10956 is a reply to message #10932] Wed, 25 February 2004 09:23 Go to previous messageGo to next message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
 
select rownum, chr(rownum)
  from all_objects
 where rownum <= 255;

Report message to a moderator

Re: Reg: ASCII codes & Characters view. [message #10962 is a reply to message #10956] Wed, 25 February 2004 18:02 Go to previous messageGo to next message
BABU SRSB
Messages: 42
Registered: June 2002
Member
Hi,
Thanks for replies....
But these are the answers i was not expected.
I need any Inbuilt views like V$ kind things.

If any body knows, please let me know.

Thanks in advance.

Regards,

Babu SRSB

Report message to a moderator

Re: Reg: ASCII codes & Characters view. [message #10974 is a reply to message #10962] Thu, 26 February 2004 08:03 Go to previous messageGo to next message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
Why in the world would there be a V$ view to show a list of ASCII characters? Are you serious?

Report message to a moderator

Re: Reg: ASCII codes & Characters view. [message #10978 is a reply to message #10974] Thu, 26 February 2004 18:21 Go to previous message
BABU SRSB
Messages: 42
Registered: June 2002
Member
Hi,

Just to know the features only.
Nothing serious.
I saw some 198 inbuilt views start with 'V$' are there.
I know about very few views.
To know the remaining only these trails and also to use in PL/SQL.
I have very limited resourse is there to getting knowledge. One of that is this forum. I am learning lot from this.

Thanks to thre forum and many more to all participents.

Regards,

Babu SRSB.

Report message to a moderator

Previous Topic: Accessing a procedure using a DB-Link
Next Topic: Doubt in Trigger
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Aug 06 02:46:24 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.