Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 3 Answers
- 8800 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
Do we need commit after truncate?
What is ttitle and btitle?
Why do we use cursors?
What is the use of procedures?
What is trigger in pl sql with examples?
What is the use of non clustered index?
How do I run a pl sql program?
What is nvarchar in sql?
How many triggers can be applied to a table?
How do you use collections in procedure to return the resultset?
What is mutating trigger?
Can pl sql procedure have a return statement?
How does one load ebcdic data? : aql loader
Can two tables have same primary key?
What is sp_helptext?
