CoderZone.org

 Category: Oracle PL/SQL

Bookmark and Share

USER tablespace - Include Access To A Default Tablespace in user creation.
USER tablespace quota - Include quota on tablespaces.
USER temp tablespace - Include access to a temporary tablespace.
USERS: Alter a user - Change a user's password.
USERS: CREATE USER w/ authentication - This example shows the CREATE USER syntax to have the user authenticatio...
USERS: Creating Users - Use the CREATE USER statement to create and configure a database user, which is an acco...
USERS: Drop users - Examples of dropping users with and without database objects. If the user to be dropped ...
USERS: Grant tablespace access - Use this clause to assign or reassign a tablespace or tablespace group for the...
USERS: Lock and Unlock accounts - Oracle user accounts can be locked, unlocked, forced to choose new passwords,...
USERS: Proxy Users - The following statement alters the user "app_user1". The example permits app_user1 to conn...
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 system. Handy for spot...
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 a PL/SQL loop to preve...
UTL_FILE - The Oracle supplied package UTL_FILE can be used to read and write files that are located on the ser...
UTL_FILE file write to file example - Example of using UTL_FILE to write to a flat (txt) file.
UTL_FILE import data - This procedure makes use of the built-in Oracle package "UTL_FILE" and its ability to im...
VARIANCE - VARIANCE returns the variance of expr. You can use it as an aggregate or analytic function. Oracl...
VAR_POP - VAR_POP returns the population variance of a set of numbers after discarding the nulls in this set. T...
VAR_SAMP - VAR_SAMP returns the sample variance of a set of numbers after discarding the nulls in this set. 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 for a view is built in a...
Wage and Commission Calculation - This block calculates the total wages (salary plus commission) paid to emplo...
WHERE Clause - Conditions - The WHERE Clause servers two different purposes. One is to limit the records affect...
WHERE Clause - Joins - The WHERE Clause servers two different purposes. One is to join two or more tables, view...
WHILE LOOP example - Basic WHILE loop skeleton code.

© coderzone.org | users online: 10