Tag Archive: subquery

Oracle glossary: in, not in
  • 30
    Set

Oracle glossary: in, not in

In and not in are conditions. Useful for tests one or more values for membership(or not) in a list of values or subquery Some example: select * from table where col1 in (23, 45, 342) -- where values of col1...

Read More
Oracle glossary: Subquery
  • 23
    Set

Oracle glossary: Subquery

Oracle subquery is a sql query within another sql query. Some example: select tab.name, tab.surname from (select name, surname from customer where surname like ‘S%’) tab select id from myusers where (name, surname) in (select name, surname from customer where...

Read More