Home » SQL & PL/SQL » SQL & PL/SQL » Cannot see datatype size after using cast function (Oracle 9i)
Cannot see datatype size after using cast function [message #315175] Sat, 19 April 2008 13:25 Go to next message
Messages: 2
Registered: April 2008
Junior Member

I have change the datatype of column containing varchar2 to number using a cast function after that i
describe my table it gives column with datatype (xyz Number)but no size can anybody know what is this due to and
how can we modify this datatype size. I am using oracle 9i.

Re: Cannot see datatype size after using cast function [message #315176 is a reply to message #315175] Sat, 19 April 2008 13:58 Go to previous message
Michel Cadot
Messages: 65143
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Do you think it is an Expert question?
did you answer YES to the 3 questions in Not an EXPERT? Post in the NEWBIES forum, NOT here?

Also did you read OraFAQ Forum Guide?
Do you think you correctly posted the question?
Do you think you gave all the information needed to answer your problem?
Don't you think that posting exactly what you did may help?


[Updated on: Sat, 19 April 2008 14:00]

Report message to a moderator

Previous Topic: Problem when cursor returning a table name
Next Topic: question on CURSOR
Goto Forum:

Current Time: Fri Aug 18 22:40:25 CDT 2017

Total time taken to generate the page: 0.09558 seconds