Database Administration (MOSC)

MOSC Banner

modify column from number to char and lpad with zero

edited Oct 8, 2015 7:59AM in Database Administration (MOSC) 5 commentsAnswered ✓

Is there a way to alter a table column from number to char and lpad the data with zero?

The easiest means I can currently think of is to create another table with the correct column definition and then select * the data from the original table using the lpad function into the new table.

Looking for something more elegant.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center