What is the difference between functions, procedures, and packages in pl/sql?


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

Post New Answer

More SQL PLSQL Interview Questions

What are pl/sql cursors?

0 Answers  


Can you do multiple joins in sql?

0 Answers  


How to start the command-line sql*plus?

0 Answers  


what's the difference between a primary key and a unique key? : Sql dba

0 Answers  


What is the difference between left join and left outer join?

1 Answers  






i have table T!. A B C D NULL 1 2 3 4 NULL 5 6 7 8 NULL 9 10 11 12 NULL. I WANT COUNT OF NULL VALUES IN TABLE. WRITE A QUERY.

14 Answers   iGate, Wipro,


Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints

0 Answers  


1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins

0 Answers   CTS,


Does sap use sql?

0 Answers  


Regarding joins what are the differences you observed in oracle 9i and sql server?

3 Answers   Choice Solutions,


What is a subquery in sql?

0 Answers  


What is cold data?

0 Answers  


Categories