SL23
Programmer
- Nov 3, 2005
- 12
Hi,
I have this script in oracle,
begin
for i in 1..100000 loop
INSERT INTO STUDENT VALUES (i,'FirstName','LastName','Major' ,55000,'2006-06-05');
commit;
end loop;
end;
Can some one help me to write this in teradata.
the table is
create table student
, no fallback
, no before journal
, no after journal
(
student_number integer not null,
first_name varchar (30),
last_name varchar (30),
department varchar (30),
student_loan_amount decimal (10,2),
expected_graduation date format 'yyyy-mm-dd' not null
)
primary index PK_student (student_number)
I have this script in oracle,
begin
for i in 1..100000 loop
INSERT INTO STUDENT VALUES (i,'FirstName','LastName','Major' ,55000,'2006-06-05');
commit;
end loop;
end;
Can some one help me to write this in teradata.
the table is
create table student
, no fallback
, no before journal
, no after journal
(
student_number integer not null,
first_name varchar (30),
last_name varchar (30),
department varchar (30),
student_loan_amount decimal (10,2),
expected_graduation date format 'yyyy-mm-dd' not null
)
primary index PK_student (student_number)