For last few days, I need to use SUBSTR to help me analyze data. So, I will give you small tips about SUBSTR. Let’s play ! First, you must know the format of SUBSTR below : substr( string, start_position, [ length ] ) string is the source string. start_position is the position for extraction. The first position in the string is always 1. length is optional. It is the number of characters to extract. If this parameter is omitted, substr will return the entire string. So, what’s the interesting part of SUBSTR? If start_position is 0, then substr treats start_position as [ Read More ]
Archive for February, 2010
7
Feb
2010
7
Feb
2010
In ORACLE, we know the data type of : NVARCHAR Vs VARCHAR *) NVARCHAR2 Vs VARCHAR2 *) *) For discussion sample, I took NVARCHAR2 Vs VARCHAR2 as sample. What’s the differences of that? From many sources that I read on internet, I found this facts: 1.) NVARCHAR will return UNICODE data. But it will consume your memory resource almost twice bigger (2n) . For example : When VARCHAR2 (8) only consume 8 bytes, then NVARCHAR2(8) will consume 16 bytes of your memory space. 2.) VARCHAR can’t return the UNICODE data. So,what is UNICODE data? Unicode provides a unique number for [ Read More ]
