|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
changes datatype
hi...i got a question to ask..
i'm using the oracle. i'd like to change the datatype number, from 2 digits to 5 digits. How to do that in sql query. My table name is ac_door. Thank you! Name Null? Type ----------------------------------------- -------- ----------- ACDR_ISSNO NOT NULL NUMBER(2) |
|
#2
|
|||
|
|||
|
alter table ac_door modify acdr_issno number(5);
Read the docs! |
|
#3
|
|||
|
|||
|
Thank you. do u know where to find the online oracle tutorial?
|
|
#4
|
|||
|
|||
|
|
![]() |
| Viewing: Dev Shed Forums > Databases > Oracle Development > changes datatype |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|