Category : Files from Magazines
Archive   : DBMS9104.ZIP
Filename : SQL3.APR

 
Output of file : SQL3.APR contained in archive : DBMS9104.ZIP

CREATE VIEW MY_EMPLOYEES
AS SELECT * FROM EMPLOYEE
WHERE DEPARTMENT =
(SELECT DEPARTMENT FROM MANAGER_XREF
WHERE USER_NAME = USER)
WITH CHECK OPTION
GRANT ALL PRIVILEGES ON MY_EMPLOYEES TO PUBLIC


  3 Responses to “Category : Files from Magazines
Archive   : DBMS9104.ZIP
Filename : SQL3.APR
”

  1. Daniel says:
    January 27, 2013 at 3:59 pm

    Very nice! Thank you for this wonderful archive. I wonder why I found it only now. Long live the BBS file archives!

  2. Joshie says:
    March 18, 2014 at 4:57 pm

    This is so awesome! 😀 I’d be cool if you could download an entire archive of this at once, though.

  3. DiskingRound says:
    January 14, 2015 at 10:57 pm

    But one thing that puzzles me is the “mtswslnkmcjklsdlsbdmMICROSOFT” string. There is an article about it here. It is definitely worth a read: http://www.os2museum.com/wp/mtswslnk/