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