Advertisement
Guest User

Untitled

a guest
Mar 5th, 2015
216
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.50 KB | None | 0 0
  1. DECLARE
  2.   TYPE t_RekordOsoby IS RECORD(
  3.  
  4.   z_Id  osoby.id_os%TYPE,
  5.   z_Imie osoby.imie1%TYPE,
  6.   z_Nazwisko osoby.nazwisko%TYPE,
  7.   z_Data_ur osoby.d_ur%TYPE
  8.   );
  9.   z_DaneOsoby t_RekordOsoby;
  10. BEGIN
  11.   SELECT id_os, imie1, nazwisko, d_ur
  12.     INTO z_DaneOsoby.z_Id, z_DaneOsoby.z_Imie, z_DaneOsoby.z_Nazwisko, z_DaneOsoby.z_Data_ur
  13.     FROM osoby
  14.     WHERE id_os = 1;
  15.   DBMS_OUTPUT.PUT_LINE(z_DaneOsoby.z_Id||' '||z_DaneOsoby.z_Imie||' '||z_DaneOsoby.z_Nazwisko||' '||z_DaneOsoby.z_Data_ur);
  16. END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement