Oracle PL/SQL Category

Quick Search:

Jump to:

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

Create Function - Some examples of user-created functions.

Create INDEX - Samples of index creation.

Create Operator - Similar to built-in operators, a user-defined operator may support arg...

Create Package - A sample of the two necessary components of an Oracle package.

Create Sequence - This is the basic create statement for sequences.

Create Table INSERT (CTAS) - Create a table with the results from a SELECT statement.

Create test data - Instructions: Copy the create table ddl into SQL/Plus. Set th...

Create trigger in Oracle - The code associated with a trigger is fired when a specified ...

CREATE USER - How to create a user and grant privileges and roles.

Create User - Create the account that will own the database objects required to run the...

Create User example - Simple example to create a user.

Create View - Basic syntax for creating a view.

Cube root - returns cube root of a number

CUME_DIST - Returns the cumulative distribution of a value in a group of values.

Current_timestamp - The current_timestamp function returns the current date and time in ...

Data Files - Returns data files and their sizes.

Data Files - Returns details of dba_data_files

Data Types - Oracle offers many data types in character, numeric, and date/time groups.

Database Link - Database Links are used to communicate between different databases. A...

Database Links - Database Links are used to communicate between different databases.

Database Links: Close Database Link - If you want to close a link, issue the following s...

Database Links: CURRENT_USER - To create a current user database link, use the CONNECT T...

Date Calculations - Returns a day that is a specified number of days in the future, skip...

Date Functions: Add and Subtract from Dates - Adding and subtracting from date values.

Date Functions: Add Months - The add_months function returns a date plus n months.

Date Functions: ADD_MONTHS - Add a month or months to a given date.

Date functions: CURRENT_DATE - The CURRENT_DATE function returns the current date in the...