Ledger Nano X - The secure hardware wallet
SHARE
TWEET

help

Gamies May 23rd, 2020 964 in 20 days
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE TABLE carowner(
  2. ssn VARCHAR2(13) PRIMARY KEY,
  3. fname VARCHAR2(20),
  4. lname VARCHAR2(20),
  5. lives VARCHAR2(20),
  6. works VARCHAR2(20));
  7.  
  8.  
  9. INSERT INTO carowner VALUES('19490321-7899','hans','rosenboll','borlänge','falun');
  10. INSERT INTO carowner VALUES('19540201-4428','tomas','kvist','gagnef','borlänge');
  11. INSERT INTO carowner VALUES('19650823-7999','roger','nyberg','borlänge','falun');
  12. INSERT INTO carowner VALUES('19710601-7799','lena','malm','borlänge','falun');
  13. INSERT INTO carowner VALUES('19690321-7898','ollas','bullas','falun','borlänge');
  14. INSERT INTO carowner VALUES('19590421-7199','tåmmy','dåmert','borlänge','falun');
  15. INSERT INTO carowner VALUES('19610321-4299','rollf','ekengren','borlänge','falun');
  16. INSERT INTO carowner VALUES('19810321-7199','maria','stjärnkvist','borlänge','falun');
  17. INSERT INTO carowner VALUES('19720721-7899','leyla','errstraid','borlänge','falun');
  18. INSERT INTO carowner VALUES('19380321-7799','arne','möller','borlänge','falun');
  19. COMMIT;
  20.  
  21.  
  22.  
  23. DECLARE
  24.  
  25. CURSOR c_carowner IS SELECT fname, lname, ssn
  26. FROM carowner;
  27.  
  28. rec c_carowner%ROWTYPE;
  29. BEGIN
  30.  IF NOT c_carowner%isopen THEN --  öppnar cursern
  31.         OPEN  c_carowner;
  32.     END IF;
  33.    LOOP
  34.         FETCH c_carowner
  35.         INTO rec;
  36.       EXIT WHEN c_carowner%notfound;
  37.       DBMS_OUTPUT.put_line('Firstname: ' || INITCAP(rec.fname)|| ',' || ' Lastname: ' || INITCAP(rec.lname) || ',' || ' Age: ' || rec.ssn);
  38.    END LOOP;
  39.    CLOSE c_carowner;
  40. END;
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Top