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
9003 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 is dense_rank?

989

What is data abstraction in sql?

1067

How many primary keys can a table have?

1059

How many types of privileges are available in sql?

1405

How to change the order of columns in Oracle SQL Plus ?

1103

Why is pl sql needed?

1005

Can we create table inside stored procedure?

1016

What are the different types of database management systems?

1038

Can we use view in stored procedure?

956

How do temporal tables work?

1021

What are the different schemas objects that can be created using pl/sql?

1085

How do you update a sql procedure?

1092

What is a relationship and what are they?

1230

How is indexing done in search engines?

1023

What are system versioned tables?

1075