Oracle ALL_TAB_COLUMNS
-
I have changed the data type of the currencyID and countryID from
NUMBERtoINTEGERas number is not supported by dotnet. When I run this query the data_type is still number.SELECT C.Table_Name ,
C.Column_ID ,
C.Column_Name ,
C.Data_Type,
C.char_length
FROM ALL_TAB_COLUMNS C
WHERE C.TABLE_NAME = 'CURRENCY'
ORDER BY C.column_IDAny idea how to refresh the
ALL_TAB_COLUMNSview or can there be another reason for the change not showing. Also - any suggestions as to the best Oracle support site. No it's not CP, we are very MS oriented.Never underestimate the power of human stupidity RAH
-
I have changed the data type of the currencyID and countryID from
NUMBERtoINTEGERas number is not supported by dotnet. When I run this query the data_type is still number.SELECT C.Table_Name ,
C.Column_ID ,
C.Column_Name ,
C.Data_Type,
C.char_length
FROM ALL_TAB_COLUMNS C
WHERE C.TABLE_NAME = 'CURRENCY'
ORDER BY C.column_IDAny idea how to refresh the
ALL_TAB_COLUMNSview or can there be another reason for the change not showing. Also - any suggestions as to the best Oracle support site. No it's not CP, we are very MS oriented.Never underestimate the power of human stupidity RAH
In Oracle, Integer is simply Number(38). So if you create a column as an Integer it's converted to number(38)
"When did ignorance become a point of view" - Dilbert
-
In Oracle, Integer is simply Number(38). So if you create a column as an Integer it's converted to number(38)
"When did ignorance become a point of view" - Dilbert
When I look at the table in Schema view (toad) I see integer, if I script the table out I get integer, I'm betting if I used a parameter with a data type it would be integer as well. I have now found that if I create a new table the columns do not show up in the ALL_TAB_COLUMN view, seems it might be a permissions thing. As NUMBER is not supported by dot net this seems very strange! Do all the orm tools convert number to integer/decimal.
Never underestimate the power of human stupidity RAH
-
When I look at the table in Schema view (toad) I see integer, if I script the table out I get integer, I'm betting if I used a parameter with a data type it would be integer as well. I have now found that if I create a new table the columns do not show up in the ALL_TAB_COLUMN view, seems it might be a permissions thing. As NUMBER is not supported by dot net this seems very strange! Do all the orm tools convert number to integer/decimal.
Never underestimate the power of human stupidity RAH
I haven't worked in Toad so I can't say. But an implicit conversion in dotnet is generally making a widening conversion to decimal unless the scale of the number is specifically 0 then it converts to integer. If you want a different conversion you have to specify it in the parameters of the dataadapter/datareader. Here's [^]more info on types. And here
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:1619552483055is some info on the subject from Tom Kyte, who is an institution in the Oracle World <edit> fixed link, kind of</edit>"When did ignorance become a point of view" - Dilbert
modified on Monday, November 8, 2010 5:07 AM
-
I haven't worked in Toad so I can't say. But an implicit conversion in dotnet is generally making a widening conversion to decimal unless the scale of the number is specifically 0 then it converts to integer. If you want a different conversion you have to specify it in the parameters of the dataadapter/datareader. Here's [^]more info on types. And here
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:1619552483055is some info on the subject from Tom Kyte, who is an institution in the Oracle World <edit> fixed link, kind of</edit>"When did ignorance become a point of view" - Dilbert
modified on Monday, November 8, 2010 5:07 AM
Thanks for the links Jorgen, it looks like the orm will need to do some dancing around the number conversion in dotnet. Tom's link seems to have died but that could be b/c of my net nazi, I'm at work. It seems like anything with no scale is an integer, precision seems to range from null to 22 for no discernable reason with both null and 22 being valid for an integer. Numbers in between have a scale and therefore decimal I guess.
Never underestimate the power of human stupidity RAH
-
Thanks for the links Jorgen, it looks like the orm will need to do some dancing around the number conversion in dotnet. Tom's link seems to have died but that could be b/c of my net nazi, I'm at work. It seems like anything with no scale is an integer, precision seems to range from null to 22 for no discernable reason with both null and 22 being valid for an integer. Numbers in between have a scale and therefore decimal I guess.
Never underestimate the power of human stupidity RAH
It seems to me that the link to Tom's article is destroyed by the hamsters, so here it is as inline code:
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:1619552483055"When did ignorance become a point of view" - Dilbert