select empno,deptno,ename,sal,case when deptno=10 then sal+3000

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?

Question Posted / shareen

3 Answers
8830 Views
TCS, I also Faced
E-Mail Answers

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

Please Help Members By Posting Answers For Below Questions

Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

3556

What are different methods to trace the pl/sql code?

1093

Define tables and fields in a database

1109

what are the join types in tsql? : Transact sql

1046

Where not exists in sql?

964

Is left join inner or outer by default?

1005

what is meant by nl2br()? : Sql dba

1010

What does pragma mean?

1032

Does truncate free space?

989

What is the advantage of nosql?

1041

What is pl sql collection?

945

State few characteristics of pl/sql?

963

How many databases can sql express handle?

964

how to check myisam tables for errors? : Sql dba

1304

Can we create a trigger on view?

878