Java Columns - 4

• Objects in SELECT, WHERE, ORDER BY

  SELECT pkey,
  
  JHelloWorld >> hello AS hello,
  JHelloWorld.world AS world,
  JHelloWorld >> counter AS counter,
  JHelloWorld
  FROM java_hello_world
  WHERE JHelloWorld >> counter > 0
  ORDER BY JHelloWorld

Previous slide

Next slide

Back to first slide

View graphic version

In this example the object column as a whole appears as the last column in the SELECT list as well as in the ORDER BY clause. Individual fields may be referenced via the "column.field" and "column >> field" notation where the latter cannot be confused with the "owner.table.column" notation.