[系统] 在SQL Developer看不到procedure body

楼主: lueichun (no anonymous)   2017-07-20 15:55:49
(针对数据库系统的问题,用这个标题。请用 Ctrl+Y 砍掉这行)
数据库名称:oracle
数据库版本:
作业平台:PL\SQL Develpoer、Oracle SQL Developer
问题描述:我在这两个SQL Developer想要查看procedure的body
但是不管怎么找 都找不到procedure body 只看的到以下的内容:
https://1drv.ms/i/s!Av6NUY4H7zPalXcYJ6VDiJna2qDn
只能看到procedure宣告的样子
请问要怎么做才能看到procedure body呢
找到做法了:
This worked for me:
In SQL Developer,
right click the object that you want to generate a script
for. i.e. the table name
Select Quick DLL > Save To File
This will then write the create statement to an external sql file.
※ 编辑: lueichun (59.120.148.217), 07/21/2017 17:13:35
作者: fantasyj (如梦似幻)   2017-07-29 14:28:00
pl/sql developer 的command windows 输入指令edit procedure_name 或是 view procedure_name

Links booklink

Contact Us: admin [ a t ] ucptt.com