The key feature of this
kit is a framework that implements best practices for globalization for
Java and PL/SQL developers.
Oracle Database 10g also added support for case- and accent-insensitive
queries and sorts. You can use this feature if you want to use only
base letters or base letters and accents in a query or sort.
LONG
The LONG datatype can hold up to 2 GB of character data. It is regarded as a
legacy datatype from earlier versions of Oracle. If youwant to store large
amounts of character data, Oracle now recommends that you use the CLOB and
NCLOB datatypes. There are many restrictions on the use of LONG datatypes in
a table and within SQL statements, such as the fact that you cannot use LONGs
in WHERE, GROUP BY, ORDER BY, or CONNECT BY clauses or in SQL
statements with the DISTINCT qualifier. You also cannot create an index on a
LONG column.
CLOB and NCLOB
The CLOB and NCLOB datatypes can store up to 4 GB of character data prior
to Oracle Database 10g. Starting with Oracle Database 10g, the limit has been
increased to 128 TBs, depending on the block size of the database.
Pages:
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201