{"id":1381,"date":"2024-01-15T21:47:03","date_gmt":"2024-01-15T13:47:03","guid":{"rendered":"http:\/\/pipingpig.com\/index.php\/2024\/01\/15\/smart3d-0545\/"},"modified":"2026-08-20T18:19:29","modified_gmt":"2026-08-20T10:19:29","slug":"smart3d-0545","status":"publish","type":"post","link":"https:\/\/www.pipingpig.com\/index.php\/2024\/01\/15\/smart3d-0545\/","title":{"rendered":"\u5728\u6750\u6599\u63cf\u8ff0\u91cc\u5e94\u7528\u81ea\u5b9a\u4e49Label"},"content":{"rendered":"
\n

\u6700\u8fd1\u63a5\u5230\u7528\u6237\u7684\u4e00\u4e2a\u95ee\u9898\uff0c\u5e0c\u671b\u5c06\u58c1\u539a\u4fe1\u606f\u6dfb\u52a0\u5230\u63cf\u8ff0\u91cc\uff0c\u4f46\u662f\u5efa\u5e93\u662f\u591a\u5c3a\u5bf8\u5171\u7528\u4e00\u4e2aCC\u7801\uff0c\u6ca1\u529e\u6cd5\u76f4\u63a5\u5c06\u58c1\u539a\u5199\u5165\u6750\u6599\u63cf\u8ff0\u91cc\u3002<\/p>\n

\u53ef\u4ee5\u4f7f\u7528Label \u6293\u53d6\u4fe1\u606f\u7684\u65b9\u5f0f\uff0c\u5c06\u6240\u9700\u4fe1\u606f\u663e\u793a\u5728\u63cf\u8ff0\u91cc\uff0c\u5177\u4f53\u64cd\u4f5c\u5982\u4e0b\uff1a<\/p>\n

\u521b\u5efa\u4e00\u4e2a\u5305\u542b\u6240\u9700\u4fe1\u606f\u7684 Label\uff1a<\/p>\n

<\/p>\n

\u5982\u679c\u76f4\u63a5\u5c06Lable\u540d\u5b57[TEST]\u5199\u5728\u63cf\u8ff0\u5355\u5143\u683c\u4e2d\uff0c\u5728\u4f7f\u7528\u63cf\u8ff0\u751f\u6210\u62a5\u8868\u548cISO\u56fe\u4e2d\u663e\u793aLabel\u7684\u5185\u5bb9\u662f\u6ca1\u95ee\u9898\u7684\uff0c\u4f46\u662f\u5728\u6a21\u578b\u4e2d\u67e5\u770b\u5c5e\u6027\u7684\u65f6\u5019\u53ea\u80fd\u770b\u5230Label\u7684\u540d\u5b57\uff1a<\/p>\n

<\/p>\n

<\/p>\n

\u662f\u56e0\u4e3abulkload\u8868\u91cc\u5f15\u7528\u7684\u662fLabel\u540e\u53f0\u7684\u540d\u5b57\uff0c\u800c\u4e3a\u4e86\u4fdd\u8bc1\u540d\u5b57\u7684\u552f\u4e00\u6027<\/span>\uff0c\u5728\u751f\u6210Label\u540e\u53f0\u540d\u5b57\u7684\u65f6\u5019\u4f1a\u6dfb\u52a0\u5e8f\u5217\u53f7\uff0c\u67e5\u8be2Label\u540e\u53f0\u540d\u5b57\u7684\u8bed\u53e5\u5982\u4e0b\uff1a<\/p>\n

SQL\u6570\u636e\u5e93\uff1a<\/p>\n

select ObjectName from CORENamedObjects j1
join JReport j2 on j1.ObjectOid = j2.oid where\u00a0j2.Name\u00a0= 'label name'<\/pre>\n
Oracle \u6570\u636e\u5e93\uff1a<\/pre>\n
select j1.ObjectName from 'Catalog database'<\/span><\/strong>.CORENamedObjects j1
join XXX_CDB.JReport j2 on j1.ObjectOid = j2.oid where\u00a0j2.Name\u00a0= 'label name'<\/p><\/pre>\n
\u67e5\u8be2\u7ed3\u679c\u5982\u4e0b\uff1a<\/span><\/p>\n
<\/p>\n
1. \u53ef\u4ee5\u5c06Label\u540e\u53f0\u540d\u5b57\u5199\u5165bulkload\u63cf\u8ff0\u5355\u5143\u683cM\u4e00\u904d\uff1b<\/p>\n
2. \u4e5f\u53ef\u4ee5\u4f7f\u7528\u8bed\u53e5\u5c06\u540e\u53f0\u540d\u5b57\u4fee\u6539\u4e3a\u4e0e\u663e\u793a\u540d\u5b57\u76f8\u540c\uff1a<\/p>\n
update CORE<\/span>NamedObjects set ObjectName='TEST'\u00a0\u00a0
<\/span><\/pre>\n
where ObjectOid=’XXX’\u00a0 –XXX\u662f\u4e0a\u9762\u67e5\u8be2\u51fa\u6765<\/span><\/p>\n
<\/p>\n
<\/p>\n
\u4ee5\u4e0a\u4e24\u79cd\u65b9\u6cd5\u90fd\u53ef\u4ee5\u4f7fLabeld \u5185\u5bb9\u663e\u793a\u5728S3D\u6a21\u578b\u4e2d\uff1a<\/p>\n
<\/p>\n
<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"
\u6700\u8fd1\u63a5\u5230\u7528\u6237\u7684\u4e00\u4e2a\u95ee\u9898\uff0c\u5e0c\u671b\u5c06\u58c1\u539a\u4fe1\u606f\u6dfb\u52a0\u5230\u63cf\u8ff0\u91cc\uff0c\u4f46\u662f\u5efa\u5e93\u662f\u591a\u5c3a\u5bf8\u5171\u7528\u4e00\u4e2aCC\u7801\uff0c\u6ca1\u529e\u6cd5\u76f4\u63a5\u5c06\u58c1\u539a\u5199\u5165\u6750\u6599\u63cf […]<\/p>\n","protected":false},"author":1,"featured_media":1374,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"footnotes":""},"categories":[9,10],"tags":[],"class_list":["post-1381","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-smart3d","category-10"],"_links":{"self":[{"href":"https:\/\/www.pipingpig.com\/index.php\/wp-json\/wp\/v2\/posts\/1381","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.pipingpig.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.pipingpig.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.pipingpig.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.pipingpig.com\/index.php\/wp-json\/wp\/v2\/comments?post=1381"}],"version-history":[{"count":4,"href":"https:\/\/www.pipingpig.com\/index.php\/wp-json\/wp\/v2\/posts\/1381\/revisions"}],"predecessor-version":[{"id":7505,"href":"https:\/\/www.pipingpig.com\/index.php\/wp-json\/wp\/v2\/posts\/1381\/revisions\/7505"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.pipingpig.com\/index.php\/wp-json\/wp\/v2\/media\/1374"}],"wp:attachment":[{"href":"https:\/\/www.pipingpig.com\/index.php\/wp-json\/wp\/v2\/media?parent=1381"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.pipingpig.com\/index.php\/wp-json\/wp\/v2\/categories?post=1381"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.pipingpig.com\/index.php\/wp-json\/wp\/v2\/tags?post=1381"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}