Step 1 : Create Temporary Table :
CREATE TABLE unpar_table (
a NUMBER, y number,
name VARCHAR2(100), date_used date);
Step 2 : load table with 1,000,000 rows
begin
for i in 1 .. 1000
loop
for j in 1 .. 1000
loop
insert into unpar_table values ( i, j, dbms_random.random, sysdate-j );
end loop;
end loop;
end;
commit;
Note: Please test scripts in Non Prod before trying in Production.
Loading...
Swetha
Super
gayatri
Nice infoemation