Oracle PL/SQL Category

Quick Search:

Jump to:

To view the original pages (which were formerly called "Morgan's Library"), you can click here.

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 li...

WHERE Clause: Joins - The WHERE Clause servers two different purposes. One is to join tw...

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...