Assigning Number values to varchar2 columns and viceversa [message #286239] |
Fri, 07 December 2007 00:17  |
swapnajojo
Messages: 40 Registered: June 2007 Location: India
|
Member |
|
|
Hi Team ,
Suppose i have created a table like this
SQL> create table ttest (pen char(2))
2 /
Table created.
SQL> desc ttest
Name Null? Type
----------------------------------------- -------- ----------------------------
PEN CHAR(2)
SQL> insert into ttest(123);
insert into ttest(123)
*
ERROR at line 1:
ORA-00928: missing SELECT keyword
SQL> insert into ttest values (12)
2 /
1 row created.
Does this mean if have a column in a table as varchar2 ,
it can accept Number values too .
System Info :
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Regards..
Binuja
|
|
|
|
|
|
|
|