In general SPs are sequential block of PL/SQL for Transaction Func are u

What is the difference between Stored Procedure , Function
and Package,
1. how many blocks in Package and what are they.

Question Posted / pratap557

Answer Posted / pratap557

In general SPs are sequential block of PL/SQL for
Transaction
Func are used for specific calculation / selection

Is This Answer Correct ?

4 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are the Advantages of using CTE in sql server?

1061

Explain time data type in sal server 2008?

878

Explain what are the database objects? : SQL Server Architecture

1014

Explain primary key in sql server?

979

Tell me can we use custom code in ssrs?

964

What is schemabinding a view?

867

what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

970

Explain different types of locks in sql server.

1024

How to configure and test odbc dsn settings?

1104

What is the use of sign function?

1049

How global temporary tables are represented and its scope?

916

What is difference between stored procedure and user defined function?

1045

Difference between group by clause and having clause in SQL?

933

What are rows and columns?

962

What is bcp? When does it used?

932