For this example, choose the Department table.
例如，选择Department表格。
Next, let? S create our DEPARTMENT table with the command.
接下来，用以下命令创建department表。
For this example scenario, the Department table was selected.
对于这个样例场景，被选择的是Department表。
Selecting the DEPARTMENT table will show the fields in the table.
选择DEPARTMENT表将显示这个表中的字段。
The sample output above shows that the DEPARTMENT table has three indexes.
以上的样例输出显示了department表有3个索引。
Figure 1 shows the entire Department table, along with the corresponding entity class.
图1显示出了整个的department表，以及相应的实体类。
Specifically, you can write the SELECT command to select all fields from the DEPARTMENT table.
具体地说，您可以编写从DEPARTMENT表中选择所有字段的SELECT命令。
For example, in our department table below, we use one XML document per department (medium granularity).
例如，在下面的部门表中，我们为每个部门使用一个XML文档（中等粒度）。
The WORKDEPT field was only used as linking field to the DEPARTMENT table, and has no meaningful value by itself.
WORKDEPT 字段只用作 DEPARTMENT表的链接字段，本身的值没有意义。
The WORKDEPT field of the EMPLOYEE table obviously pointed to the DEPARTMENT table, using the DEPTNO field to link to.
EMPLOYEE表的WORKDEPT字段显然指向DEPARTMENT 表，使用DEPTNO 字段可以链接到该表。
And follow up with populating the DEPARTMENT table with the data delineated in table 2 with an INSERT command such as.
再通过如下insert命令用表2给出的数据填充DEPARTMENT填充。
In the database design above, according to the needs, I design role table, users table, document table, department table, message table, employ table.
在数据库的设计上面，根据系统的需要，设计了角色表、用户表、部门表、文档表、员工表、短信表。
And finally, the department table has a ADMRDEPT field which is a circular link to itself (identifying departments that manage other departments).
最后，department表有一个ADMRDEPT字段，该字段是到其自身的一个循环链接(标识管理其他部门的部门)。
But as you can see for the DEPARTMENT table, value compression can be beneficial, even if the alternate row format of value compression causes some overhead.
然而，正如您所看到的，对于DEPARTMENT表，虽然值压缩行格式会导致一些开销，但是值压缩的确是有益的。
In the Data dialog box shown in Figure 13, select the table that you want to use to generate the report from the tables available in your schema. For this example, choose the Department table.
在图13所示的Data对话框中，选择在您的计划中想要用来从可用表格产生报告的表格，我们这里选择Department表。
This way we can bind any value of the department number column from the ORG table.
采用这种方法，就可以对org表的部门编号列的任何值查询位置了。
By default, a nested data table of employees will be added for each department entry.
默认条件下，每一个部门都会被添加一个员工数据表。
First, let's create a simple stored procedure SP_GET_LOC that returns the location for a given department from the table ORG (step 1).
首先，创建一个简单的存储过程SP_GET _ LOC，它从表org中返回某个给定部门的位置(步骤1)。
In the sessions, try to update location data and department names in the table department in parallel.
在会话中，试着同时更新department表中的位置数据和部门名称。
The report data comes from four dimension tables PROJECT, DEPARTMENT, ACTIVITY, D_TIME and one fact table HUMANCOST.
报告数据来自四个维度表project、DEPARTMENT、ACTIVITY、D _ TIME和一个事实表humancost。
The report data comes from four dimension tables: PROJECT, DEPARTMENT, ACTIVITY, D_TIME; and one fact table: HUMANCOST.
报表数据来自四个维度表：PROJECT、DEPARTMENT、ACTIVITY、D_TIME和一个事实表HUMANCOST。
Each row of the dept table describes one department of a fictitious company.
dept表的每一个行都描述了一家虚构企业的一个部门。
The table, which is named EMP, is based on the underlying tables EMPLOYEE and DEPARTMENT in the SAMPLE database.
这个表名为EMP，它基于SAMPLE数据库中的底层表employee和DEPARTMENT。
You do not want to display the Department details in a detail table.
您可能不想在一个细节表中显示Department细节。
One of the junior colleagues in our department nicely organizes the newspapers on the table.
办公室里资历较浅的人把报纸整理好放在桌子上。
At the Treasury Department, Summers's office had a large conference table, with a seating area behind it.
在财务部，萨默斯的办公室有一个很大的会议桌，会议桌后面是一个座位区。
The stakeholders in the business department delivered requirements in form of Microsoft Word tables, with one table for each requirement.
业务部门的出资方提供了MicrosoftWord表格形式的需求，每一张表格提出一项需求。
To gain more insight, a similar interaction plot was created for Department B, using the factors in the table below.
为了加深认识，运用类似的分析方法对B部门进行分析，因子如下表。
For a department-specific table, you can also use the department or company name as schema, of course. To create a table called PERSON in my schema, I have to execute the following SQL command.
当然，对于特定于部门的表，还可以使用部门或公司名作为模式。
For a department-specific table, you can also use the department or company name as schema, of course. To create a table called PERSON in my schema, I have to execute the following SQL command.
当然，对于特定于部门的表，还可以使用部门或公司名作为模式。
应用推荐