Top "Varchar2" questions

What is the max size of VARCHAR2 in PL/SQL and SQL?

I am on Oracle 10g. In a requirement I need to increase the size of a pl/sql VARCHAR2 variable. …

sql oracle plsql varchar2

Finding rows that don't contain numeric data in Oracle

I am trying to locate some problematic records in a very large Oracle table. The column should contain all numeric …

sql oracle varchar numeric varchar2

What is the major difference between Varchar2 and char

Creating Table: CREATE TABLE test ( charcol CHAR(10), varcharcol VARCHAR2(10)); SELECT LENGTH(charcol), LENGTH(varcharcol) FROM test; Result: LENGTH(CHARCOL) LENGTH(…

sql oracle char varchar2

oracle convert DD-MON-YY to DD/MM/YYYY

I am trying to convert the format of a varchar2 column from 'DD-MON-YY' to 'DD/MM/YYYY'. In example: from …

oracle date varchar2

Difference between NVARCHAR in Oracle and SQL Server?

We are migrating some data from sql server to oracle. For columns defined as NVARCHAR in SQL server we started …

sql-server database oracle nvarchar varchar2

What is the default size of a varchar2 input to Oracle stored procedure, and can it be changed?

I have a stored procedure in Oracle Database 10g where my input is a varchar2 but I'm having issues getting …

oracle stored-procedures varchar2

Limit listagg function to first 4000 characters

I have a query that uses the listagg function to get all rows as a comma delimited string to ultimately …

sql oracle oracle11g string-concatenation varchar2

ORA-12899 value too large for column despite of same length

I am running the following query. But getting ORA-12899. Altough the length of string am trying to insert is 30. INSERT …

sql oracle varchar varchar2

Why does Oracle varchar2 have a mandatory size as a definition parameter?

I want to know why Oracle needs the size parameter in the definition of the VARCHAR2. I think that is …

oracle varchar2

difference between NLS_NCHAR_CHARACTERSET and NLS_CHARACTERSET for Oracle

i have a quick question here, that i would like to know the difference between NLS_NCHAR_CHARACTERSET and NLS_…

oracle character-encoding ascii utf varchar2