Oracle多条语句运行不正确

发布于 2024-12-06 04:15:59 字数 405 浏览 1 评论 0原文

我有一个包含 3 个“创建类型”语句的文件。我不明白为什么当我运行脚本时它只创建第一种类型。当我打开创建的类型时，我会看到里面的所有三个创建语句。我在这里缺少什么？

代码：

create type SplitPathTableType as table of varchar2(450);

create TYPE TSMNodesRecord AS OBJECT (
NodeID number(20),
IsDataNode number(1),
Path nvarchar2 (450),
ParentID number(20),
TimeStep number(20)
);

create type TSMNODESTABLE as table of TSMNODESRECORD;

原文

I have a file with 3 "create type" statements. I do not understand why, when I run the script it creates only the first type. When I open created type I see all three create statements inside. What am I missing here?

CODE:

create type SplitPathTableType as table of varchar2(450);

create TYPE TSMNodesRecord AS OBJECT (
NodeID number(20),
IsDataNode number(1),
Path nvarchar2 (450),
ParentID number(20),
TimeStep number(20)
);

create type TSMNODESTABLE as table of TSMNODESRECORD;

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

另类 2024-12-13 04:15:59

您需要 / 在每个语句之后...

create type SplitPathTableType as table of varchar2(450);
/

create TYPE TSMNodesRecord AS OBJECT (
NodeID number(20),
IsDataNode number(1),
Path nvarchar2 (450),
vParentID number(20),
TimeStep number(20)
);
/

create type TSMNODESTABLE as table of TSMNODESRECORD;
/

You need / after each statement...

create type SplitPathTableType as table of varchar2(450);
/

create TYPE TSMNodesRecord AS OBJECT (
NodeID number(20),
IsDataNode number(1),
Path nvarchar2 (450),
vParentID number(20),
TimeStep number(20)
);
/

create type TSMNODESTABLE as table of TSMNODESRECORD;
/

回复收藏 0 原文

~没有更多了~