如何使用 SQLPlus 查看 Oracle 存储过程？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/7000224/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
How to View Oracle Stored Procedure using SQLPlus?
提问by Madam Zu Zu
How can I view the code of a stored procedure using sqlplus for Oracle 10g?
如何使用 sqlplus for Oracle 10g 查看存储过程的代码？
When I type in:
当我输入：
desc daily_update;
it shows me the parameter, but when I try to do the following:
它向我显示了参数，但是当我尝试执行以下操作时：
select * from all_source where name = 'daily_update';
I get
我得到
no rows selected
未选择任何行
What am I doing wrong?
我究竟做错了什么？
回答by Harrison
check your casing, the name is typically stored in upper case
检查您的大小写，名称通常以大写形式存储
SELECT * FROM all_source WHERE name = 'DAILY_UPDATE' ORDER BY TYPE, LINE;
SELECT * FROM all_source WHERE name = 'DAILY_UPDATE' ORDER BY TYPE, LINE;
