SQL, PL/SQL, and SQL*Plus Syntax and Examples: S

SELECT COLUMN_DOES_NOT_EXIST FROM DUAL; * ERROR at line 2: ORA-06550: line 2, column 10: PLS-00201: identifier 'COLUMN_DOES_NOT_EXIST' must be declared ORA-06550: line 2, column 3: PL/SQL: SQL Statement ignored Disconnected from Oracle.....: Definition, Search for examples

SELECT DEPARTMENT_ID 2 FROM EMP_DETAILS_VIEW 3 WHERE SALARY>12000 DEPARTMENT_ID ------------- 90 90 90 80 80 20 6 rows selected.: Definition, Search for examples

SELECT EMPLOYEE_ID, LAST_NAME, JO_ID, SALARY * ERROR at line 1: ORA-00904: invalid column name: Definition, Search for examples

SELECT EMPLOYEE_ID, LAST_NAME, JOB_ID, SALARY 2 FROM EMP_DETAILS_VIEW 3 WHERE JOB_ID='SA_MAN' 4* ORDER BY SALARY DESC EMPLOYEE_ID LAST_NAME JOB_ID MONTHLY SALARY ----------- ------------------------- ---------- -------------- 145 Russell SA_MAN $14,000 146 Partners SA_MAN $13,500 147 Errazuriz SA_MAN $12,000 148 Cambrault SA_MAN $11,000 149 Zlotkey SA_MAN $10,500: Definition, Search for examples

SELECT EMPLOYEE_ID, LAST_NAME, JOB_ID, SALARY 2 FROM EMP_DETAILS_VIEW 3 WHERE JOB_ID='SA_MAN' 4* ORDER BY SALARY EMPLOYEE_ID LAST_NAME JOB_ID MONTHLY SALARY ----------- ------------------------- ---------- -------------- 149 Zlotkey SA_MAN $10,500 148 Cambrault SA_MAN $11,000 147 Errazuriz SA_MAN $12,000 146 Partners SA_MAN $13,500 145 Russell SA_MAN $14,000: Definition, Search for examples

SELECT EMPLOYEE_ID, LAST_NAME, JOB_ID, SALARY 2 FROM EMP_DETAILS_VIEW 3* WHERE JOB_ID='SA_MAN' EMPLOYEE_ID LAST_NAME JOB_ID MONTHLY SALARY ----------- ------------------------- ---------- -------------- 145 Russell SA_MAN $14,000 146 Partners SA_MAN $13,500 147 Errazuriz SA_MAN $12,000 148 Cambrault SA_MAN $11,000 149 Zlotkey SA_MAN $10,500: Definition, Search for examples

SELECT EMPLOYEE_ID, LAST_NAME, JOB_ID, SALARY 2 FROM EMP_DETAILS_VIEW 3* WHERE SALARY>12000: Definition, Search for examples

SELECT INTO Statement: Definition, Search for examples

SELECT INTO statement: Definition, Search for examples

SELECT LAST_NAME, DEPARTMENT_ID FROM EMP_DETAILS_VIEW: Definition, Search for examples

SELECT LAST_NAME, DEPARTMENT_ID, JOB_ID 2 FROM EMP_DETAILS_VIEW 3 WHERE JOB_ID = 'SH_CLERK' 4* ORDER BY DEPARTMENT_ID: Definition, Search for examples

SELECT LAST_NAME, DEPARTMENT_ID, SALARY, COMMISSION_PCT 2 FROM EMP_DETAILS_VIEW 3* ORDER BY LAST_NAME: Definition, Search for examples

SELECT LAST_NAME, DEPARTMENT_ID, SALARY, COMMISSION_PCT FROM EMP_DETAILS_VIEW WHERE JOB_ID = 'SA_MAN' AND COMMISSION_PCT = .25 ORDER BY LAST_NAME: Definition, Search for examples

SELECT_BASELINE_METRIC Function: Definition, Search for examples

SELECT_CURSOR_CACHE Function: Definition, Search for examples

SELECT_OBJECT Procedure: Definition, Search for examples

SELECT_SQL_TRACE Function: Definition, Search for examples

SELECT_SQLPA_TASK Function: Definition, Search for examples

SELECT_SQLSET Function: Definition, Search for examples

SELECT_WORKLOAD_REPOSITORY Function: Definition, Search for examples

SELECTNODES Function: Definition, Search for examples

SELECTSINGLENODE Function: Definition, Search for examples

SELF: Definition, Search for examples

SELF_CHECK Procedure: Definition, Search for examples

SELF_IS_NULL: Definition, Search for examples