Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DECLARE
- tabela VARCHAR(255);
- atributos pratica9_e2.ATTR_ARRAY;
- valores pratica9_e2.VALUE_ARRAY;
- whereattrs pratica9_e2.ATTR_ARRAY;
- wherevals pratica9_e2.VALUE_ARRAY;
- BEGIN
- tabela := 'TROFEU';
- atributos := pratica9_e2.ATTR_ARRAY('OBJETIVO');
- valores := pratica9_e2.VALUE_ARRAY('''TEST1''');
- whereattrs := pratica9_e2.ATTR_ARRAY('NOMEJOGO', 'IDTROFEU');
- wherevals := pratica9_e2.VALUE_ARRAY('''FIFA 14''', '''1''');
- pratica9_e2.atualiza(tabela, atributos, valores, whereattrs, wherevals);
- dbms_output.put_line('Aluno removido!');
- END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement