Connecting to Oracle Database
“Connecting to Oracle Database”
Connecting to Oracle Database from SQL*Plus
“Connecting to Oracle Database from SQL*Plus”
To connect to Oracle Database from SQL*Plus:
“To connect to Oracle Database from SQL*Plus:”
Connecting to Oracle Database from SQL*Plus
“Connecting to Oracle Database from SQL*Plus”
Connecting to Oracle Database from SQL Developer
“Connecting to Oracle Database from SQL Developer”
To connect to Oracle Database from SQL Developer:
“To connect to Oracle Database from SQL Developer:”
Connecting to Oracle Database as User HR
“Connecting to Oracle Database as User HR”
Unlocking the HR Account
“Unlocking the HR Account”
To unlock the HR account and reset its password:
“To unlock the HR account and reset its password:”
Connecting to Oracle Database as User HR from SQL*Plus
“Connecting to Oracle Database as User HR from SQL*Plus”
To connect to Oracle Database as user HR from SQL*Plus:
“To connect to Oracle Database as user HR from SQL*Plus:”
Connecting to Oracle Database as User HR from SQL Developer
“Connecting to Oracle Database as User HR from SQL Developer”
To connect to Oracle Database as user HR from SQL Developer:
“To connect to Oracle Database as user HR from SQL Developer:”
Selecting Table Data
“Selecting Table Data”
About Queries
“About Queries”
Running Queries in SQL Developer
“Running Queries in SQL Developer”
To run queries in SQL Developer:
“To run queries in SQL Developer:”
Tutorial: Selecting All Columns of a Table
“Tutorial: Selecting All Columns of a Table”
To select all columns of the EMPLOYEES Table:
“To select all columns of the EMPLOYEES Table:”
Tutorial: Selecting Specific Columns of a Table
“Tutorial: Selecting Specific Columns of a Table”
To select only FIRST_NAME, LAST_NAME, and DEPARTMENT_ID:
“To select only FIRST_NAME, LAST_NAME, and DEPARTMENT_ID:”
Displaying Selected Columns Under New Headings
“Displaying Selected Columns Under New Headings”
Displaying Selected Columns Under New Headings
“Displaying Selected Columns Under New Headings”
Preserving Case and Including Spaces in Column Aliases
“Preserving Case and Including Spaces in Column Aliases”
Selecting Data that Satisfies Specified Conditions
“Selecting Data that Satisfies Specified Conditions”
Selecting Data from One Department
“Selecting Data from One Department”
Selecting Data from Specified Departments
“Selecting Data from Specified Departments”
Selecting Data for Last Names that Start with the Same Substring
“Selecting Data for Last Names that Start with the Same Substring”
Selecting Data for Last Names that Include the Same Substring
“Selecting Data for Last Names that Include the Same Substring”
Selecting Data that Satisfies Two Conditions
“Selecting Data that Satisfies Two Conditions”
Specifying Conditions with Regular Expressions
“Specifying Conditions with Regular Expressions”
Selecting All Managers in the EMPLOYEES Table
“Selecting All Managers in the EMPLOYEES Table”
Selecting All Employees Whose Last Names Have Double Vowels
“Selecting All Employees Whose Last Names Have Double Vowels”
Displaying Phone Numbers in a Different Format
“Displaying Phone Numbers in a Different Format”
Extracting the Street Number from Each STREET_ADDRESS
“Extracting the Street Number from Each STREET_ADDRESS”
Counting the Number of Spaces in Each STREET_ADDRESS
“Counting the Number of Spaces in Each STREET_ADDRESS”
Reporting the Position of the First Space in Each STREET_ADDRESS
“Reporting the Position of the First Space in Each STREET_ADDRESS”
Sorting Selected Data
“Sorting Selected Data”
Sorting Selected Data by LAST_NAME
“Sorting Selected Data by LAST_NAME”
Sorting Selected Data by an Unselected Column
“Sorting Selected Data by an Unselected Column”
Selecting Data from Multiple Tables
“Selecting Data from Multiple Tables”
Selecting Data from Two Tables (Joining Two Tables)
“Selecting Data from Two Tables (Joining Two Tables)”
Using Operators and Functions in Queries
“Using Operators and Functions in Queries”
Using Arithmetic Operators in Queries
“Using Arithmetic Operators in Queries”
Using an Arithmetic Expression in a Query
“Using an Arithmetic Expression in a Query”
Using Numeric Functions in Queries
“Using Numeric Functions in Queries”
Rounding Numeric Data
“Rounding Numeric Data”
Truncating Numeric Data
“Truncating Numeric Data”
Using the Concatenation Operator in Queries
“Using the Concatenation Operator in Queries”
Concatenating Character Data
“Concatenating Character Data”
Using Character Functions in Queries
“Using Character Functions in Queries”
Changing the Case of Character Data
“Changing the Case of Character Data”
Trimming Character Data
“Trimming Character Data”
Padding Character Data
“Padding Character Data”
Extracting Substrings from Character Data
“Extracting Substrings from Character Data”
Replacing Substrings in Character Data
“Replacing Substrings in Character Data”
Using Datetime Functions in Queries
“Using Datetime Functions in Queries”
Displaying the Number of Months Between Dates
“Displaying the Number of Months Between Dates”
Displaying the Number of Years Between Dates
“Displaying the Number of Years Between Dates”
Displaying the Last Day of a Selected Month
“Displaying the Last Day of a Selected Month”
Displaying a Date Six Months from a Selected Date
“Displaying a Date Six Months from a Selected Date”
Displaying System Date and Time
“Displaying System Date and Time”
Using Conversion Functions in Queries
“Using Conversion Functions in Queries”
Converting Dates to Characters Using a Format Template
“Converting Dates to Characters Using a Format Template”
Converting Dates to Characters Using Standard Formats
“Converting Dates to Characters Using Standard Formats”
Converting Numbers to Characters Using a Format Template
“Converting Numbers to Characters Using a Format Template”
Converting Characters to Numbers
“Converting Characters to Numbers”
Converting a Character String to a Date
“Converting a Character String to a Date”
Converting a Character String to a Time Stamp
“Converting a Character String to a Time Stamp”
Using Aggregate Functions in Queries
“Using Aggregate Functions in Queries”
Counting the Number of Rows in Each Group
“Counting the Number of Rows in Each Group”
Counting the Number of Distinct Values in a Set
“Counting the Number of Distinct Values in a Set”
Using Aggregate Functions for Statistical Information
“Using Aggregate Functions for Statistical Information”
Limiting Aggregate Functions to Rows that Satisfy a Condition
“Limiting Aggregate Functions to Rows that Satisfy a Condition”
Showing the Rank and Percentile of a Number Within a Group
“Showing the Rank and Percentile of a Number Within a Group”
Showing the Dense Rank of a Number Within a Group
“Showing the Dense Rank of a Number Within a Group”
Using NULL-Related Functions in Queries
“Using NULL-Related Functions in Queries”
Substituting a String for a NULL Value
“Substituting a String for a NULL Value”
Specifying Different Expressions for NULL and Not NULL Values
“Specifying Different Expressions for NULL and Not NULL Values”
Using CASE Expressions in Queries
“Using CASE Expressions in Queries”
Using a CASE Expression in a Query
“Using a CASE Expression in a Query”
Using the DECODE Function in Queries
“Using the DECODE Function in Queries”
Using the DECODE Function in a Query
“Using the DECODE Function in a Query”
About DML Statements and Transactions
“About DML Statements and Transactions”
About Data Manipulation Language (DML) Statements
“About Data Manipulation Language (DML) Statements”
About the INSERT Statement
“About the INSERT Statement”
Using the INSERT Statement When All Information Is Available
“Using the INSERT Statement When All Information Is Available”
Using the INSERT Statement When Not All Information Is Available
“Using the INSERT Statement When Not All Information Is Available”
Using the INSERT Statement Incorrectly
“Using the INSERT Statement Incorrectly”
About the UPDATE Statement
“About the UPDATE Statement”
Using the UPDATE Statement to Add Data
“Using the UPDATE Statement to Add Data”
Using the UPDATE Statement to Update Multiple Rows
“Using the UPDATE Statement to Update Multiple Rows”
About the DELETE Statement
“About the DELETE Statement”
Using the DELETE Statement
“Using the DELETE Statement”
About Transaction Control Statements
“About Transaction Control Statements”
Committing Transactions
“Committing Transactions”
Committing a Transaction
“Committing a Transaction”
Rolling Back Transactions
“Rolling Back Transactions”
Rolling Back an Entire Transaction
“Rolling Back an Entire Transaction”
Setting Savepoints in Transactions
“Setting Savepoints in Transactions”
Rolling Back a Transaction to a Savepoint
“Rolling Back a Transaction to a Savepoint”
Creating and Managing Schema Objects
“Creating and Managing Schema Objects”
About Data Definition Language (DDL) Statements
“About Data Definition Language (DDL) Statements”
About Schema Object Names
“About Schema Object Names”
Creating and Managing Tables
“Creating and Managing Tables”
About SQL Data Types
“About SQL Data Types”
Creating Tables
“Creating Tables”
Tutorial: Creating a Table with the Create Table Tool
“Tutorial: Creating a Table with the Create Table Tool”
To create the PERFORMANCE_PARTS table using the Create Table tool:
“To create the PERFORMANCE_PARTS table using the Create Table tool:”
Creating Tables with the CREATE TABLE Statement
“Creating Tables with the CREATE TABLE Statement”
Creating the EVALUATIONS Table with CREATE TABLE
“Creating the EVALUATIONS Table with CREATE TABLE”
Creating the SCORES Table with CREATE TABLE
“Creating the SCORES Table with CREATE TABLE”
Ensuring Data Integrity in Tables
“Ensuring Data Integrity in Tables”
About Constraint Types
“About Constraint Types”
Tutorial: Adding Constraints to Existing Tables
“Tutorial: Adding Constraints to Existing Tables”
To add a Not Null constraint using the Edit Table tool:
“To add a Not Null constraint using the Edit Table tool:”
To add a Not Null constraint using the ALTER TABLE statement:
“To add a Not Null constraint using the ALTER TABLE statement:”
To add a Unique constraint using the Add Unique tool:
“To add a Unique constraint using the Add Unique tool:”
To add a Primary Key constraint using the Add Primary Key tool:
“To add a Primary Key constraint using the Add Primary Key tool:”
To add a Primary Key constraint using the ALTER TABLE statement:
“To add a Primary Key constraint using the ALTER TABLE statement:”
To add two Foreign Key constraints using the Add Foreign Key tool:
“To add two Foreign Key constraints using the Add Foreign Key tool:”
To add a Foreign Key constraint using the ALTER TABLE statement:
“To add a Foreign Key constraint using the ALTER TABLE statement:”
To add a Check constraint using the Add Check tool:
“To add a Check constraint using the Add Check tool:”
Tutorial: Adding Rows to Tables with the Insert Row Tool
“Tutorial: Adding Rows to Tables with the Insert Row Tool”
To add rows to the PERFORMANCE_PARTS table using the Insert Row tool:
“To add rows to the PERFORMANCE_PARTS table using the Insert Row tool:”
Tutorial: Changing Data in Tables in the Data Pane
“Tutorial: Changing Data in Tables in the Data Pane”
To change data in the PERFORMANCE_PARTS table using the Data pane:
“To change data in the PERFORMANCE_PARTS table using the Data pane:”
Tutorial: Deleting Rows from Tables with the Delete Selected Row(s) Tool
“Tutorial: Deleting Rows from Tables with the Delete Selected Row(s) Tool”
To delete row from PERFORMANCE_PARTS using Delete Selected Row(s) tool:
“To delete row from PERFORMANCE_PARTS using Delete Selected Row(s) tool:”
Managing Indexes
“Managing Indexes”
Tutorial: Adding an Index with the Create Index Tool
“Tutorial: Adding an Index with the Create Index Tool”
To add an index to the EVALUATIONS table using the Create Index tool:
“To add an index to the EVALUATIONS table using the Create Index tool:”
Tutorial: Changing an Index with the Edit Index Tool
“Tutorial: Changing an Index with the Edit Index Tool”
To reverse the sort order of the index EVAL_JOB_IX using the Edit Index tool:
“To reverse the sort order of the index EVAL_JOB_IX using the Edit Index tool:”
Tutorial: Dropping an Index
“Tutorial: Dropping an Index”
To drop the index EVAL_JOB_IX:
“To drop the index EVAL_JOB_IX:”
Dropping Tables
“Dropping Tables”
To drop a table using the Drop tool:
“To drop a table using the Drop tool:”
Creating and Managing Views
“Creating and Managing Views”
Creating Views
“Creating Views”
Tutorial: Creating a View with the Create View Tool
“Tutorial: Creating a View with the Create View Tool”
To create the SALESFORCE view using the Create View tool:
“To create the SALESFORCE view using the Create View tool:”
Creating Views with the CREATE VIEW Statement
“Creating Views with the CREATE VIEW Statement”
Creating the EMP_LOCATIONS View with CREATE VIEW
“Creating the EMP_LOCATIONS View with CREATE VIEW”
Tutorial: Changing Views with the Edit View and Rename Tools
“Tutorial: Changing Views with the Edit View and Rename Tools”
To change the SALESFORCE view using the Edit View and Rename tools:
“To change the SALESFORCE view using the Edit View and Rename tools:”
Dropping Views
“Dropping Views”
To drop the view SALES_MARKETING using the Drop tool:
“To drop the view SALES_MARKETING using the Drop tool:”
Creating and Managing Sequences
“Creating and Managing Sequences”
Tutorial: Creating a Sequence
“Tutorial: Creating a Sequence”
To create EVALUATIONS_SEQ using the Create Database Sequence tool:
“To create EVALUATIONS_SEQ using the Create Database Sequence tool:”
Dropping Sequences
“Dropping Sequences”
To drop a sequence using the Drop tool:
“To drop a sequence using the Drop tool:”
Creating and Managing Synonyms
“Creating and Managing Synonyms”
Creating Synonyms
“Creating Synonyms”
To create a synonym using the Create Databse Synonym tool:
“To create a synonym using the Create Databse Synonym tool:”
Dropping Synonyms
“Dropping Synonyms”
To drop a synonym using the Drop tool:
“To drop a synonym using the Drop tool:”
Developing Stored Subprograms and Packages
“Developing Stored Subprograms and Packages”
About Stored Subprograms
“About Stored Subprograms”
About Packages
“About Packages”
About PL/SQL Identifiers
“About PL/SQL Identifiers”
About PL/SQL Data Types
“About PL/SQL Data Types”
Creating and Managing Standalone Stored Subprograms
“Creating and Managing Standalone Stored Subprograms”
About Subprogram Structure
“About Subprogram Structure”
Tutorial: Creating a Standalone Stored Procedure
“Tutorial: Creating a Standalone Stored Procedure”
To create a standalone stored procedure using Create PL/SQL Procedure tool:
“To create a standalone stored procedure using Create PL/SQL Procedure tool:”
Tutorial: Creating a Standalone Stored Function
“Tutorial: Creating a Standalone Stored Function”
To create a standalone stored function using Create PL/SQL Function tool:
“To create a standalone stored function using Create PL/SQL Function tool:”
Changing Standalone Stored Subprograms
“Changing Standalone Stored Subprograms”
To change a standalone stored subprogram using the Edit tool:
“To change a standalone stored subprogram using the Edit tool:”
Tutorial: Testing a Standalone Stored Function
“Tutorial: Testing a Standalone Stored Function”
To test the calculate_score function using the Run tool:
“To test the calculate_score function using the Run tool:”
Dropping Standalone Stored Subprograms
“Dropping Standalone Stored Subprograms”
To drop a standalone stored subprogram using the Drop tool:
“To drop a standalone stored subprogram using the Drop tool:”
Creating and Managing Packages
“Creating and Managing Packages”
About Package Structure
“About Package Structure”
Tutorial: Creating a Package Specification
“Tutorial: Creating a Package Specification”
To create a package specification using Create PL/SQL Package tool:
“To create a package specification using Create PL/SQL Package tool:”
Tutorial: Changing a Package Specification
“Tutorial: Changing a Package Specification”
To change EMP_EVAL package specification using the Edit tool:
“To change EMP_EVAL package specification using the Edit tool:”
Tutorial: Creating a Package Body
“Tutorial: Creating a Package Body”
To create a body for the package EMP_EVAL using the Create Body tool:
“To create a body for the package EMP_EVAL using the Create Body tool:”
Dropping a Package
“Dropping a Package”
To drop a package using the Drop tool:
“To drop a package using the Drop tool:”
Declaring and Assigning Values to Variables and Constants
“Declaring and Assigning Values to Variables and Constants”
Tutorial: Declaring Variables and Constants in a Subprogram
“Tutorial: Declaring Variables and Constants in a Subprogram”
To declare variables and constants in calculate_score function:
“To declare variables and constants in calculate_score function:”
Ensuring that Variables, Constants, and Parameters Have Correct Data Types
“Ensuring that Variables, Constants, and Parameters Have Correct Data Types”
Tutorial: Changing Declarations to Use the %TYPE Attribute
“Tutorial: Changing Declarations to Use the %TYPE Attribute”
To change the declarations in calculate_score to use %TYPE:
“To change the declarations in calculate_score to use %TYPE:”
Assigning Values to Variables
“Assigning Values to Variables”
Assigning Values to Variables with the Assignment Operator
“Assigning Values to Variables with the Assignment Operator”
Assigning Values to a Variable with Assignment Operator
“Assigning Values to a Variable with Assignment Operator”
Assigning Values to Variables with the SELECT INTO Statement
“Assigning Values to Variables with the SELECT INTO Statement”
Assigning Table Values to Variables with SELECT INTO
“Assigning Table Values to Variables with SELECT INTO”
Inserting a Table Row with Values from Another Table
“Inserting a Table Row with Values from Another Table”
Controlling Program Flow
“Controlling Program Flow”
About Control Statements
“About Control Statements”
Using the IF Statement
“Using the IF Statement”
IF Statement that Determines Return Value of Function
“IF Statement that Determines Return Value of Function”
Using the CASE Statement
“Using the CASE Statement”
CASE Statement that Determines Which String to Print
“CASE Statement that Determines Which String to Print”
Using the FOR LOOP Statement
“Using the FOR LOOP Statement”
FOR LOOP Statement that Computes Salary After Five Years
“FOR LOOP Statement that Computes Salary After Five Years”
Using the WHILE LOOP Statement
“Using the WHILE LOOP Statement”
WHILE LOOP Statement that Computes Salary to Maximum
“WHILE LOOP Statement that Computes Salary to Maximum”
Using the Basic LOOP and EXIT WHEN Statements
“Using the Basic LOOP and EXIT WHEN Statements”
Using the EXIT WHEN Statement
“Using the EXIT WHEN Statement”
Using Records and Cursors
“Using Records and Cursors”
About Records
“About Records”
Tutorial: Declaring a RECORD Type
“Tutorial: Declaring a RECORD Type”
To declare RECORD type sal_info:
“To declare RECORD type sal_info:”
Tutorial: Creating and Invoking a Subprogram with a Record Parameter
“Tutorial: Creating and Invoking a Subprogram with a Record Parameter”
To create salary_schedule and change eval_frequency:
“To create salary_schedule and change eval_frequency:”
About Cursors
“About Cursors”
Cursor Attribute Values
“Cursor Attribute Values”
Using an Explicit Cursor to Retrieve Result Set Rows One at a Time
“Using an Explicit Cursor to Retrieve Result Set Rows One at a Time”
To use an explicit cursor to retrieve result set rows one at a time:
“To use an explicit cursor to retrieve result set rows one at a time:”
Tutorial: Using an Explicit Cursor to Retrieve Result Set Rows One at a Time
“Tutorial: Using an Explicit Cursor to Retrieve Result Set Rows One at a Time”
To implement the EMP_EVAL.eval_department procedure:
“To implement the EMP_EVAL.eval_department procedure:”
About Cursor Variables
“About Cursor Variables”
Using a Cursor Variable to Retrieve Result Set Rows One at a Time
“Using a Cursor Variable to Retrieve Result Set Rows One at a Time”
To use a cursor variable to retrieve result set rows one at a time:
“To use a cursor variable to retrieve result set rows one at a time:”
Tutorial: Using a Cursor Variable to Retrieve Result Set Rows One at a Time
“Tutorial: Using a Cursor Variable to Retrieve Result Set Rows One at a Time”
To change the EMP_EVAL.eval_department procedure to use a cursor variable:
“To change the EMP_EVAL.eval_department procedure to use a cursor variable:”
Using Associative Arrays
“Using Associative Arrays”
About Collections
“About Collections”
About Associative Arrays
“About Associative Arrays”
Declaring Associative Arrays
“Declaring Associative Arrays”
To use a cursor to declare an associative array:
“To use a cursor to declare an associative array:”
Declaring Associative Arrays
“Declaring Associative Arrays”
Populating Associative Arrays
“Populating Associative Arrays”
To use a cursor to populate an associative array indexed by integer:
“To use a cursor to populate an associative array indexed by integer:”
Populating Associative Arrays
“Populating Associative Arrays”
Traversing Dense Associative Arrays
“Traversing Dense Associative Arrays”
Traversing a Dense Associative Array
“Traversing a Dense Associative Array”
Traversing Sparse Associative Arrays
“Traversing Sparse Associative Arrays”
Traversing a Sparse Associative Array
“Traversing a Sparse Associative Array”
Handling Exceptions (Run-Time Errors)
“Handling Exceptions (Run-Time Errors)”
About Exceptions and Exception Handlers
“About Exceptions and Exception Handlers”
Handling Predefined Exceptions
“Handling Predefined Exceptions”
Handling Predefined Exception NO_DATA_FOUND
“Handling Predefined Exception NO_DATA_FOUND”
Declaring and Handling User-Defined Exceptions
“Declaring and Handling User-Defined Exceptions”
Handling User-Defined Exceptions
“Handling User-Defined Exceptions”
Using Triggers
“Using Triggers”
About Triggers
“About Triggers”
Creating Triggers
“Creating Triggers”
About OLD and NEW Pseudorecords
“About OLD and NEW Pseudorecords”
Tutorial: Creating a Trigger that Logs Table Changes
“Tutorial: Creating a Trigger that Logs Table Changes”
To create EVALUATIONS_LOG and EVAL_CHANGE_TRIGGER:
“To create EVALUATIONS_LOG and EVAL_CHANGE_TRIGGER:”
Tutorial: Creating a Trigger that Generates a Primary Key for a Row Before It Is Inserted
“Tutorial: Creating a Trigger that Generates a Primary Key for a Row Before It Is Inserted”
To create the NEW_EVALUATION trigger:
“To create the NEW_EVALUATION trigger:”
Creating an INSTEAD OF Trigger
“Creating an INSTEAD OF Trigger”
Creating an INSTEAD OF Trigger
“Creating an INSTEAD OF Trigger”
Creating Triggers that Log LOGON and LOGOFF Events
“Creating Triggers that Log LOGON and LOGOFF Events”
To create HR_USERS_LOG, HR_LOGON_TRIGGER, and HR_LOGOFF_TRIGGER:
“To create HR_USERS_LOG, HR_LOGON_TRIGGER, and HR_LOGOFF_TRIGGER:”
Changing Triggers
“Changing Triggers”
To change a standalone stored subprogram using the Edit tool:
“To change a standalone stored subprogram using the Edit tool:”
Disabling and Enabling Triggers
“Disabling and Enabling Triggers”
About Trigger Compilation and Dependencies
“About Trigger Compilation and Dependencies”
Dropping Triggers
“Dropping Triggers”
To drop a trigger using the Drop tool:
“To drop a trigger using the Drop tool:”
Working in a Global Environment
“Working in a Global Environment”
About Globalization Support Features
“About Globalization Support Features”
About Language Support
“About Language Support”
About Territory Support
“About Territory Support”
About Date and Time Formats
“About Date and Time Formats”
About Calendar Formats
“About Calendar Formats”
About Numeric and Monetary Formats
“About Numeric and Monetary Formats”
About Linguistic Sorting and String Searching
“About Linguistic Sorting and String Searching”
About Length Semantics
“About Length Semantics”
About Unicode and SQL National Character Data Types
“About Unicode and SQL National Character Data Types”
About Initial NLS Parameter Values
“About Initial NLS Parameter Values”
Initial Values of NLS Parameters in SQL Developer
“Initial Values of NLS Parameters in SQL Developer”
Viewing NLS Parameter Values
“Viewing NLS Parameter Values”
To view the National Language Support Parameters report:
“To view the National Language Support Parameters report:”
Changing NLS Parameter Values
“Changing NLS Parameter Values”
Changing NLS Parameter Values for All SQL Developer Connections
“Changing NLS Parameter Values for All SQL Developer Connections”
To change National Language Support Parameter values:
“To change National Language Support Parameter values:”
Changing NLS Parameter Values for the Current SQL Function Invocation
“Changing NLS Parameter Values for the Current SQL Function Invocation”
About Individual NLS Parameters
“About Individual NLS Parameters”
About Locale and the NLS_LANG Parameter
“About Locale and the NLS_LANG Parameter”
About the NLS_LANGUAGE Parameter
“About the NLS_LANGUAGE Parameter”
NLS_LANGUAGE Affects Server Message and Month Abbreviations
“NLS_LANGUAGE Affects Server Message and Month Abbreviations”
About the NLS_TERRITORY Parameter
“About the NLS_TERRITORY Parameter”
NLS_TERRITORY Affects Currency Symbol
“NLS_TERRITORY Affects Currency Symbol”
About the NLS_DATE_FORMAT Parameter
“About the NLS_DATE_FORMAT Parameter”
NLS_TERRITORY Affects Date Formats
“NLS_TERRITORY Affects Date Formats”
NLS_DATE_FORMAT Overrides NLS_TERRITORY
“NLS_DATE_FORMAT Overrides NLS_TERRITORY”
About the NLS_DATE_LANGUAGE Parameter
“About the NLS_DATE_LANGUAGE Parameter”
NLS_DATE_LANGUAGE Affects Displayed SYSDATE
“NLS_DATE_LANGUAGE Affects Displayed SYSDATE”
About the NLS_TIMESTAMP_FORMAT and NLS_TIMESTAMP_TZ_FORMAT Parameters
“About the NLS_TIMESTAMP_FORMAT and NLS_TIMESTAMP_TZ_FORMAT Parameters”
About the NLS_CALENDAR Parameter
“About the NLS_CALENDAR Parameter”
NLS_CALENDAR Affects Displayed SYSDATE
“NLS_CALENDAR Affects Displayed SYSDATE”
About the NLS_NUMERIC_CHARACTERS Parameter
“About the NLS_NUMERIC_CHARACTERS Parameter”
NLS_NUMERIC_CHARACTERS Affects Decimal Character and Group Separator
“NLS_NUMERIC_CHARACTERS Affects Decimal Character and Group Separator”
About the NLS_CURRENCY Parameter
“About the NLS_CURRENCY Parameter”
NLS_CURRENCY Overrides NLS_TERRITORY
“NLS_CURRENCY Overrides NLS_TERRITORY”
About the NLS_ISO_CURRENCY Parameter
“About the NLS_ISO_CURRENCY Parameter”
NLS_ISO_CURRENCY
“NLS_ISO_CURRENCY”
About the NLS_DUAL_CURRENCY Parameter
“About the NLS_DUAL_CURRENCY Parameter”
About the NLS_SORT Parameter
“About the NLS_SORT Parameter”
NLS_SORT Affects Linguistic Sort Order
“NLS_SORT Affects Linguistic Sort Order”
Case-Insensitive and Accent-Insensitive Sorts
“Case-Insensitive and Accent-Insensitive Sorts”
About the NLS_COMP Parameter
“About the NLS_COMP Parameter”
NLS_COMP Affects SQL Character Comparison
“NLS_COMP Affects SQL Character Comparison”
About the NLS_LENGTH_SEMANTICS Parameter
“About the NLS_LENGTH_SEMANTICS Parameter”
NLS_LENGTH_SEMANTICS Affects Storage of VARCHAR2 Column
“NLS_LENGTH_SEMANTICS Affects Storage of VARCHAR2 Column”
Using Unicode in Globalized Applications
“Using Unicode in Globalized Applications”
Representing Unicode String Literals in SQL and PL/SQL
“Representing Unicode String Literals in SQL and PL/SQL”
Avoiding Data Loss During Character-Set Conversion
“Avoiding Data Loss During Character-Set Conversion”
Deploying an Oracle Database Application
“Deploying an Oracle Database Application”
About Deployment Environments
“About Deployment Environments”
About Installation Script Files
“About Installation Script Files”
About DDL Statements and Schema Object Dependencies
“About DDL Statements and Schema Object Dependencies”
About INSERT Statements and Constraints
“About INSERT Statements and Constraints”
Creating Installation Script Files
“Creating Installation Script Files”
Creating an Installation Script File with SQL Developer
“Creating an Installation Script File with SQL Developer”
To create an installation script file with the Database Export tool:
“To create an installation script file with the Database Export tool:”
Editing Installation Script Files that Create Sequences
“Editing Installation Script Files that Create Sequences”
Editing Installation Script Files that Create Triggers
“Editing Installation Script Files that Create Triggers”
Tutorial: Creating an Installation Script File for the Sequence and Tables
“Tutorial: Creating an Installation Script File for the Sequence and Tables”
To create an installation script file for the tables and sequence:
“To create an installation script file for the tables and sequence:”
Tutorial: Creating an Installation Script File for the Package
“Tutorial: Creating an Installation Script File for the Package”
To create an installation script file for the package:
“To create an installation script file for the package:”
Tutorial: Creating an Installation Script File for the Synonym and View
“Tutorial: Creating an Installation Script File for the Synonym and View”
To create an installation script file for the synonym and view:
“To create an installation script file for the synonym and view:”
Tutorial: Creating an Installation Script File for the Data
“Tutorial: Creating an Installation Script File for the Data”
To create an installation script file for the data:
“To create an installation script file for the data:”
Installing the Sample Application
“Installing the Sample Application”
To install the sample application using SQL Developer:
“To install the sample application using SQL Developer:”
Checking the Validity of an Installation
“Checking the Validity of an Installation”
Archiving the Installation Script Files
“Archiving the Installation Script Files”