>Where Nine subqueries can be used. If possible give example.

They can be used in the WHERE clause on the same level. For example,

SELECT * FROM table1 ;
  WHERE ;
    field1 = ( SELECT ... ) ;
    AND field2 = ( SELECT ... ) ;
    ...
    AND field9 = ( SELECT ... ) ;
  INTO CURSOR myCursor