Facebook
From Botched Ostrich, 3 Years ago, written in Plain Text.
Embed
Download Paste or View Raw
Hits: 48
  1. set serveroutput on;
  2. begin
  3.  declare
  4.  v_cod ARTIST_MUN.cod_artist%type := &cod;
  5.  nume ARTIST_MUN.nume_artist%type;
  6.  begin
  7.  select nume_artist into nume
  8.  from ARTIST_MUN
  9.  where cod_artist = v_cod;
  10.  exception
  11.  when no_data_found THEN
  12.  dbms_output.put_line('Acest artist nu exista!');
  13. end;
  14.  
  15. exception
  16.  when others then
  17.  dbms_output.put_line('Introdu un input valid!');
  18. end;