What are packages in pl sql and also explain its advantages?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL PLSQL Interview Questions

What is the file extension for sql database?

0 Answers  


how to give permission to users that users can update/insert/delete on a row of table on timeing 10am to 6pm only?

4 Answers   TCS,


We have a CURSOR then we need BULK COLLECT?

1 Answers  


What is trigger in sql and its types?

0 Answers  


explain what is mysql? : Sql dba

0 Answers  






What is parameter substitution in sql?

0 Answers  


What does over partition by mean in sql?

0 Answers  


Begin For j in 4403201000 .. 4403202000 Loop If mod (j, 100) = 0 then Dbms_output.put_line (j); End if; End loop; End; what will be the output of this question

7 Answers   TCS,


What are aggregate and scalar functions?

0 Answers  


SQL Tuning, Oracle Server 10g: Why is the following hint invalid? SELECT /*+ first_rows parallel(table_name,paral_number)*/

1 Answers   Accenture,


I have a Employee table with columns ename,eid,salary,deptno. How to retrieve sum of salary for each deptno?

8 Answers   L&T,


Does truncate free space?

0 Answers  


Categories