我用xiaowang用户登陆到oracle中,在sqlplus中sql>show user;
xiaowang然后我执行select count(*) from user_projects where status='valid' and object_type='procedure'结果是:0个我有5个已经编译好了并且通过测试了的存储过程,请问统计有效的存储过程 命令应该是哪个呢???
xiaowang然后我执行select count(*) from user_projects where status='valid' and object_type='procedure'结果是:0个我有5个已经编译好了并且通过测试了的存储过程,请问统计有效的存储过程 命令应该是哪个呢???
--大写!
select Count(*) from user_objects where status='VALID' and object_type='PROCEDURE';
select count(*) from user_objects where status=upper('valid') and object_type=upper('procedure')
个人觉得没有select count(*) from user_ojbects where lower(status)='valid' and lower(object_type)='procedure'这个好。