Class Notes of DATA 520 Databases (Fall 2025)
=============================================

Slide 10.5
==========

   SELECT ISBN, name FROM books b, authors a
     WHERE name LIKE '%Mon%' and a.ISBN = b.ISBN;

   for ( i = 0;  i < |books|;  i++ )
     for ( j = 0;  j < |authors|;  j++ )

       if ( name LIKE '%Mon%' and a.ISBN = b.ISBN )
         print ISBN, name

   }


shell> ls -all note.txt

-rwxr-xr-x.  1 wen.chen.hu domain users   181 Jul 12 04:48 note.txt*

 111101101 = 755 = 111 101 101
 rwxrwxrwx         --- --- ---
                    7   5   5

O: Owner permission (you)
G: Group members permission
E: Everyone else permission (including the Web)

shell> chmod 755 note.txt

sqlplus wenchen/ @xe