-
Hi all,
create table test1(a integer);
desc test1;
Name Null? Type
--------------------- -------- ----------------------------
A NUMBER(38)
create table test2(a number(38));
desc test2;
Name Null? Type
-------------------- -------- ----------------------------
A NUMBER(38)
select a,vsize(a) from test1;
A VSIZE(A)
----- ----------
1 2
select a,vsize(a) from test2;
A VSIZE(A)
----- ----------
1 2
In this case, what is the difference between the 2 datatypes ??
Shiva.
-
Ronnie
ronnie_yours@yahoo.com
You can if you think you can.
-
-
The reason why I had this question was : the front end developers ( in JSP) are using an object to hold the resultset from these tables and they are not able to typecast the value to an Integer (though the field is defined as INTEGER, the reason being it is stored as NUMBER). We are trying to use the same code with SQL Server and there it works fine. I know this is not the right place to post JSP issues, but I wanted to make sure of the Oracle end.
Thanks,
Shiva.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|