... 行对象:create table employee of employee_type; 列对象:create table department( 3.对象类型继承:TYPE INHERITANCE ...
基于6个网页-相关网页
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)。
Next, let? S create our DEPARTMENT table with the command.
接下来，用以下命令创建department表。
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.
当然，对于特定于部门的表，还可以使用部门或公司名作为模式。
应用推荐