OraFAQ Forum: SQL & PL/SQL » Urgent !!!!! What is the difference ??

Home » SQL & PL/SQL » SQL & PL/SQL » Urgent !!!!! What is the difference ??

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Urgent !!!!! What is the difference ?? [message #38962]

Fri, 31 May 2002 01:32

Koala
Messages: 31
Registered: May 2002

Member

Dear all expert:
Can you tell me the difference between
LENGTH('12345') & LENGTHB('12345')
And
SUBSTR('12345',1,1) & SUBSTRB('12345',1,1)
Please Help !!!!!

Report message to a moderator

Re: Urgent !!!!! What is the difference ?? [message #38963 is a reply to message #38962]

Fri, 31 May 2002 01:37

Rajender
Messages: 2
Registered: May 2002

Junior Member

LENGTHB returns the length of char in bytes. If char is null, this function returns null. For a single-byte database character set, LENGTHB is equivalent to LENGTH.

Report message to a moderator

Previous Topic:	Re: ALTER SEQUENCE in a procedure
Next Topic:	what is the use of rowid?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 18:07:35 CDT 2024