Re: CHAR()

From: HansF <Fuzzy.Greybeard_at_gmail.com>
Date: Fri, 14 Jul 2006 16:33:00 GMT
Message-Id: <pan.2006.07.14.16.34.52.905517@gmail.com>

On Fri, 14 Jul 2006 08:39:04 -0700, berwiki wrote:

>

>> A sign of the times, I fear.  Sadly there's a whole generation growing
>> up thinking that Microsoft invented the internet, computers and SQL ;)

>
> Ahh, no, don't misread that, I certainly realize Microsoft did not
> invent SQL, nor do they make the best DBMS. I use Char() in MSSQL,
> but I can't find an equivalent function in Oracle.
>
> There, that is worded better.

Much better <g>

In general, all SQL [Structured Query Language] functionality, as implemented in Oracle, is described in the Oracle Database SQL Reference manual. In particular, there is a huge chapter that shows the functions, including syntax and examples. I find it worth while to print out the table of contents to that manual.

The manual is re-released for each version of the database, along with the other docco, and is available online at http://docs.oracle.com ... since there are occasionally significant changes between releases, identifying the release/version of database is useful. The doc often includes a "What's new" section.

If I understand the purpose of MS SQL Server's CHAR() function, it's pretty close to Oracle's CHR() function as described for ORacle 10gR2 at http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14200/functions019.htm#i76965

-- 
Hans Forbrich   (mailto: Fuzzy.GreyBeard_at_gmail.com)   
*** Feel free to correct me when I'm wrong!
*** Top posting [replies] guarantees I won't respond.

Received on Fri Jul 14 2006 - 11:33:00 CDT