Advertisement
Guest User

Untitled

a guest
May 23rd, 2019
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.34 KB | None | 0 0
  1. CREATE TYPE typ_cr_card AS OBJECT -tworzenie obiektu (card type VARCHAR2 (25), card num NUMBER) CREATE TYPE typ_cr card nst worzenie typu zagniezdionej tabeli AS TABLE OF typ_cr_card; ALTER TABLE employees ADD (credit cards typ_cr_card_nst) NESTED TABLE credit cards STORE AS C C store tab; Select first name, last_name, credit_cards from employees;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement