Quick Search:
CODE
Oracle PL/SQL Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
Oracle PL/SQL Category
Jump to:
Select a Location
PSOUG Home Page
Oracle Code Library
mySQL Code Library
PHP Code Library
JavaScript Code Library
Oracle Terms & Definitions
Oracle Error Codes
PSOUG Community Blogs
Oracle Jobs Board
PSOUG Forum
Oracle User Group Directory
Free Oracle Magazines
Online Learning Center
PSOUG Presentations
Advanced Code Search
News and Events
Sponsors Page
Submit Code
Contact Us
To view the original pages (which were formerly called "
Morgan's Library
"), you can click
here
.
<<
<
9
10
11
12
13
14
15
16
17
18
>
>>
UPDATE: based on multiple returned values
- Update based on multiple returned values fro...
UPDATE: Correlated Update
- You can write a subquery that SQL may have to re-evaluate as...
UPDATE: Nested Table Update example
- Nested Tables are tables that have columns that a...
UPDATE: Single row
- Update a single row of data in a single table.
UPDATE: Update a partitioned table
- Update records that exist only in a single partition.
UPDATE: update a specific record
- Updating a single record in a single table.
UPDATE: Update based on a query
- Update one or more rows based on the results of a query.
UPDATE: Update based on a record
- Update a table based on the value or presence of a re...
UPDATE: Update from a SELECT statement
- Update based on results of a SELECT statement.
UPDATE: Update multiple rows
- Update multiple rows in a single table based on a WHERE c...
UPDATE: Update Object Table
- You can update, insert, and delete the data in an object v...
UPDATE: with RETURNING clause
- UPDATE with the RETURNING clause changes the values of t...
UPPER function
- The upper function converts all letters in the specified string to uppe...
USER - User Information 2
- More user information from v_$session.
USER profile
- Include profile in user creation.
USER - Connected Users
- Find all currently connected users.
USER - connection information
- User connection information from gv_$session_connect_info.
USER - drop user
- Drop a user with and without objects.
USER - misc queries and commands
- Some user related queries and commands.
USER active connected users
- Query for active connected users.
USER idle time
- Query for user idle time.
USER Information
- Query for user information including default tablespace, temporary ta...
USER lock account
- Lock or unlock the account on creation.
USER memory use
- View memory use for each active user session.
USER password
- Code for the DBA to create an Oracle user and to view user details.
USER password expiration
- Expire the password on creation of user. This forces the user...
USER system authentication
- Create Operating System Authenticated User.
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.
<<
<
9
10
11
12
13
14
15
16
17
18
>
>>
Home
:
Code Library
:
Sponsors
:
Privacy
:
Terms of Use
:
Contact Us
455 users online © 2009 psoug.org
PSOUG LOGIN
Username:
Password:
Forgot your password?