Re: Help !!!ORA-06502: PL/SQL: numeric or value error: character to number conversion error

Hey JC,
If you need to just get 4 columns out of a table, you can do something like this:
create table my_table <--whatever you want to name the new table as
select column1, column2, column3, column4 <--the fields you're selecting, you can alias them as wel if you want to rename them in the new table
from original_table <--whatever your source table is No looping involved! This is also the most efficient way to do this. Hope that helps,
Lisa Received on Wed Mar 29 2006 - 09:00:41 CST