Answer / rajesh

* The main advantage of package is one time compilation
process.while the first time of compilation the source code
is converted into P-code and stored in the database so that
for n no of time calling the pckg it does not take any
memory locations...
*Then whatevere the database objects declared in the
package specification will be globally accessible.

Answer / akki julakanti

Advantages of Packages:
1.Encapsulation
2.Overloading
3.Better Performance
4.Information hiding

Answer / chandrasekar.ramasamy

Package-> Compiles and stores all the procedures and
functions in SGA (System Global Area), so the performance
will be high.

Answer / manoj kaushik

Advantages of Packages --Modularity,Easier Application
Design,Information Hiding,Added Functionality,Better
Performance.

Answer / senthilkumar

Package is a group of related database objects like
functions ,procedures and other packages construct together
as a unit in the database.

Advantages:
Modularity
Better Performance(when we are executing any
subprogram in the package, it will be loaded in to the
memory, so performance of the package will be very high)

Answer / gireesh.p.v

package is a collection of procedures&functions.
we can use package by simply calling it

What is 19 null in sql?

0 Answers  

What is the difference between numeric and autonumber?

0 Answers  

Enlist the advantages of sql.

0 Answers  

Display the total debit counts, total credit counts, sum of total debits, sum of total credits from an employee's transaction table (a single table) containing the following columns. Transaction_number Transaction_amount Transaction_date Transaction_type --> tells if the amount is a credit or a debit. As the query alone is important, the table is left with specifying just the field's name. Pls help me with this query.

3 Answers   iNautix, Oracle,

What is sql dialect?

0 Answers  

SELECT emp_num, years, SUM(salary) FROM sales UNION ALL SELECT emp_id, SUM(takehomepay) FROM marketing What error is present in the sample code above? 1. Queries being combined with the UNION ALL statement are not allowed to have SELECT lists with a different number of expressions. 2. You are not allowed to use aggregate functions within two queries joined by a UNION ALL statement. 3. The UNION ALL statement incorrectly combines the "years" result from the first query with the "SUM (takehomepay)" result from the second query. 4. Unless the UNION ALL statement is replaced with a UNION statement, the queries will return duplicates. 5. The "emp_id" column from the second query must be renamed (or aliased) as "emp_num" so that it corresponds to the column name from the first query. Otherwise, the queries will not execute.

3 Answers  

What is the purpose of using pl/sql?

0 Answers  

in a package one procedure is wrong package shows valid or not

4 Answers  

What is scalar function in sql?

0 Answers  

What is record type in pl sql?

0 Answers  

select 10 from dual; y its showing all the rows with 10?

1 Answers  

Does group by remove duplicates?

0 Answers