Oracle Syntax

SQL, Tools, Concepts and Features.

SQL and PL/SQL
  SQL*Plus commands (12 pages)
  SQL Functions, (Sum, to_date, to_char etc)
  Date and Time formats
  Analytic SQL Features (8 pages)
  PL/SQL commands  (16 pages)
  Built-In Packages (84 pages)
  Define Variables
  NLS Formats 
  Naming Convention & Escape characters
  Optimal Flexibile Architecture (OFA)

Tools
  EXPDP and IMPDP Data Pump
  EXP, IMP and SQLLDR parameter files
  Oracle Networking - TNSNames, Listener.ora
Error ORA-12154 TNS:could not resolve service name Versions - Features & release dates. Common Oracle errors Tables and Columns Datatypes (Summary for Oracle versions up to 11g) Data Types and Unicode Data Integrity - Constraints and Triggers Tables - Partitioned, Temporary, External and IOT's Views, Clusters, Indexes
Views and Materialized Views Clusters and Hash Clusters Indexes and Sequences Users and Schemas
Security, Roles and Privileges Tablespaces Concurrency - Multi User access Physical Storage of data
Storage: Blocks, Extents, Segments. Redo, Rollback, Undo Archive Log mode Configuration Startup and Shutdown init.ora Parameters (+ Full List) Architecture diagram (11g) Parallel processing Background processes SQL Scripts Tablespace Free Space List all Sessions List Active Sessions Script to show Object dependencies more scripts can be found on the relevant dictionary pages. Recommended Oracle books

© Copyright SS64.com 1999-2014
Some rights reserved