SQL & PL/SQL

Hello Al,

I have a requirement; need to filter Numeric data in a Character Column in a Table.


Ex :

create table ksk1 (N varchar2(500) );

Table Contains following test data :


begin
insert into ksk1 values ('satish') ;
insert into ksk1 values ('kapaka');
insert into ksk1 values ('sita123');
insert into ksk1 values ('123sata');
insert into ksk1 values ('pavan334sdfsd');
insert into ksk1 values ('123');
insert into ksk1 values ('32');
insert into ksk1 values ('4576');
insert into ksk1 values ('qwerw23452346wefyg56345');
insert into ksk1 values ('2323');
insert into ksk1 values ('878');
insert into ksk1 values ('444');
insert into ksk1 values ('sadf452345sdg');
insert into ksk1 values ('sdghd456534');
end;

select n from ksk1;

I need to get the data like:


123
32
4576
2323
878
444

Only …..


Can we write the query for the same with using declaration/ Procedural blocks…… ?



Thanks,
Kumar