What is the difference between function and procedure in pl/sql?


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

Post New Answer

More SQL PLSQL Interview Questions

Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?

0 Answers  


What is the criteria while applying index to any column on any table.

1 Answers   Infogain,


Hello All, Could any well write a query for the following scenario. Account(table name) No Name Amount 1 ABCD 2000.00 2 DEFG -2000.00 3 GHIJ 3000.50 4 JKLM 4000.00 5 MNOP 6000.00 O/p Should be in this format No Name Credit Debit 1 ABCD 2000.00 0 2 DEFG 0 -2000.00 3 GHIJ 3000.50 4 JKLM 0 -4000.00 5 MNOP 6000.00 o could any one give appropriate query for this Thnks in Advance Suneel Reddy

6 Answers   Target,


What is relationship? How many types of relationship are there?

0 Answers  


what is an associative array with example?

1 Answers  






select sal from emp group by sal

3 Answers   TCS,


discuss about myisam key cache. : Sql dba

0 Answers  


how to use regular expression in pattern match conditions? : Sql dba

0 Answers  


What is the advantage of index in sql?

0 Answers  


Does SQL*Plus contains pl/sql Engine?

1 Answers   TCS,


If the base table structure is changed what will happen to join index????

2 Answers  


What are expressions?

0 Answers  


Categories