Home » RDBMS Server » Server Administration » alter column width
alter column width [message #373838] Tue, 15 May 2001 02:41 Go to next message
Mahesh
Messages: 90
Registered: January 2001
Member
how to alter the column width of the existing column in a table

Report message to a moderator

Re: alter column width [message #373839 is a reply to message #373838] Tue, 15 May 2001 02:57 Go to previous message
Giridhar
Messages: 38
Registered: May 2001
Member
You can alter a column width as follows:-
Suppose ename is varchar2(10) and i want to make it varchar2(20)
Then...
alter table EMP Modify (ename varchar2(20));

Regards,
Giridhar

Report message to a moderator

Previous Topic: How to use count function to count insurance policy which more than one person hold?
Next Topic: alter column width
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Jul 01 04:13:33 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.