Funda 2 > Text To Tables 1 > Some Possiblities

sql> create table scott.sampale1(name varchar2(10),sno number); table created. sql> create table scott.sample1(name varchar2(10),sno number); table created. sql> select * from

scott.sample1;

name sno ---------- ---------a 1 b 2 c 3 e 5 g 7 i 9 6 rows selected. sql> create table scott.sample2(name varchar2(10) 2 ,sname varchar2(10)); table created. sql> select * from name ---------1 2 3 5 7 9

scott.sample2;

sname ---------a b c e g i

6 rows selected. sql> desc scott.sample2; name null? ----------------------------------------- -------name sname sql> create table scott.sample3(name char(10),sname 2 char(10)); table created. sql> select * from name ---------1 2 3 5

scott.sample3;

sname ---------a b c e

type ---------------------------varchar2(10) varchar2(10)

7 9

g i

6 rows selected. sql> desc scott.sample3; name null? ----------------------------------------- -------name sname

type ---------------------------char(10) char(10)

sql> insert into scott.sample3 values(8,'sdfsdf'); 1 row created. sql> create table scott.sample4(name char(10),sname number); table created. sql>

select * from

scott.sample4;

no rows selected sql> sqlldr control=d:\load.txt log=d:\log_set.log bad=d:\bad_set.bad userid=sqlldr control=d:\load. txt log=d:\log_set.log bad=d:\bad_set.bad userid=