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

What are inbuilt functions in sql?

993

What is compound trigger?

968

Can we use the cursor's to create the collection in PL/SQL?

961

Explain isolation levels. : Transact sql

1017

How do you copy a table in sql?

1015

How much does sqlite cost?

989

What is sqlca in powerbuilder?

958

Explain sql data types?

1037

how to show all tables with 'mysql'? : Sql dba

1060

What is the difference between python and sql?

940

Can a foreign key be a duplicate?

861

what does it mean to have quoted_identifier on? : Sql dba

1102

What is the use of index in sql?

963

Is sql open source?

917

What does partition by mean in sql?

911