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)。

youdao

Next, let? S create our DEPARTMENT table with the command.

接下来，用以下命令创建department表。

youdao

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.

当然，对于特定于部门的表，还可以使用部门或公司名作为模式。

youdao

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.

当然，对于特定于部门的表，还可以使用部门或公司名作为模式。

youdao