OraFAQ Forum: SQL & PL/SQL » Changing datatype

Home » SQL & PL/SQL » SQL & PL/SQL » Changing datatype

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Changing datatype [message #19491]

Thu, 21 March 2002 15:38

Kevin Chapman
Messages: 2
Registered: March 2002

Junior Member

Is it possible to change a column's datatype from varchar2 to date?

Report message to a moderator

Re: Changing datatype [message #19493 is a reply to message #19491]

Thu, 21 March 2002 18:50

nash
Messages: 10
Registered: February 2002

Junior Member

Yes, it is possible to change a column's datatype from varchar2 to date

alter table

modify <column_name> <varchar2(10) <date>

-------------
HTH

nash

Report message to a moderator

Re: Changing datatype [message #19495 is a reply to message #19491]

Thu, 21 March 2002 18:56

Kevin Chapman
Messages: 2
Registered: March 2002

Junior Member

Nash,

Thanks for the quick reply. What I also meant to ask for was an example, anywhere you could point me?

Report message to a moderator

Re: Changing datatype [message #19498 is a reply to message #19491]

Thu, 21 March 2002 19:17

nash
Messages: 10
Registered: February 2002

Junior Member

SQL > create table temp
(test varchar2(10));

---------
SQL > Table created
---------

SQL > alter table temp
modify test varchar2(10) date;

----------
SQL > Table altered
----------

--------------------------------
HTH

nash

Report message to a moderator

Re: Changing datatype [message #19500 is a reply to message #19491]

Thu, 21 March 2002 19:31

hanu
Messages: 21
Registered: March 2002

Junior Member

If the data in that column is null then you can modify.
alter table table_name modify (column_name date);

Thanks.

Report message to a moderator

Previous Topic:	Domin index
Next Topic:	UPDATE TABLE FROM ANOTHER

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 09 20:15:50 CDT 2024