which characters can be used in varchar2?
Is there any character that cannot be inserted into varchar2?
http://www.experts-exchange.com/Database/Oracle/Q_10198380.html
Zones:
OracleDate Answered: 08/26/1999 Grade: B Views: 13
How does one insert a carriage control and line feed into a varchar2 field?
The varchar2 field is in a database table.
I am currently using Oralce 8.
http://www.experts-exchange.com/Database/Oracle/Q_20115706.html
Zones:
OracleDate Answered: 05/09/2001 Grade: A Views: 0
Hey Guys -
I have a varchar2 I am doing concatenation on. It's declared as
aTemp VARCHAR2(9000);
After repeated concatenations such as...
aTemp := aTemp || 'something';
aTemp := aTem...
http://www.experts-exchange.com/Database/Oracle/3rd_Party_Tools/Q_20496736.html
From documentations for the above,
DBMS_SQL.PARSE (
c IN INTEGER,
statement IN VARCHAR2,
language_flag IN INTEGER);
DBMS_SQL.PARSE (
c ...
http://www.experts-exchange.com/Database/Oracle/Q_20680282.html
Zones:
OracleDate Answered: 07/17/2003 Grade: A Views: 94
I thought varchar2 is a variable size datatype?
So I define a column like this
my_column NOT NULL VARCHAR2(128)
however, when I insert a value more than 128 character...
http://www.experts-exchange.com/Database/Oracle/Q_21122763.html
Zones:
OracleDate Answered: 09/08/2004 Grade: A Views: 0
I want to delete all values from one column and modify this field from VARCHAR2(50) to DATE. How to delete the values in the table?
Thanks.
http://www.experts-exchange.com/Database/Oracle/Q_21181720.html
Zones:
OracleDate Answered: 10/30/2004 Grade: A Views: 0
I want to know if it is possible to return a varchar2 from a called procedure.
CREATE OR REPLACE
procedure INSFIELDREPORT(submitDate Varchar2, claimNo varchar2, fName varchar2, lName varchar2, ...
http://www.experts-exchange.com/Database/Oracle/Q_21847363.html
Zones:
OracleDate Answered: 05/11/2006 Grade: A Views: 0
I have to define a text field of 2 characters.
Shall i use char or varchar2 for this?
http://www.experts-exchange.com/Database/Oracle/Q_10598541.html
Zones:
OracleDate Answered: 07/03/2000 Grade: A Views: 45
Could someone explain the need of using varchar2(1) over char(1)?
http://www.experts-exchange.com/Database/Oracle/Q_11531778.html
Zones:
OracleDate Answered: 10/12/2000 Grade: B Views: 0
In my application i have a primary key for company id in many tables.
Now i have created this column as varchar2(3)
Will there be any performance improvement if i change this column's data ty...
http://www.experts-exchange.com/Database/Oracle/Q_20214368.html
Zones:
OracleDate Answered: 11/04/2001 Grade: B Views: 0
