Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Varchar2 Vs Char

user8794108Mar 13 2015 — edited Mar 14 2015

Hi, I wanna know if this is the right behavior of this two datatype, when you compare them with > or <

For VARCHAR -> '2' is greater than '100'

For CHAR -> '100' is greater than '2'

is that right ?

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 11 2015
Added on Mar 13 2015
7 comments
634 views