⟩ Operators used in SELECT statements.
= Equal
<> or != Not equal
> Greater than
< Less than
>= Greater than or equal
<= Less than or equal
BETWEEN Between an inclusive range
LIKE Search for a pattern
= Equal
<> or != Not equal
> Greater than
< Less than
>= Greater than or equal
<= Less than or equal
BETWEEN Between an inclusive range
LIKE Search for a pattern
What description of a data source is required for ODBC?
You want to include a carriage return/linefeed in your output from a SQL script, how can you do this?
How can you call a PL/SQL procedure from SQL?
You want to use SQL to build SQL, what is this called and give an example?
What is a Cartesian product?
How do you execute a host operating system command from within SQL?
How can variables be passed to a SQL routine?
What SQLPlus command is used to format output from a select?
What special Oracle feature allows you to specify how the cost based system treats a SQL statement?
ou want to group the following set of select returns, what can you group on? Max(sum_of_cost), min(sum_of_cost), count(item_no), item_no?