Snippet Name: SELECT placement Description: SELECT statements can be placed almost anywhere within a valid SQL code block. Also see:» TABLE: Using Select Statement With Data » SELECT: Case insensitive search » SELECT: Partition Select » SELECT: Select For Update » SELECT: Using Functions » SELECT: Get DISTINCT or UNIQUE values » SELECT: Get UNIQUE and DISTINCT values » SELECT: Scalar Select » SELECT with HAVING Clause » SELECT with GROUP BY Clause » SELECT with WHERE Clause » SELECT with SAMPLE clause » SELECT into a table » SELECT name columns » SELECT » UPDATE: Update from a SELECT statement » Inserting into SELECT statement » INSERT with Select Comment: (none) Language: PL/SQL Highlight Mode: PLSQL Last Modified: March 05th, 2009
Description: SELECT statements can be placed almost anywhere within a valid SQL code block.
Also see:» TABLE: Using Select Statement With Data » SELECT: Case insensitive search » SELECT: Partition Select » SELECT: Select For Update » SELECT: Using Functions » SELECT: Get DISTINCT or UNIQUE values » SELECT: Get UNIQUE and DISTINCT values » SELECT: Scalar Select » SELECT with HAVING Clause » SELECT with GROUP BY Clause » SELECT with WHERE Clause » SELECT with SAMPLE clause » SELECT into a table » SELECT name columns » SELECT » UPDATE: Update from a SELECT statement » Inserting into SELECT statement » INSERT with Select
SELECT DECODE((SELECT 'R' FROM DUAL), (SELECT 'R' FROM DUAL), (SELECT 'P' FROM dual)) AS RESULT FROM (SELECT 'P' FROM dual) WHERE (SELECT 1 FROM dual) = (SELECT 1 FROM dual) AND (SELECT 2 FROM dual) BETWEEN (SELECT 1 FROM dual) AND (SELECT 3 FROM dual) AND NVL((SELECT NULL FROM dual ), (SELECT 'R' FROM dual)) = (SELECT 'P' FROM dual) ORDER BY (SELECT 1 FROM dual);
