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.