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 inbuilt functions in sql?
What is compound trigger?
Can we use the cursor's to create the collection in PL/SQL?
Explain isolation levels. : Transact sql
How do you copy a table in sql?
How much does sqlite cost?
What is sqlca in powerbuilder?
Explain sql data types?
how to show all tables with 'mysql'? : Sql dba
What is the difference between python and sql?
Can a foreign key be a duplicate?
what does it mean to have quoted_identifier on? : Sql dba
What is the use of index in sql?
Is sql open source?
What does partition by mean in sql?