|
-
If you want to use dbms_random function, then try this:
create table tamil_random_table
( RN NUMBER,
ID1 varchar2(30),
ID2 varchar2(30),
ID3 varchar2(30),
ID4 varchar2(30),
ID5 varchar2(30),
ID6 varchar2(30),
ID7 varchar2(30),
ID8 varchar2(30),
ID9 varchar2(30))
tablespace users
storage (initial 100m next 100m pctincrease 0);
execute dbms_random.seed(630522626) ;
insert into tamil_random_table
select rownum as RN,
substr(dbms_random.string('a',30),1,30) id1,
substr(dbms_random.string('a',30),1,30) id2,
substr(dbms_random.string('a',30),1,30) id3,
substr(dbms_random.string('a',30),1,30) id4,
substr(dbms_random.string('a',30),1,30) id5,
substr(dbms_random.string('a',30),1,30) id6,
substr(dbms_random.string('a',30),1,30) id7,
substr(dbms_random.string('a',30),1,30) id8,
substr(dbms_random.string('a',30),1,30) id9
from
( select 1
from dual
group by cube (1,1,1,1,1,1)
) table_a,
( select 1
from dual
group by cube (1,1,1,1,1,1)
) table_b
;
If you add 1 in the cube, the number of rows will be increased.
Tamil
Tamil
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|