USERS: Alter a user - Change a user's password. USERS: CREATE USER w/ authentication - This example shows the CREATE USER syntax to have... USERS: Creating Users - Use the CREATE USER statement to create and configure a database... USERS: Drop users - Examples of dropping users with and without database objects. If ... USERS: Grant tablespace access - Use this clause to assign or reassign a tablespace or t... USERS: Lock and Unlock accounts - Oracle user accounts can be locked, unlocked, forced t... USERS: Proxy Users - The following statement alters the user "app_user1". The example pe... USERS: view all active users - View all actively connected users in the system. USERS: view currently connected users - View all of the currently connected users on the... USERS: view specific user info - View information on a specific Oracle user. Using COMMIT in a PL/SQL loop - Oracle recommends that you COMMIT less frequently within... UTL_FILE - The Oracle supplied package UTL_FILE can be used to read and write files that... UTL_FILE file write to file example - Example of using UTL_FILE to write to a flat (txt)... UTL_FILE import data - This procedure makes use of the built-in Oracle package "UTL_FILE... VARIANCE - VARIANCE returns the variance of expr. You can use it as an aggregate or anal... VAR_POP - VAR_POP returns the population variance of a set of numbers after discarding t... VAR_SAMP - VAR_SAMP returns the sample variance of a set of numbers after discarding the... Verify Password - A function useful in password verification and maintenance. VIEW - A view is a SQL statement stored in the database in the system tablespace. Data f... Wage and Commission Calculation - This block calculates the total wages (salary plus com... WHERE Clause - Conditions - The WHERE Clause servers two different purposes. One is to l... WHERE Clause - Joins - The WHERE Clause servers two different purposes. One is to join t... WHILE LOOP example - Basic WHILE loop skeleton code. WITH Clause: Double alias - The WITH query_name clause provides a way assign a name to a... WITH Clause: Single alias - The WITH query_name clause provides a way assign a name to a... WITH with CONNECT BY - The WITH query_name clause provides a way assign a name to a subq...