changes datatype - Dev Shed

Dev Shed Forums Sponsor:

January 2nd, 2004, 07:55 PM

weebeng

Contributing User

Join Date: Jul 2003

Posts: 76

Time spent in forums: 40 m
Reputation Power: 10

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)

January 3rd, 2004, 05:40 AM

shammat

Contributing User

Join Date: Oct 2003

Location: Germany

Posts: 2,685

Time spent in forums: 1 Month 3 Weeks 3 Days 19 h 59 m 5 sec
Reputation Power: 284

alter table ac_door modify acdr_issno number(5);

Read the docs!

January 4th, 2004, 07:11 PM

weebeng

Contributing User

Join Date: Jul 2003

Posts: 76

Time spent in forums: 40 m
Reputation Power: 10

Thank you. do u know where to find the online oracle tutorial?

January 5th, 2004, 02:45 AM

shammat

Contributing User

Join Date: Oct 2003

Location: Germany

Posts: 2,685

Time spent in forums: 1 Month 3 Weeks 3 Days 19 h 59 m 5 sec
Reputation Power: 284

http://docs.oracle.com

And they are included with the Oracle installation

Viewing: Dev Shed Forums > Databases > Oracle Development > changes datatype

« Previous Thread | Next Thread »

Developer Shed Advertisers and Affiliates

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox

Forum Jump