Top "Varchar2" questions

How to change a dataype CLOB TO VARCHAR2(sql)

Table: customers ID NAME DATATYPE NUMBER VARCHAR2(100) CLOB I want to change the DATA column from CLOB to `VARCHAR2(1000) I …

sql oracle ddl clob varchar2

Impact of defining VARCHAR2 column with greater length

What are the effects of defining a column with VARCHAR2(1000) instead of VARCHAR2(10) in Oracle, when the values are not …

sql oracle varchar2

using long string(over 4000) in oracle query

I know that in sql varchar2 can only be around 4000. I know that in oracle PL varchcar2 can be around 32000. …

oracle plsql varchar2

10g ordering varchar columns when containing numbers in front

I have an Oracle 10g DB and have a VARCHAR2 (2000 Character) column lets name it TEST which can contain numbers …

oracle sql-order-by varchar2

Oracle varchar2 to nvarchar2 conversion

If I change an existing column type from varchar2 to nvarchar2 in Oracle will Oracle automatically convert existing column data …

oracle character-encoding varchar2

Convert Varchar2 to Char array in Oracle

I have a varchar2 field and want to split it to array of chars Like 'ABCDEF' --> 'A' 'B' …

oracle split char varchar2

Why am I getting "ORA-01429: Index-Organized Table" when trying to modify column from VARCHAR2(200) to VARCHAR2(1000)?

It's currently a VARCHAR2(200) in the database, but it needs to be raised to VARCHAR(1000), so I am attempting to …

oracle alter-table varchar2

Convert datatype Clob to Varchar2 Oracle

I have an Oracle table with a column of type clob. I want to preserve the column order and change …

sql oracle type-conversion clob varchar2

How to mask characters with X in a varchar2 field in Oracle SQL

I have a list of varchar records (column) varchar2(30) with names. How to mask characters inside the name with the …

sql oracle oracle11g sqlplus varchar2

Oracle VARCHAR2 using the max length

I am working on oracle 11g and I am wondering if it's ok to put the length of the text …

oracle11g varchar2