Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- BEGIN
- FOR i IN 1..100 LOOP
- INSERT INTO AL VALUES(i, CONCAT('nome', i), CONCAT('Curso', i), 10 + i);
- END LOOP;
- END
- DECLARE
- var_AL AL%ROWTYPE;
- BEGIN
- SELECT * INTO var_AL FROM AL WHERE id > 90 AND curso = 'Curso95';
- dbms_output.put_line(var_AL.nome);
- dbms_output.put_line(var_AL.idade);
- END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement