Advertisement
xlrnxnlx

PL/SQL:first

May 13th, 2014
401
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. BEGIN
  2.  FOR i IN 1..100 LOOP
  3.    INSERT INTO AL VALUES(i, CONCAT('nome', i), CONCAT('Curso', i), 10 + i);
  4.  END LOOP;
  5. END
  6.  
  7. DECLARE
  8.   var_AL AL%ROWTYPE;
  9. BEGIN
  10.   SELECT * INTO var_AL FROM AL WHERE id > 90 AND curso = 'Curso95';
  11.   dbms_output.put_line(var_AL.nome);
  12.   dbms_output.put_line(var_AL.idade);
  13. END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement