we have a package and we have grants to execute that package inside of that we have table, here we don't have privileges to this table? whether this package will execute or not?
Answer Posted / shareen
select empno,deptno,ename,sal,case when deptno=10 then
sal+3000
when deptno=20 then sal+2000
when deptno=30 then sal+1000
else sal end from emp
Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What are the types of index in sql?
Is primary key clustered or nonclustered?
What is equi join in sql?
What operating systems are supported by oracle sql developer?
What is rownum in sql?
What is attribute indicator in pl sql?
Why is normalization important?
What is crud diagram?
what is the difference between group by and order by in sql? : Sql dba
Why plvtab is considered as the easiest way to access the pl/sql table?
what is the functionality of the function htmlentities? : Sql dba
Which join condition can be specified using on clause?
Is left join and outer join same?
Why is %isopen always false for an implicit cursor?
Does db2 use sql?