• Getting Started
  • Oracle Cloud Infrastructure Cloud Adoption Framework
  • Oracle Cloud's Free Tier
  • Oracle Multicloud
  • Oracle Cloud Infrastructure Government Cloud
  • Oracle EU Sovereign Cloud
  • Applications Services
  • Infrastructure Services
    • Service Essentials
    • Access Governance
    • Analytics Cloud
    • API Gateway
    • Application Dependency Management
    • Application Performance Monitoring
    • Archive Storage
    • Artifact Registry
    • Audit
    • Automated CEMLI Execution
    • Autonomous Linux
    • Bastion
    • Big Data Service
    • Billing and Cost Management
    • Block Volume
    • Blockchain Platform
    • Certificates
    • Cloud Advisor
    • Cloud Guard
    • Cluster Placement Groups
    • Compartment Quotas
    • Compliance Documents
    • Compute
    • Compute Cloud@Customer
    • Connector Hub
    • Console Dashboards
    • Container Instances
    • Container Registry
    • Content Management
    • Data Catalog
    • Data Flow
    • Data Integration
    • Data Labeling
    • Data Safe
    • Data Science
    • Database
    • Database Management
    • Database Migration
    • Database Tools
      • About Database Tools
      • Creating a Connection
      • Managing a Connection
      • Using Private Endpoints with Database Tools
      • Using Database Actions
        • Accessing Database Actions
        • The Home Page - Launchpad
        • Development
          • Using SQL Worksheet
            • About the SQL Worksheet
              • Using the Object Navigator and Files Tab
              • Running SQL, PL/SQL and JavaScript Code in the Worksheet Editor
              • Viewing the SQL Worksheet Output
              • Creating and Editing Database Objects
              • Loading Data
                • Loading Data from a Local File to a New Table
                • Loading Data from a Local File to an Existing Table
                • Loading Data from Multiple Local Files into Mutiple Tables
            • Using the Oracle Cloud Infrastructure Console
          • Using Data Modeler
          • Using Liquibase
          • Using Scheduling
        • Administration
        • Monitoring
      • Database Tools Policies
      • Best Practices for Using Database Tools
      • Troubleshooting Connections
      • Database Tools API Reference
      • SDK Examples
      • Database Tools Events
      • Supported SQL*Plus and SQLcl Commands in SQL Worksheet
    • DevOps
    • Digital Assistant
    • Disaster Recovery
    • DNS and Traffic Management
    • Document Understanding
    • Email Delivery
    • Events
    • File Storage
    • New File Storage with Lustre
    • Fleet Application Management
    • Functions
    • Fusion Data Intelligence
    • Generative AI
    • Generative AI Agents
    • Globally Distributed Exadata Database on Exascale Infrastructure
    • GoldenGate
    • Health Checks
    • HeatWave
    • IAM with Identity Domains
    • IAM without Identity Domains
    • Integration 3
    • Integration Generation 2
    • Java Management
    • Kubernetes Engine
    • Language
    • Load Balancer
    • Logging
    • Logging Analytics
    • Managed Access
    • Managed Cloud Self Service Platform
    • Managed Services for Mac
    • Management Agent
    • Management Dashboard
    • Media Services
    • Monitoring
    • Network Firewall
    • Network Load Balancer
    • Networking
    • NoSQL Database
    • Notifications
    • Object Storage
    • OCI Cache
    • OCI Control Center
    • OCI Database with PostgreSQL
    • OpenShift Container Platform on OCI
    • Ops Insights
    • Oracle APEX Application Development
    • Oracle Cloud Migrations
    • Oracle Linux
    • OS Management Hub
    • Process Automation
    • Pulse
    • Queue
    • Resource Manager
    • Resource Scheduler
    • Roving Edge Infrastructure
    • Search
    • Search with OpenSearch
    • Secure Desktops
    • Security Advisor
    • Security Zones
    • Service Catalog
    • Speech
    • Stack Monitoring
    • Streaming
    • Tagging
    • Threat Intelligence
    • Vault
    • Vision
    • Visual Builder
    • Visual Builder Studio
    • VMware Solution
    • Vulnerability Scanning
    • Web Application Acceleration
    • Web Application Firewall
    • WebLogic Management (Pre-GA)
    • Zero Trust Packet Routing
  • Developer Resources
  • Security
  • Marketplace
  • More Resources
  • Glossary
  • Oracle Cloud Console
Oracle Cloud
  • Getting Started with Oracle Cloud Infrastructure
  • Cloud Adoption Framework
  • Multicloud
  • Oracle Cloud Infrastructure Government Cloud
  • Applications Services
  • Infrastructure Services
  • Developer Resources
  • Security
  • Marketplace
  • More Resources
  • Oracle Cloud Console
  • Cloud Applications Documentation
  • Oracle.com Home
  • Oracle Help Center Home
Search

Oracle Cloud Infrastructure Documentation


Infrastructure ServicesDatabase ToolsUsing Database ActionsDevelopmentUsing SQL WorksheetAbout the SQL Worksheet
  • Getting Started
  • Oracle Cloud Infrastructure Cloud Adoption Framework
  • Oracle Cloud's Free Tier
  • Oracle Multicloud
  • Oracle Cloud Infrastructure Government Cloud
  • Oracle EU Sovereign Cloud
  • Applications Services
  • Infrastructure Services
    • Service Essentials
    • Access Governance
    • Analytics Cloud
    • API Gateway
    • Application Dependency Management
    • Application Performance Monitoring
    • Archive Storage
    • Artifact Registry
    • Audit
    • Automated CEMLI Execution
    • Autonomous Linux
    • Bastion
    • Big Data Service
    • Billing and Cost Management
    • Block Volume
    • Blockchain Platform
    • Certificates
    • Cloud Advisor
    • Cloud Guard
    • Cluster Placement Groups
    • Compartment Quotas
    • Compliance Documents
    • Compute
    • Compute Cloud@Customer
    • Connector Hub
    • Console Dashboards
    • Container Instances
    • Container Registry
    • Content Management
    • Data Catalog
    • Data Flow
    • Data Integration
    • Data Labeling
    • Data Safe
    • Data Science
    • Database
    • Database Management
    • Database Migration
    • Database Tools
      • About Database Tools
      • Creating a Connection
      • Managing a Connection
      • Using Private Endpoints with Database Tools
      • Using Database Actions
        • Accessing Database Actions
        • The Home Page - Launchpad
        • Development
          • Using SQL Worksheet
            • About the SQL Worksheet
              • Using the Object Navigator and Files Tab
              • Running SQL, PL/SQL and JavaScript Code in the Worksheet Editor
              • Viewing the SQL Worksheet Output
              • Creating and Editing Database Objects
              • Loading Data
                • Loading Data from a Local File to a New Table
                • Loading Data from a Local File to an Existing Table
                • Loading Data from Multiple Local Files into Mutiple Tables
            • Using the Oracle Cloud Infrastructure Console
          • Using Data Modeler
          • Using Liquibase
          • Using Scheduling
        • Administration
        • Monitoring
      • Database Tools Policies
      • Best Practices for Using Database Tools
      • Troubleshooting Connections
      • Database Tools API Reference
      • SDK Examples
      • Database Tools Events
      • Supported SQL*Plus and SQLcl Commands in SQL Worksheet
    • DevOps
    • Digital Assistant
    • Disaster Recovery
    • DNS and Traffic Management
    • Document Understanding
    • Email Delivery
    • Events
    • File Storage
    • New File Storage with Lustre
    • Fleet Application Management
    • Functions
    • Fusion Data Intelligence
    • Generative AI
    • Generative AI Agents
    • Globally Distributed Exadata Database on Exascale Infrastructure
    • GoldenGate
    • Health Checks
    • HeatWave
    • IAM with Identity Domains
    • IAM without Identity Domains
    • Integration 3
    • Integration Generation 2
    • Java Management
    • Kubernetes Engine
    • Language
    • Load Balancer
    • Logging
    • Logging Analytics
    • Managed Access
    • Managed Cloud Self Service Platform
    • Managed Services for Mac
    • Management Agent
    • Management Dashboard
    • Media Services
    • Monitoring
    • Network Firewall
    • Network Load Balancer
    • Networking
    • NoSQL Database
    • Notifications
    • Object Storage
    • OCI Cache
    • OCI Control Center
    • OCI Database with PostgreSQL
    • OpenShift Container Platform on OCI
    • Ops Insights
    • Oracle APEX Application Development
    • Oracle Cloud Migrations
    • Oracle Linux
    • OS Management Hub
    • Process Automation
    • Pulse
    • Queue
    • Resource Manager
    • Resource Scheduler
    • Roving Edge Infrastructure
    • Search
    • Search with OpenSearch
    • Secure Desktops
    • Security Advisor
    • Security Zones
    • Service Catalog
    • Speech
    • Stack Monitoring
    • Streaming
    • Tagging
    • Threat Intelligence
    • Vault
    • Vision
    • Visual Builder
    • Visual Builder Studio
    • VMware Solution
    • Vulnerability Scanning
    • Web Application Acceleration
    • Web Application Firewall
    • WebLogic Management (Pre-GA)
    • Zero Trust Packet Routing
  • Developer Resources
  • Security
  • Marketplace
  • More Resources
  • Glossary
  • Oracle Cloud Console
Skip to main content

Loading Data

Note

This feature is not available for MySQL database services.
In SQL Worksheet, you can load data from one or more local files into one or more tables.

The file formats that you can load are CSV, XLS, XLSX, TSV, and TXT.

  • Loading Data from a Local File to a New Table

  • Loading Data from a Local File to an Existing Table

  • Loading Data from Multiple Local Files into Mutiple Tables

  • Copyright © 2025, Oracle and/or its affiliates.
  • About Oracle
  • Contact Us
  • Legal Notices
  • Terms of Use & Privacy
  • Document Conventions
  • Cookie Preferences