Oracle 1Z0-007: Basic SQL Select Statements

Basic SQL Select Statements

List the capabilities of SQL SELECT statements

select * ....  [everything];

 
				select distinct .... [distinct values in selection];


				select :whatever,:other ....  [using bind variables];


				select .......for update of ...[acquires a lock];

Execute a basic SELECT statement

select * from person;


				select name from person;

 
				select name, address from person where name='joe';

Differentiate between SQL statements and iSQL*Plus commands

SQL* Plus commands are: COPY, EDIT, EXECUTE, EXIT, GET, HOST, QUIT, PASSWORD, RUN, SAVE, SET, SPOOL, START

 
				SQL commands are: ALTER, ANALYZE, AUDIT,CONNECT, CREATE, DELETE ,DROP , GRANT , INSERT, LOCK, NOAUDIT, RENAME, REVOKE, SELECT, SET ROLE, SET TRANSACTION, TRUNCATE, UPDATE


				PL/SQL commands : BEGIN, DECLARE


				Other SQL*Plus commands: APPEND,CHANGE, CLEAR BUFFER,DEL,INPUT,LIST, DEFINE ,SHOW,RECOVER , DESCRIBE


				NOTE: In case disabling of any of the previous commands is required, this can be done through the PRODUCT_USER_PROFILE table.

Updated: July 30, 2005; Joe Gakenheimer