Ø
«
»
0 : 2.1.05c. SQL in application
2.1.05c. SQL in application
Keyword oriented language
Keywords not congruous with Relational model
Lots of different ways to write SQL
Analogous to C/Java formatting
if (b==2) { a=1; } else { a=0; }
Recommend using case to differentiate attributes and keywords
SELECT colour, size, shape FROM fruit WHERE weight>22;
Oracle user accounts on Teaching database
Namespace references, e.g. shared.cars