Skip to content

mailrun/oracleSampleSQL

BranchesTags

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

15 Commits
LICENSE
LICENSE
 
 
README.md
README.md
 
 
complexExamples_cn.md
complexExamples_cn.md
 
 
complexExamples_en.md
complexExamples_en.md
 
 
sampleSQL_cn.md
sampleSQL_cn.md
 
 
sampleSQL_en.md
sampleSQL_en.md
 
 

Repository files navigation

oracle Sample SQL

  • Oracle 数据库的 SH（Sales History）schema 是一个常用的示例数据库，它包含与销售相关的数据，包括产品、客户、渠道、促销、时间和销售事实表等。
  • 基于这些表和视图，可以提出很多业务层面的问题。
  • 这个文档基于这份数据集给出一些常见语义场景下（业务分析、决策支持和绩效评估）的SQL脚本，可以用于Select AI测试场景。
  • 以上SQL示例已经在ADB数据库上测试通过。
  • 现在暂时仅有SH Schema的示例SQL。
  • The SH (Sales History) schema of Oracle database is a commonly used sample database that contains sales-related data, including product, customer, channel, promotion, time, and sales fact tables.
  • Based on these tables and views, many business-level questions can be raised.
  • Based on this dataset, this document provides some SQL scripts for common semantic scenarios (business analysis, decision support, and performance evaluation), which can be used in Select AI test scenarios.
  • The above SQL examples have been tested on the ADB database.
  • Currently, there is only sample SQL for SH Schema.

    • About

    oracle Sample SQL

    Resources

    Readme

    License

    Apache-2.0 license
    Activity

    Stars

    2 stars

    Watchers

    1 watching

    Forks

    1 fork
    Report repository

    Releases

    No releases published

    Packages

     
     
     

    Contributors