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
8895 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

Can a varchar be a primary key?

1018

What is mutating error in pl sql?

1031

what are all the different normalizations? : Sql dba

1054

Can we join same table in sql?

1034

What view means?

988

What does seeding a database mean?

976

How many types of cursors are available in pl/sql?

1118

How do I remove duplicates in two columns?

1079

Is json a nosql?

985

How to combine two stored procedures in sql?

1245

Why do we need view in sql?

994

How does index help in query performance?

1034

Can we rollback truncate?

1007

What is mutating trigger?

1029

What are the 3 modes of parameter?

1162