CoderZone.org

 Category: Oracle PL/SQL

Bookmark and Share

Create DB Link - Shows how to create a link to another oracle database and connect to it.
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 arguments of different typ...
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 the number of records you...
Create trigger in Oracle - The code associated with a trigger is fired when a specified event occurs. The event...
Create User - Create the account that will own the database objects required to run the applications discussed...
CREATE USER - How to create a user and grant privileges and roles.
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 the time zone of the cu...
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 link defines ...
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 statement, where refers...
Database Links: CURRENT_USER - To create a current user database link, use the CONNECT TO CURRENT_USER clause i...
Date Calculations - Returns a day that is a specified number of days in the future, skipping weekends.
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: Calculate elapsed time from seconds - This function will calculate the elapsed time from a give...
Date functions: Current Date
Date Functions: Current_date - The current_date function returns the current date in the time zone of the curre...

© coderzone.org | users online: 7