invalid characters
hello all,
i want to share my problem with u all.my problem is i ve created two tables the primary key of one table is the foreign key of the other table.
when i did select statement to show all the data of the first table it did not come properly so,i did some formatting like page size,linesize setting.i also did column setting by column column_name format a3; statement.after running this statement the numbers which i stored in my primary key,whose datatype is number(3),it changed in to invalid characters(#### #).so,i don't know how should i correct this thing.i cannot delete or update primary key column.pls tell me the solution of this problem.
i want to share my problem with u all.my problem is i ve created two tables the primary key of one table is the foreign key of the other table.
when i did select statement to show all the data of the first table it did not come properly so,i did some formatting like page size,linesize setting.i also did column setting by column column_name format a3; statement.after running this statement the numbers which i stored in my primary key,whose datatype is number(3),it changed in to invalid characters(#### #).so,i don't know how should i correct this thing.i cannot delete or update primary key column.pls tell me the solution of this problem.