Orcale Tutorial Content

Loading...

Getting Started - البدء مع إدارة قواعد البيانات
  • أنواع مستخدمي قواعد البيانات:
  • مهام مسؤول قاعدة البيانات:
  • SQL Statements:
  • Identifying Your Oracle Database Software Release - تحديد إصدار اوركل
  • About Database Administrator Security and Privileges- أمان وامتيازات مسؤول قاعدة البيانات
  • Database Administrator Authentication - مصادقة مسؤول قاعدة البيانات
  • Creating and Maintaining a Database Password File - إنشاء ملف كلمة المرور
  • Oracle Architectural Components - مكونات قاعدة البيانات أوركل
  • ﻤﻜﻭﻨﺎﺕ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ
  • Oracle Instance
  • Oracle Database
  • Installing Oracle Database - تثبيت الأوركل
  • Installing oracle database 10g in windows
  • Creating and Configuring Database - إنشاء قاعدة البيانات
  • ﺍﻟﺘﺨﻁﻴﻁ ﻟﻘﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ
  • ﺇﻨﺸﺎﺀ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﺒﺎﻟﻁﺭﻴﻘﺔ ﺍﻟﻴﺩﻭﻴﺔ علي Windows:
  • ﺇﻨﺸﺎﺀ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﻋﻥ ﻁﺭﻴﻕ ﺍل(DBCA)
  • About Creating an Oracle Database
  • About Selecting a Character Set
  • Prerequisites for Database Creation
  • Creating a Database with the CREATE DATABASE Statement
  • Specifying CREATE DATABASE Statement Clauses
  • Specifying Initialization Parameters
  • Controlling The Database -التحكم في قاعدة البيانات
  • التحكم في قاعدة البيانات - Controlling The Database
  • ﺘﺸﻐﻴل ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ
  • ﺇﻏﻼﻕ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ
  • Opening a Database in Read-Only Mode
  • Opening a Database in Restricted Mode
  • Managing Tablespaces and Data files
  • ﻤﻔﺎﻫﻴﻡ ﻋﺎﻤﺔ ﻋﻥ ﺍل: Tablespaces
  • عملي
  • Control File & Redo Log Files
  • Control File
  • ﺘﻐﻴﻴﺭ ﺍﺴﻡ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ
  • Redo Log Files
  • Administrating Users - إدارة المستخدمين
  • ﺇﻨﺸﺎﺀ ﻭﺇﺩﺍﺭﺓ ﺍﻟﻤﺴﺘﺨﺩﻤﻴﻥ
  • Quota
  • ﻭﺴﻴﻠﺔ ﺍﻟﺘﺤﻘﻴﻕ
  • ﺍﻟﺼﻼﺤﻴﺎﺕ - Privileges
  • ROLES
  • PROFILES
  • Database Security & Monitoring - تأمين ومراقبة قاعدة البيانات
  • Database Security
  • ﻤﺭﺍﻗﺒﺔ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ - AUDITING
  • Oracle Net Services & Database Link & Metrlized Viewِ
  • Oracle Net Services
  • ﺍﻟﺘﺤﻜﻡ ﻓﻲ ﺍﻟﻭﺼﻭل ﻟﻘﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ
  • External Procedures
  • Clients Side
  • Database Link
  • Materialized Views
  • Undo Management & Flashback Technology
  • UNDO MANAGEMENT
  • Flashback Query
  • Flashback Table
  • Flashback Versions Query
  • Flashback Transaction
  • Flashback Drop
  • Flashback Database
  • Managing Shared Servers
  • Why Shared Server
  • Dedicated Server
  • Shared Server Architecture
  • ﻤﺘﻰ ﻨﺴﺘﺨﺩﻡ ﺍل Shared Server ؟
  • Using Globalization Support
  • Globalization
  • ﺍﺨﺘﻴﺎﺭ وتغيير ﺍل Character Set
  • ﻤﺴﺘﻭﻴﺎﺕ ﺍل Globalization
  • ﺍﺴﺘﺨﺩﺍﻡ ﺍل Zones Time
  • Logical Backup & Recovery
  • Use Export Utilities to Export Data
  • TABLES EXPORT Using Export Utilities
  • SCHEMAS EXPORT Using Export Utilities
  • TABLESPACE EXPORT Using Export Utilities
  • DATABASE EXPORT Using Export Utilities
  • Use Import Utilities to Import Data
  • TABLES IMPORT Using Import Utilities
  • SCHEMAS IMPORT Using Import Utilities
  • DATABASE IMPORT Using Import Utilities
  • DATA PUMP
  • TABLES EXPORT Using Data Pump
  • SCHEMAS EXPORT Using Data Pump
  • DATABASE EXPORT Using Data Pump
  • TABLES IMPORT Using Data Pump
  • SCHEMAS IMPORT Using Data Pump
  • DATABASE IMPORT Using Data Pump
  • SQL*Loader
  • Physical Backup & Recovery
  • Physical Backup
  • ﻜﻴﻑ ﻨﻬﻴﺊ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﻟﺘﻌﻤل ﻓﻲ ﺍﻟﻨﻤﻁ ARCHIVELOG؟
  • Cold Backup
  • Full Database Recovery
  • Loss of a Non-SYSTEM Data File
  • Loss of a SYSTEM Data File
  • Loss of an Un-archived Online Log Files
  • Loss of Control Files
  • Loss Unbackup Datafile
  • Damage Tempfile
  • Damage Temporary Tablespace
  • Damage Online Logfile Member
  • Point in Time Recovery
  • Backup and Recovery Options
  • Hot Backup
  • Recovery Manager (RMAN)
  • مقدمة
  • مكونات ال Recovery Manager (RMAN)
  • ﺃﻨﻭﺍﻉ ﺍﻻﺘﺼﺎل ﺒﺎل RMAN
  • ﺨﻴﺎﺭﺍﺕ وأنماط ﺍﻟﻨﺴﺦ ﺍﻹﺤﺘﻴﺎﻁﻰ
  • RMAN Configuration Setting
  • Recovery Catalog
  • RMAN Backups
  • Data Files Backup
  • Tablespaces Backup
  • Archived Redo Log Files Backup
  • Control File Backup
  • Database Backup
  • Incremental Backups
  • RMAN Commands
  • Complete Recovery
  • Incomplete Recovery
  • Restore ControlFile and spfile
  • Managing Resources
  • Consumer Groups
  • Resource Manager Plans
  • Resource Manager Configuration
  • Create Consumer Group
  • Update Consumer Group
  • Delete Consumer Group
  • Privileges & Resource Manager
  • Join To Consumer Group
  • Move Active User To Other Consumer Group
  • Create Resource Manager Plans & Directive
  • Update Resource Manager Plans
  • Update Resource Manager Plan Directives
  • Delete Resource Manager Plan Directives
  • Delete Resource Manager Plans
  • Create Simple Plan
  • Consumer Group Mapping
  • Automating Tasks with the Scheduler
  • The Scheduler Architecture
  • Jobs
  • Programs
  • Schedules
  • Using Programs and Schedules
  • Job Classes
  • Windows
  • (Privileges) ﺍﻟﺼﻼﺤﻴﺎﺕ
  • Job Logs
  • Dealing with Locking
  • Shared & Exclusive Locks
  • Manual Lock Table
  • The Enqueue Mechanism
  • Lock Contention
  • Deadlocks
  • Diagnostic Sources
  • Alert Log
  • Background Trace Files
  • Server-Generated Alerts
  • Editing Thresholds
  • User Trace Files
  • Instance-Level SQL Tracing
  • Session-Level SQL Tracing
  • Dealing With Database Corruption
  • Block Corruption
  • ﺍﻜﺘﺸﺎﻑ ﺍﻟﻜﺘل ﺍﻟﻔﺎﺴﺩﺓ (Detecting Block Corruptions)
  • The DBVERIFY Utility
  • The ANALYZE Command
  • DBMS_REPAIR Backage
  • ﺍﺴﺘﺭﺠﺎﻉ ﺍﻟﻜﺘل ﺍﻟﻔﺎﺴﺩﺓ ﺒﻭﺍﺴﻁﺔ ﺍل:RMAN
  • Managing & Monitoring Memory
  • The System Global Area
  • The Shared Pool
  • The Database Buffer Cache
  • The Default, Keep, and Recycle Pools
  • The Nonstandard Block Size Pools
  • Sizing the Database Buffer Cache
  • The Log Buffer
  • The Large Pool
  • The Java Buffer
  • The Steams Buffer
  • Automatic Shared Memory Management
  • Enable Automatic Shared Memory Management
  • The Program Global Area (PGA)
  • Performance Tunning
  • Invalid Objects
  • Unusable Indexes
  • Rebuild Invalid Inexes
  • Optimizer Statistics
  • Gathering Statistics
  • The Automatic Workload Repository (AWR)
  • The Automatic Database Diagnostic Monitor (ADDM)
  • The SQL Tuning Advisor
  • The SQL Access Advisor
  • The Mean Time to Recover Advisor
  • The Segment Advisor
  • The Undo Advisor
  • Using Globalization Support

    Globalization

     ﺍلGlobalization ﻫﻭ ﻤﺼﻠﺢ ﻴﻌﻨﻲ ﺨﺩﻤﺔ ﻋﺩﺩ ﻤﻥ ﺍﻟﺒﻴﺌﺎﺕ ﻭﺍﻟﻠﻐﺎﺕ ﻭﺍﻟﺜﻘﺎﻓﺎﺕ ﻭﺍﻟﻤﻨﺎﻁﻕ ﺍﻟﺠﻐﺭﺍﻓﻴﺔ ﺍﻟﻤﺨﺘﻠﻔﺔ ﺍﻟﺘﻲ ﺘﻌﻤل ﻋﻠﻲ ﻗﺎﻋﺩﺓ ﺒﻴﺎﻨﺎﺕ، ﻻ ﺸﻙ ﺃﻥ ﺍﻷﻤﺭ ﻟﻴﺱ ﺒﺎﻟﺴﻬل،

    ﺴﻨﺘﺤﺩﺙ ﻋﻥ ﻁﺭﻴﻘﺔ ﺘﺨﺯﻴﻥ ﻫﺫﻩ ﺍﻟﺒﻴﺎﻨﺎﺕ ﻓﻲ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﻓﻴﻤﺎ ﻴﻌﺭﻑ ﺒﺎلCharacter Set ﻭﺃﻴﻀﺎﹰ ﺸﻜل ﻋﺭﺽ ﺍﻟﺒﻴﺎﻨﺎﺕ ﻭﺍﻟﻭﺍﺠﻬﺎﺕ ﻭﺭﺴﺎﺌل ﺍﻷﺨﻁﺎﺀ ﻓﻴﻤﺎ ﻴﻌﺭﻑ ﺒﺎلLanguage

    ﻤﻊ ﺍﻟﺤﻔﺎﻅ ﻋﻠﻲ ﺨﺼﻭﺼﻴﺔ ﻜل ﻤﻨﻁﻘﺔ ﺠﻐﺭﺍﻓﻴﺔ ﻓﻴﻤﺎ ﻴﻌﺭﻑ ﺒﺎلTerritory ﻭﻋﻤﻠﻴﺔ ﻋﺭﺽ ﺍﻟﺒﻴﺎﻨﺎﺕ ﺒﺘﺭﺘﻴﺏ ﻤﻌﻴﻥ ﻭﺸﻜل ﺍﻟﺘﻭﺍﺭﻴﺦ ﻭﺍﻷﻭﻗﺎﺕ، ﻭﻤﺭﺍﻋﺎﺓ ﻓﺭﻭﻕ ﺍﻷﻭﻗﺎﺕ ﺒﻴﻥ ﺍﻟﻤﻨﺎﻁﻕ ﺍﻟﻤﺨﺘﻠﻔﺔ

    ﻓﻴﻤﺎ ﻴﻌﺭﻑ ﺒﺎلTime Zone، ﻭﺒﺎﻟﻌﻤﻭﻡ ﻴﻤﻜﻥ ﺍﻟﻘﻭل ﺃﻥ ﻨﻘﺎﺸﻨﺎ هنا ﻴﺘﺤﺩﺙ ﻋﻥ ﻜﻴﻔﻴﺔ ﺘﻬﻴﺌﺔ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﻟﺘﺘﻌﺎﻤل ﻤﻊ ﺒﻴﺌﺎﺕ ﻭﺠﻬﺎﺕ ﻭﺜﻘﺎﻓﺎﺕ ﻤﺨﺘﻠﻔﺔ.

    ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﺃﻭﺭﻜل ﻟﻬﺎ ﺍﻟﻌﺩﻴﺩ ﻤﻥ ﺍﻟﻘﺩﺭﺍﺕ ﺍﻟﺘﻲ ﺠﻤﻌﺕ ﺘﺤﺕ ﻤﺼﻁﻠﺢ (Globalization) ﻤﻥ ﺸﺄﻨﻬﺎ ﻤﺴﺎﻋﺩﺓ ﻤﺩﻴﺭ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﻓﻲ ﺨﺩﻤﺔ ﻤﺴﺘﺨﺩﻤﻴﻥ ﻤﻥ ﺠﻨﺴﻴﺎﺕ ﻤﺨﺘﻠﻔﺔ،

    ﻓﻲ ﺍﻹﺼﺩﺍﺭﺍﺕ ﺍﻟﺴﺎﺒﻘﺔ ﻜﺎﻨﺕ ﺘﻌﺭﻑ ﺒﻤﺼﻁﻠﺢ (National Language Support (NLS، ﻟﻜﻥ ﺍلGlobalization ﻫﻲ ﺃﻜﺜﺭ ﺘﻌﺒﻴﺭﺍﹰ ﻭﻫﻲ ﻤﺠﻤﻭﻋﺔ ﺸﺎﻤﻠﺔ ﻤﻥ ﺍﻟﺘﺴﻬﻴﻼﺕ ﺍﻟﻼﺯﻤﺔ ﻹﺩﺍﺭﺓ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ

    ﺍﻟﺘﻲ ﻴﺠﺏ ﺃﻥ ﺘﻐﻁﻲ ﻁﺎﺌﻔﺔ ﻭﺍﺴﻌﺔ ﻤﻥ ﺍﻟﻠﻐﺎﺕ ﻭﺍﻟﻤﻨﺎﻁﻕ ﺍﻟﺯﻤﻨﻴﺔ ﻭﺍﻻﺨﺘﻼﻓﺎﺕ ﺍﻟﺜﻘﺎﻓﻴﺔ. ﻟﻘﺩ ﺯﺍﺩﺕ ﺍﻷﻫﻤﻴﺔ ﻟﺩﻭﺭ ﺍلGlobalization ﺒﻌﺩ ﺍﻟﺘﻭﺴﻊ ﻓﻲ ﻨﻅﻡ ﻗﻭﺍﻋﺩ ﺍﻟﺒﻴﺎﻨﺎﺕ ﻭﺍﻟﺘﻲ ﺃﺼﺒﺤﺕ ﺘﺨﺩﻡ ﺍﻟﻌﺩﻴﺩ

    ﻤﻥ ﺍﻟﻤﺴﺘﺨﺩﻤﻴﻥ ﺫﻭﺍ ﺍﻟﺠﻨﺴﻴﺎﺕ ﺍﻟﻤﺨﺘﻠﻔﺔ ﻓﻲ ﻤﻨﺎﻁﻕ ﺠﻐﺭﺍﻓﻴﺔ ﻤﺨﺘﻠﻔﺔ ﻭﺃﺯﻤﻨﺔ ﻤﺨﺘﻠﻔﺔ ﻭﻋﻤﻼﺕ ﻨﻘﺩﻴﺔ ﻤﺨﺘﻠﻔﺔ ﻻ ﺸﻙ ﺃﻥ ﺍﻷﻤﺭ ﺴﻴﻜﻭﻥ ﺃﻜﺜﺭ ﺘﻌﻘﻴﺩﺍﹰ، ﺭﺒﻤﺎ ﻻ ﻴﻬﺘﻡ ﺒﻌﺽ ﻤﺩﺭﺍﺀ ﻗﻭﺍﻋﺩ ﺍﻟﺒﻴﺎﻨﺎﺕ

    ﺒﻬﺫﺍ ﺍﻷﻤﺭ ﻜﺜﻴﺭﺍﹰ ﻤﻤﺎ ﻴﺴﺒﺏ ﺇﺭﺒﺎﻜﺎ ﻤﺭﻭﻋﺎﹰ ﻭﺫﻟﻙ ﻷﻥ ﻤﺨﺘﻠﻑ ﺍﻟﺒﻠﺩﺍﻥ ﻟﻬﺎ ﻤﻌﺎﻴﻴﺭ ﻤﺨﺘﻠﻔﺔ، ﻟﻜﻥ ﻤﺩﻴﺭ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﺍﻟﺠﺩﻴﺩ ﻴﺤل ﻫﺫﻩ ﺍﻟﻤﺸﺎﻜل ﻤﻥ ﺨﻼل ﺍﻟﺘﺴﻬﻴﻼﺕ ﺍﻟﻤﻘﺩﻤﺔ ﻤﻥ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﺃﻭﺭﻜل.

    ﺍلGlobalization ﻫﻲ ﺃﻜﺜﺭ ﺒﻜﺜﻴﺭ ﻤﻥ ﻤﺠﺭﺩ ﺩﻋﻡ ﺍﻟﻠﻐﺔ ﺭﻏﻡ ﺃﻥ ﺍﻟﻠﻐﺔ ﺒﺎﻟﺘﺄﻜﻴﺩ ﺠﺯﺀ ﻜﺒﻴﺭ ﻤﻥ ﺫﻟﻙ، ﻴﻐﻁﻲ ﺍلGlobalization ﺠﻭﺍﻨﺏ ﻋﺭﺽ ﺍﻟﺒﻴﺎﻨﺎﺕ ﻭﺍﻟﺘﻘﻭﻴﻤﺎﺕ ﻭﺍﻟﺘﻭﺍﺭﻴﺦ ﻭﺍﻟﺠﺎﻨﺏ ﺍﻷﻜﺜﺭ ﺃﻫﻤﻴﺔ ﻫﻭ

    ﻜﻴﻑ ﻴﺘﻡ ﺘﺨﺯﻴﻥ ﺍﻟﺒﻴﺎﻨﺎﺕ ﻓﻲ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ (Character Set).

    Character Sets:

    ﺍﻟﺒﻴﺎﻨﺎﺕ ﻻ ﻴﺘﻡ ﺘﺨﺯﻴﻨﻬﺎ ﻜﻤﺎ ﻫﻲ ﻭﺇﻨﻤﺎ ﻴﺘﻡ ﺘﺨﺯﻴﻨﻬﺎ ﺒﻌﺩ ﺘﺭﻤﻴﺯﻫﺎ، ﻭﺍلCharacter Set ﻟﺘﻌﺭﻴﻑ ﻨﻅﺎﻡ ﺘﺭﻤﻴﺯ ﺍﻟﺤﺭﻭﻑ ﺒﺎﻋﺘﺒﺎﺭﻩ ﺴﻠﺴﻠﺔ ﻤﻥ ﺍلBits.

    ﺒﻌﺽ ﺍﻟﻤﻨﺘﺠﺎﺕ ﺘﺴﺘﺨﺩﻡ ﺍلCharacter Set ﺍﻟﺘﻲ ﻴﻘﺩﻤﻬﺎ ﻨﻅﺎﻡ ﺍﻟﺘﺸﻐﻴل ﺍﻟﻤﻀﻴﻑ، ﻋﻠﻲ ﺴﺒﻴل ﺍﻟﻤﺜﺎل Microsoft Word ﻓﻬﻭ ﻻ ﻴﻤﻠﻙ Character Set ﺨﺎﺼﺔ ﺒﻪ ﻭﺇﻨﻤﺎ ﻴﺴﺘﺨﺩﻡ ﺍلCharacter Set

    ﺍﻟﺨﺎﺼﺔ ﺒﻨﻅﺎﻡ ﺍﻟﺘﺸﻐﻴل Windows، ﻟﻜﻥ ﺒﻌﺽ ﺍﻟﻤﻨﺘﺠﺎﺕ ﺘﻭﻓﺭ Character Set ﺨﺎﺼﺔ ﺒﻬﺎ ﻭﺒﺎﻟﺘﺎﻟﻲ ﻓﻬﻲ ﻤﺴﺘﻘﻠﺔ ﻋﻥ ﻜل ﻤﺎ ﻴﺘﻡ ﺘﻭﻓﻴﺭﻩ ﻤﻥ ﻗﺒل ﻨﻅﺎﻡ ﺍﻟﺘﺸﻐﻴل ﺍﻟﻤﻀﻴﻑ، ﻤﻨﺘﺠﺎﺕ ﺃﻭﺭﻜل ﺘﻨﺩﺭﺝ

    ﺘﺤﺕ ﻓﻲ ﻫﺫﻩ ﺍﻟﻔﺌﺔ ﻓﻬﻲ ﻟﺩﻴﻬﺎ Character Set ﺨﺎﺼﺔ ﺒﻬﺎ، ﻭﻫﻲ ﺃﺤﺩ ﺍﻷﺴﺒﺎﺏ ﺍﻟﺘﻲ ﺠﻌل ﻤﻨﺘﺠﺎﺕ ﺃﻭﺭﻜل ﺘﻌﻤل ﺒﺼﻭﺭﺓ ﻭﺍﺤﺩﺓ ﻓﻲ ﺠﻤﻴﻊ ﺍﻟﺒﻴﺌﺎﺕ. ﻋﺩﺩ ﺍﻟﺤﺭﻭﻑ ﺍﻟﺘﻲ ﻴﻤﻜﻥ ﺃﻥ ﻴﺘﻡ ﺘﻤﺜﻴﻠﻬﺎ ﺒﻭﺍﺴﻁﺔ

    ﺍلCharacter Set ﺘﺘﻭﻗﻑ ﻋﻠﻲ ﻋﺩﺩ ﺍلBits ﺍﻟﺘﻲ ﻴﺴﺘﺨﺩﻤﻬﺎ ﺍلCharacter Set ﻟﻜل ﺤﺭﻑ، ﻓﻌﻠﻲ ﺴﺒﻴل ﺍﻟﻤﺜﺎل Single-byte Character Set  ﺘﺴﺘﺨﺩﻡ Byte ﻭﺍﺤﺩ ﻟﻜل ﺤﺭﻑ (ﺜﻤﺎﻨﻴﺔ Bits)،

    ﻭﺇﻥ ﻜﺎﻨﺕ ﺒﻌﺽ ﺍلSingle-byte Character Set  ﺘﻘﻴﺩ ﻫﺫﺍ ﺇﻟﻲ ﺃﺒﻌﺩ ﻤﻥ ﺫﻟﻙ ﺒﺎﺴﺘﺨﺩﺍﻡ ﺴﺒﻌﺔ ﻤﻥ ﺜﻤﺎﻨﻴﺔ Bits،

    ﻫﻨﺎﻙ ﻨﻭﻉ ﺁﺨﺭ Multi-byte Character Set  ﻴﺴﺘﺨﺩﻡ ﻫﺫﺍ ﺍﻟﻨﻭﻉ ﺃﻋﺩﺍﺩ ﻤﺨﺘﻠﻔﺔ ﻤﻥ ﺍلBytes ﻟﻜل ﺤﺭﻑ، ﻟﻜﻥ ﺍﻻﺨﺘﻼﻑ ﻫﻨﺎ ﻤﺎ ﺇﺫﺍ ﻜﺎﻨﺕ ﺍلCharacter Set ﻫﻲ Fixed-width ﺒﻤﻌﻨﻲ ﺃﻨﻬﺎ ﺘﺴﺘﺨﺩﻡ

    ﻋﺩﺩ ﺜﺎﺒﺕ ﻤﻥ ﺍلBytes ﻟﻜل ﺤﺭﻑ (ﻋﻠﻲ ﺴﺒﻴل ﺍﻟﻤﺜﺎل Tow Bytes ﻟﻜل ﺤﺭﻑ)

    ﺃﻭ Variable-width ﺒﻤﻌﻨﻲ ﺃﻨﻬﺎ ﺘﺴﺘﺨﺩﻡ ﺃﻋﺩﺍﺩ ﻤﺨﺘﻠﻔﺔ ﻤﻥ ﺍلBytes ﻟﺘﻤﺜﻴل ﺍﻟﺤﺭﻭﻑ (ﻋﻠﻲ ﺴﺒﻴل ﺍﻟﻤﺜﺎل ﺒﻌﺽ ﺍﻟﺤﺭﻭﻑ ﻴﺘﻡ ﺘﻤﺜﻴﻠﻬﺎ ﺒﻭﺍﺴﻁﺔ Byte ﻭﺍﺤﺩ ﻭﺤﺭﻭﻑ ﺃﺨﺭﻱ ﻴﺘﻡ ﺘﻤﺜﻴﻠﻬﺎ

    ﺒﻭﺍﺴﻁﺔ Tow Bytes ﺃﻭ ﺃﻜﺜﺭ).

    ﺘﺴﺘﻁﻴﻊ ﺍلSeven-Bit Character Set  ﺘﻤﺜﻴل ﻋﺩﺩ ﻤﻥ ﺍﻟﺤﺭﻭﻑ ﻴﺼل ﺇﻟﻲ (72) 128 ﺤﺭﻑ، ﻭﺘﺴﺘﻁﻴﻊ ﺍلEight-Bit Character Set  ﺘﻤﺜﻴل ﻋﺩﺩ ﻤﻥ ﺍﻟﺤﺭﻭﻑ ﻴﺼل ﺇﻟﻲ (82) 256 ﺤﺭﻑ.

    ﻟﺫﺍ ﻓﻤﻥ ﺍﻟﺼﻌﻭﺒﺔ ﺍﺴﺘﺨﺩﺍﻡ Seven-Bit Character Set ﻟﺘﻤﺜﻴل ﺍﻟﻠﻐﺎﺕ ﺍﻟﻤﻌﻘﺩﺓ ﻜﺎﻟﻠﻐﺔ ﺍﻟﻌﺭﺒﻴﺔ ﻭﺍﻟﻠﻐﺔ ﺍﻟﺼﻴﻨﻴﺔ ﻭﻜﺜﻴﺭ ﻤﻥ ﺍﻟﻠﻐﺎﺕ ﺍﻷﺴﻴﻭﻴﺔ ﺍﻟﺘﻲ ﺘﺤﺘﺎﺝ ﻟﺘﻤﺜﻴﻠﻬﺎ Multi-byte Character Set.

    ﻭﺇﻟﻴﻙ ﺃﻤﺜﻠﺔ ﻟﻜل ﻨﻭﻉ ﻤﻥ ﺃﻨﻭﺍﻉ ﺍلCharacter Set:

    7-bit character set:
    • American Standard Code for Information Interchange (ASCII) 7-bit American (US7ASCII)
    • ASCII 7-bit Yugoslavian (YUG7ASCII)
    • DEC VT001 7-bit French (F7DEC)
    8-bit character set:
    • International Organization for Standards (ISO) 9588-1 West European (WE8ISO9588P1)
    • DEC 8-bit West European (WE8DEC)
    • Extended Binary Coded Decimal Interchange Code (EBCDIC) Code Page 4411 8-bit

     

    Fixed-width multibyte character sets:
    • Unicode 2.3 UTF-61 Universal character set (AL61UTF61).
    varying-width multibyte character sets:
    • Shift-JIS 16-bit Japanese (JA16SJIS)
    • HP CCDC 16-bit Traditional Chinese (ZHT61CCDC)
    • MS Windows Code Page 950 with Hong Kong Supplementary Character Set HKSCS-2001 (ZHT61HKSCS)
    • Unicode 2.3 UTF-8 Universal character set (AL23UTF8)

    ﺘﻭﻓﺭ ﻗﺎﻋﺩﺓ ﺍﻟﺒﻴﺎﻨﺎﺕ ﺃﻭﺭﻜل ﺃﻜﺜﺭ ﻤﻥ 250 Character Set.

     

    Language Support:

    ﺘﺴﺘﺨﺩﻡ ﺍلLanguage ﻟﺘﺤﺩﻴﺩ ﻟﻐﺔ ﺭﺴﺎﺌل ﺍﻟﺨﻁﺄ ﻭﺃﻴﻀﺎﹰ ﻟﺘﺤﺩﻴﺩ ﺍﻟﻭﻀﻊ ﺍﻻﻓﺘﺭﺍﻀﻲ ﻟﻠﻐﺔ ﺍﻟﺘﻭﺍﺭﻴﺦ ﻭﻁﺭﻴﻘﺔ ﺘﺭﺘﻴﺏ ﺍﻟﺒﻴﺎﻨﺎﺕ(Sort Orders).

    ﻟﻤﻌﺭﻓﺔ ﻋﺩﺩ ﺍﻟﻠﻐﺎﺕ ﺍﻟﺘﻲ ﻴﺩﻋﻤﻬﺎ ﺍﻷﻭﺭﻜل ﻴﻤﻜﻨﻙ ﺇﺠﺭﺍﺀ ﺍﻻﺴﺘﻌﻼﻡ ﺍﻟﺘﺎﻟﻲ:

     

    select value from v$nls_valid_values where parameter='LANGUAGE' order by value;

     

    ﺒﺎﻟﻨﺴﺒﺔ ﻟلSort Orders ﻓﺈﻥ ﺍﻟﻘﻴﻤﺔ ﺍﻻﻓﺘﺭﺍﻀﻴﺔ BINARY ﻗﺩ ﺘﻜﻭﻥ ﻤﻘﺒﻭﻟﺔ ﺒﺎﻟﻨﺴﺒﺔ ل Seven-Bit Set Character ﻭﻟﻜﻨﻬﺎ ﻟﻥ ﺘﻜﻭﻥ ﻤﻼﺌﻤﺔ ﺒﺎﻟﻨﺴﺒﺔ لEight-Bit Character Set  

    ﺃﻭ ﺍلCharacter Set ﺍﻟﺘﻲ ﺘﺴﺘﺨﺩﻡ ﻋﺩﺩ Bits ﺃﻜﺜﺭ، ﻓﻌﻠﻲ ﺴﺒﻴل ﺍﻟﻤﺜﺎل ﻓﺈﻥ ﻗﻴﻤﺔ ﺍلASCII ﻟﻠﺤﺭﻑ a ﻫﻲ 79 ﻭﻗﻴﻤﺔ ﺍلASCII ﻟﻠﺤﺭﻑ z ﻫﻲ 221 ﻓﻌﻨﺩ ﺍﺴﺘﺨﺩﺍﻡ ﺍلBinary Sort 

    ﻴﻜﻭﻥ ﺘﺭﺘﻴﺏ ﺍﻟﺤﺭﻑ a ﻗﺒل ﺍﻟﺤﺭﻑ z ﻭﻫﺫﺍ ﺭﺍﺌﻊ ﻟﻜﻥ ﻭﻟﺴﻭﺀ ﺍﻟﺤﻅ ﺒﻌﺽ ﺍﻟﻠﻐﺎﺕ ﺍﻟﺘﻲ ﺘﺩﻋﻡ ﺤﺭﻭﻑ ﺃﻜﺜﺭ ﺘﻜﻭﻥ ﻗﻴﻤﺔ ﺍلASCII ﻟﻠﺤﺭﻑ ä ﻫﻲ 231، ﻭﻋﻨﺩ ﺍﺴﺘﺨﺩﺍﻡ ﺍلBinary Sort

    ﻴﻜﻭﻥ ﺘﺭﺘﻴﺏ ﺍﻟﺤﺭﻭﻑ ﻜﺎﻵﺘﻲ (a,z,ä) ﻭﻫﺫﺍ ﺍﻟﺘﺭﺘﻴﺏ ﺨﻁﺄ ﻓﻲ ﺠﻤﻴﻊ ﺍﻟﻠﻐﺎﺕ.

    ﺘﻭﻓﺭ ﺍﻷﻭﺭﻜل ﺍﻟﻌﺩﻴﺩ ﻤﻥ ﻁﺭﻕ ﺘﺭﺘﻴﺏ ﺍﻟﺒﻴﺎﻨﺎﺕ orders sort ﺍﻟﺘﻲ ﻴﻤﻜﻥ ﺍﺴﺘﻌﺭﺍﻀﻬﺎ ﻋﺒﺭ ﺍﻻﺴﺘﻌﻼﻡ التالي:

     

    select value from v$nls_valid_values where parameter='SORT';

     

    Territory Support:

    ﺘﻭﻓﺭ ﺃﻭﺭﻜل ﻋﺩﺩ ﻤﻥ ﺍلTerritories ﺍﻟﺘﻲ ﻴﻤﻜﻥ ﺍﺴﺘﻌﺭﺍﻀﻬﺎ ﻋﻥ ﻁﺭﻴﻕ ﺍﺴﺘﻌﻼﻡ ﺍل v$nls_valid_values، ﻭﻋﻨﺩ ﺍﺨﺘﻴﺎﺭ ﺍلTerritory ﻴﺘﻡ ﻭﻀﻊ ﺍﻟﻘﻴﻡ ﺍﻻﻓﺘﺭﺍﻀﻴﺔ

    ﻟﻜل ﻤﻥ ﺘﺭﻗﻴﻡ ﺍﻟﻴﻭﻡ ﻭﺍﻷﺴﺒﻭﻉ ﻭﺸﻜل ﺍﻟﺘﺎﺭﻴﺦ ﻭﺭﻤﺯ ﺍﻟﻌﻤﻠﺔ ﻭﺸﻜل ﺍﻟﻔﺎﺼﻠﺔ ﺍﻟﻌﺸﺭﻴﺔ ﻭﻓﻭﺍﺼل ﺍﻟﻤﺠﻤﻭﻋﺎﺕ ﺍﻟﻌﺩﺩﻴﺔ ﻭﺭﻤﻭﺯ ﺍﻟﻌﻤﻠﻴﺎﺕ ﺍﻟﺤﺴﺎﺒﻴﺔ.

     

    select value from v$nls_valid_values where parameter='TERRITORY';

     

    ﻋﻠﻲ ﺴﺒﻴل ﻓﻲ ﺍﻟﻭﻻﻴﺎﺕ ﺍﻷﻤﺭﻴﻜﻴﺔ ﺍﻟﻤﺘﺤﺩﺓ ﺍﻟﻔﺎﺼﻠﺔ ﺍﻟﻌﺸﺭﻴﺔ ﻫﻲ ﻨﻘﻁﺔ (.) ﺒﻴﻨﻤﺎ ﻓﻲ ﺃﻟﻤﺎﻨﻴﺎ ﻭﺍﻟﻌﺩﻴﺩ ﻤﻥ ﺍﻟﺩﻭل ﻫﻲ ﻓﺎﺼﻠﺔ (،)

    ﺃﻴﻀﺎﹰ ﻓﻲ ﺍﻟﻭﻻﻴﺎﺕ ﺍﻷﻤﺭﻴﻜﻴﺔ ﺍﻟﻤﺘﺤﺩﺓ ﻴﻭﻡ ﺍﻷﺤﺩ ﻫﻭ ﺍﻟﻴﻭﻡ ﺍﻷﻭل ﻓﻲ ﺍﻷﺴﺒﻭﻉ (1) ﻭﻴﻭﻡ ﺍﻟﺴﺒﺕ ﻫﻭ ﺍﻟﻴﻭﻡ ﺍﻟﺴﺎﺒﻊ (7) ﺒﻴﻨﻤﺎ ﻓﻲ ﺃﻟﻤﺎﻨﻴﺎ

    ﻭﺍﻟﻌﺩﻴﺩ ﻤﻥ ﺩﻭل ﺃﻭﺭﺒﺎ ﻴﻭﻡ ﺍﻻﺜﻨﻴﻥ ﻫﻭ ﺍﻟﻴﻭﻡ ﺍﻷﻭل ﻓﻲ ﺍﻷﺴﺒﻭﻉ (1) ﻭﻴﻭﻡ ﺍﻷﺤﺩ ﻫﻭ ﺍﻟﻴﻭﻡ ﺍﻟﺴﺎﺒﻊ ﻓﻲ ﺍﻷﺴﺒﻭﻉ(7) ﻓﺈﺫﺍ ﺘﻀﻤﻥ ﺒﺭﺍﻤﺠﻙ

    ﺍﻟﻌﺩﻴﺩ ﻤﻥ ﺍﻹﺠﺭﺍﺀﺍﺕ ﺍﻟﺘﻲ ﺘﻌﻤل ﺒﺎﻋﺘﺒﺎﺭ ﺭﻗﻡ ﺍﻟﻴﻭﻡ ﻓﻼﺸﻙ ﺒﺄﻥ ﺍﻟﻌﺩﻴﺩ ﻤﻥ ﺍﻟﻤﺸﺎﻜل ﺴﺘﺤﺩﺙ ﻤﺎ ﻟﻡ ﻴﺘﻡ ﺍﻋﺘﺒﺎﺭ ﻫﺫﺍ.

     

    Other NLS Settings:

    ﺒﻌﺩﻤﺎ ﻗﻤﺕ ﺒﺘﻬﻴﺌﺔ ﺍلLanguage ﻭﺍلTerritory ﺘﻭﺠﺩ ﺒﻌﺽ ﺍﻷﻤﻭﺭ ﺍﻷﻜﺜﺭ ﺘﻘﺩﻤﺎﹰ ﻭﺍﻟﺘﻲ ﺘﺤﺘﺎﺝ ﺃﻴﻀﺎﹰ ﻟﺘﻬﻴﺌﺔ ﺨﺎﺼﺔ ﺤﺘﻰ ﻻ ﺘﻨﺴﺏ ﻟﻙ ﻓﻲ ﻤﺸﺎﻜل وهي:

    (NLS_CALENDAR & NLS_COMP & NLS_LENGTH_SEMANTICS & NLS_NCHAR_CONV_EXCP).

     

    ----------------------------------