ulvis.paste.net

Paste Search Dynamic
Recent pastes
junkmail
  1. reate table junkmail(
  2. Name varchar2(50) not null,
  3. Address varchar2(2) not null,
  4. ID number not null,
  5. SameFam number,
  6. primary key (ID)
  7. );
  8.  
  9.  
  10. insert into junkmail
  11. (Name,Address,ID,SameFam)
  12. values
  13. ('Alice','A',10,null),
  14. ('Bob','B',15,null),
  15. ('Carmen','C',22,null),
  16. ('Diego','A',9,10),
  17. ('Ella','B',3,15),
  18. ('Farkhad','D',11,null);
  19.  
  20. delete from junkmail where SameFam=15;
  21.  
  22. select * from junkmail;
Parsed in 0.005 seconds