Home » SQL & PL/SQL » SQL & PL/SQL » varchar2 v/s char function
varchar2 v/s char function [message #210035] Tue, 19 December 2006 00:55 Go to next message
ashishkumarmahanta80
Messages: 231
Registered: October 2006
Location: kolkatta
Senior Member
hello all.

In Oracle varchar2 takes dynamic space for storage then why char is still in oracle?

as we know that-
The mejor defference between varchar2 and char is fixed length and variable length . varchar2 have varible length mean if we declare as 20 space and its use only 5 space the memory asigne only 5 . but in char takes daclare space while use any number space less than declare

but the question here is why char is still used in oracle?

please make me clear about this.

with regards
yas Cool
Re: varchar2 v/s char function [message #210038 is a reply to message #210035] Tue, 19 December 2006 01:21 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
CHAR is an ANSI data type while VARCHAR2 is Oracle specific. Oracle, as an (partially) ANSI compliant database, supports the ANSI data types.

MHE
Re: varchar2 v/s char function [message #210040 is a reply to message #210035] Tue, 19 December 2006 01:26 Go to previous messageGo to next message
ashishkumarmahanta80
Messages: 231
Registered: October 2006
Location: kolkatta
Senior Member
thank you maaher

can u give me some link through which i can learn more about it?

your answer is best. thanx once again

regards
yas
Re: varchar2 v/s char function [message #210041 is a reply to message #210040] Tue, 19 December 2006 01:29 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
The best place to start looking is the Oracle documentation. In your case, that would be the SQL Reference. A link to the online documentation can be found in the Sticky (tips & tricks), but you've read that already, right Wink?

MHE
Re: varchar2 v/s char function [message #210171 is a reply to message #210041] Tue, 19 December 2006 15:27 Go to previous message
Bill B
Messages: 1482
Registered: December 2004
Senior Member
Maaher wrote on Tue, 19 December 2006 01:29
The best place to start looking is the Oracle documentation. In your case, that would be the SQL Reference. A link to the online documentation can be found in the Sticky (tips & tricks), but you've read that already, right Wink?

MHE


lol.... You forgot the <sarcasm on> <sarcasm off> tags Laughing
Previous Topic: How to select unique columns - pls read to understand better
Next Topic: Racle FAO,s
Goto Forum:
  


Current Time: Sun Dec 04 12:46:40 CST 2016

Total time taken to generate the page: 0.23783 seconds