What are advantages fo Stored Procedures?

What are advantages fo Stored Procedures?
by

1 Answer

Answer :

Extensibility,Modularity, Reusability, Maintainability and one time
compilation.
by

Related questions

What are stored-procedures? And what are the advantages of using them.

Description : What are stored-procedures? And what are the advantages of using them.

Last Answer : Stored procedures are database objects that perform a user defined operation. A stored procedure can have a set of compound SQL statements. A stored procedure executes the SQL commands and returns the result to the client. Stored procedures are used to reduce network traffic.

What are Database Triggers and Stored Procedures

Description : What are Database Triggers and Stored Procedures

Last Answer : Database Triggers :: Database Triggers are Procedures that are automatically executed as a result of insert in, update to, or delete from table. Database triggers have the values old and new to ... procedures is that many users can use the same procedure in compiled and ready to use format.

How will you enforce security using stored procedures?

Description : How will you enforce security using stored procedures?

Last Answer : Don't grant user access directly to tables within the application. Instead grant the ability to access the procedures that access the tables. When procedure executed it will execute the privilege of procedures owner. Users cannot access tables except via the procedure.

How will you enforce security using stored procedures?

Description : How will you enforce security using stored procedures?

Last Answer : Don't grant user access directly to tables within the application. Instead grant the ability to access the procedures that access the tables. When procedure executed it will execute the privilege of procedures owner. Users cannot access tables except via the procedure.

What is Overloading of procedures ?

Description : What is Overloading of procedures ?

Last Answer : The Same procedure name is repeated with parameters of different datatypes and parameters in different positions, varying number of parameters is called overloading of procedures. e.g. DBMS_OUTPUT put_line

What are different modes of parameters used in functions and procedures?

Description : What are different modes of parameters used in functions and procedures?

Last Answer : IN -OUT -INOUT

What is an UTL_FILE.What are different procedures and functions associated with it?

Description : What is an UTL_FILE.What are different procedures and functions associated with it?

Last Answer : UTL_FILE is a package that adds the ability to read and write to operating system files. Procedures associated with it are FCLOSE, FCLOSE_ALL and 5 procedures to output data to a file PUT, ... , PUTF, FFLUSH.PUT, FFLUSH.PUT_LINE,FFLUSH.NEW_LINE. Functions associated with it are FOPEN, ISOPEN.

What is difference between Procedures and Functions ?

Description : What is difference between Procedures and Functions ?

Last Answer : A Function returns a value to the caller where as a Procedure does not.

How packaged procedures and functions are called from the following?

Description : How packaged procedures and functions are called from the following?

Last Answer : a. Stored procedure or anonymous block b. an application program such a PRC *C, PRO* COBOL c. SQL *PLUS?? a. PACKAGE NAME.PROCEDURE NAME (parameters); variable := PACKAGE NAME.FUNCTION NAME ( ... .PROCEDURE if the procedures does not have any out/in-out parameters. A function can not be called.

Explain how procedures and functions are called in a PL/SQL block ?

Description : Explain how procedures and functions are called in a PL/SQL block ?

Last Answer : Function is called as part of an expression. sal := calculate_sal ('a822'); procedure is called as a PL/SQL statement calculate_bonus ('A822');

What are the unrestricted procedures used to change the popup screen position during run time ?

Description : What are the unrestricted procedures used to change the popup screen position during run time ?

Last Answer : Anchor-view Resize -View Move-View.

What are stand-alone procedures?

Description : What are stand-alone procedures?

Last Answer : Procedures that are not part of a package are known as stand-alone because they independently defined. A good example of a stand-alone procedure is one written in a SQL*Forms application. These ... limitation of stand-alone procedures is that they are compiled at run time, which slows execution.

Where the integrity constraints are stored in Data Dictionary ?

Description : Where the integrity constraints are stored in Data Dictionary ?

Last Answer : The integrity constraints are stored in USER_CONSTRAINTS.

Can cursor variables be stored in PL/SQL tables.If yes how. If not why?

Description : Can cursor variables be stored in PL/SQL tables.If yes how. If not why?

Last Answer : No, a cursor variable points a row which cannot be stored in a two- dimensional PL/SQL table.

What are the different types of PL/SQL program units that can be defined and stored in ORACLE database ?

Description : What are the different types of PL/SQL program units that can be defined and stored in ORACLE database ?

Last Answer : Procedures and Functions,Packages and Database Triggers.

What is a stored procedure ?

Description : What is a stored procedure ?

Last Answer : A stored procedure is a sequence of statements that perform specific function.

Where the Pre_defined_exceptions are stored ?

Description : Where the Pre_defined_exceptions are stored ?

Last Answer : In the standard package. Procedures, Functions & Packages ;

Name the tables where characteristics of Package, procedure and functions are stored ?

Description : Name the tables where characteristics of Package, procedure and functions are stored ?

Last Answer : User_objects, User_Source and User_error.

What is the job of the information stored in data-dictionary?

Description : What is the job of the information stored in data-dictionary?

Last Answer : The information in the data dictionary validates the existence of the objects, provides access to them, and maps the actual physical storage location.

Name the buffer in which all the commands that are typed in are stored

Description : Name the buffer in which all the commands that are typed in are stored

Last Answer : ‘Edit’ Buffer

What information is stored in Control File?

Description : What information is stored in Control File?

Last Answer : Oracle Database must have at least one control file. It's a binary file contains some of the following information: ▪ The database name and unique ID ▪ The timestamp of database creation ... app/oracle/oradata/DB1_SID /control01.ctl, /u01/app/oracl e/flash_recovery_area/DB1_SID/c ontrol02.ctl

What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode ?

Description : What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode ?

Last Answer : Complete database recovery from disk failure is possible only in ARCHIVELOG mode. Online database backup is possible only in ARCHIVELOG mode.

What are the advantages of VIEW ?

Description : What are the advantages of VIEW ?

Last Answer : To protect some of the columns of a table from other users.To hide complexity of a query.To hide complexity of calculations.

What are the advantages of having a Package ?

Description : What are the advantages of having a Package ?

Last Answer : Increased functionality (for example,global package variables can be declared and used by any proecdure in the package) and performance (for example all objects of the package are parsed compiled, and loaded into memory once)

What are % TYPE and % ROWTYPE ? What are the advantages of using these over datatypes?

Description : What are % TYPE and % ROWTYPE ? What are the advantages of using these over datatypes?

Last Answer : % TYPE provides the data type of a variable or a database column to that variable. % ROWTYPE provides the record type that represents a entire row of a table or view or columns selected in ... database definition of a column in a table changes, the data type of a variable changes accordingly.

What is a package ? What are the advantages of packages ? What is Pragma EXECPTION_INIT ? Explain the usage ?

Description : What is a package ? What are the advantages of packages ? What is Pragma EXECPTION_INIT ? Explain the usage ?

Last Answer : The PRAGMA EXECPTION_INIT tells the complier to associate an exception with an oracle error. To get an error message of a specific oracle error. e.g. PRAGMA EXCEPTION_INIT (exception name, oracle error number)

It is possible to use raw devices as data files and what is the advantages over file. system files ?

Description : It is possible to use raw devices as data files and what is the advantages over file. system files ?

Last Answer : Yes. The advantages over file system files. I/O will be improved because Oracle is bye-passing the kernnel which writing into disk. Disk Corruption will be very less.

What are the advantages of views?

Description : What are the advantages of views?

Last Answer : Provide an additional level of table security, by restricting access to a predetermined set of rows and columns of a table. - Hide data complexity. - Simplify commands for the user. - Present the data in a different perspective from that of the base table. - Store complex queries.

Advantages of DBMS?

Description : Advantages of DBMS?

Last Answer : ∙ Redundancy is controlled. ∙ Unauthorized access is restricted. ∙ Providing multiple user interfaces. ∙ Enforcing integrity constraints. ∙ Providing backup and recovery.

What exactly does "fee fi fo fum" mean?

Description : What exactly does "fee fi fo fum" mean?

Last Answer : Nothing nothing nothing nothing.

Have you heard fo this author?

Description : Have you heard fo this author?

Last Answer : I've read some of his work and have also heard him on NPR many times. I'm not sure about plot planning as much of his work seems to be stories and recollections pieced together. It seems ... Under the Influence is laugh out loud funny! They must have had a very amusing or very painful childhood.

I have a hard pink fuzzy substance on one of my plants/bushes. What is it & what do I fo w/ it?

Description : I have a hard pink fuzzy substance on one of my plants/bushes. What is it & what do I fo w/ it?

Last Answer : You did not say what kind of plant, I would just cut that off and bag & trash it..........

Which of the following best describes what a concentration camp isA. A place to concentrate on hard tasks B. A place to take napsC. A place where people were forced to work and often dieF. A fun spot to fo far a vacation?

Description : Which of the following best describes what a concentration camp isA. A place to concentrate on hard tasks B. A place to take napsC. A place where people were forced to work and often dieF. A fun spot to fo far a vacation?

Last Answer : The Devils Arecmutic

Facebook fo te I like or share

Description : What's the difference when I like it or share it? On Facebook ?

Last Answer : I like it, people on your profile will see what you like. When you click to share, you share it. So sharing is better for publishers.

Assertion `:` First heart sound (LUBB) is produced at the beginning fo ventricular systole stage. Reason `:` During ventricular systole semilunar valv

Description : Assertion `:` First heart sound (LUBB) is produced at the beginning fo ventricular systole stage. Reason `:` During ventricular systole semilunar valv

Last Answer : Assertion `:` First heart sound (LUBB) is produced at the beginning fo ventricular systole stage. Reason ... D. If both Assertion & Reason are false.

Assertion `:` Neural signals through the sympathetic nerves can increase the rate of heart beat, the strength fo ventriculrar contraction and thereby

Description : Assertion `:` Neural signals through the sympathetic nerves can increase the rate of heart beat, the strength fo ventriculrar contraction and thereby

Last Answer : Assertion `:` Neural signals through the sympathetic nerves can increase the rate of heart beat, the ... D. If both Assertion & Reason are false.

Immature RBCs fo mammals have

Description : Immature RBCs fo mammals have

Last Answer : Immature RBCs fo mammals have A. No nucleus B. Single beaded nucleus C. Many nuclei D. Single nucleus.

Colouring agent fo plasma is `:-`

Description : Colouring agent fo plasma is `:-`

Last Answer : Colouring agent fo plasma is `:-` A. Billiverdin B. Stercobillinogen C. Urobillinogen D. Urochrome

Assertion `:-` Small intestine is very long and has plica circularis & villi Reason `:` All these increase internal surface area of small intestine fo

Description : Assertion `:-` Small intestine is very long and has plica circularis & villi Reason `:` All these increase internal surface area of small intestine fo

Last Answer : Assertion `:-` Small intestine is very long and has plica circularis & villi Reason `:` All these ... False. D. If both Assertion & Reason are false.

She/he keeps machines, maeerials, tools, etc., ready for operations by different workers. Whose work is described by this sentence under functionsl fo

Description : She/he keeps machines, maeerials, tools, etc., ready for operations by different workers. Whose work is described by this sentence under functionsl fo

Last Answer : She/he keeps machines, maeerials, tools, etc., ready for operations by different workers. Whose work is ... . Repaid boss C. Gang boss D. Route clerk

According to the Neo-Drawinian theory which fo the following is responsible for the origin of new species?

Description : According to the Neo-Drawinian theory which fo the following is responsible for the origin of new species?

Last Answer : According to the Neo-Drawinian theory which fo the following is responsible for the origin ... together with natural selection D. Hybridization only

Intiating orce fo evalution is :

Description : Intiating orce fo evalution is :

Last Answer : Intiating orce fo evalution is : A. Variation B. Natural selection C. adaptation D. Competition

(i) The base of an open rectangular box is square and its volume is ` 256 cm^(3)`. Find the dimensions of this box if we want to use least material fo

Description : (i) The base of an open rectangular box is square and its volume is ` 256 cm^(3)`. Find the dimensions of this box if we want to use least material fo

Last Answer : (i) The base of an open rectangular box is square and its volume is ` 256 cm^(3)`. ... dimensions of this window from which maximum light can admit.

A quadratic equation whose roots are 2 moe than the roots of the quadratic equation `2x^(2) +3x + 5 = 0`, can be obtained by substituting `"_____"` fo

Description : A quadratic equation whose roots are 2 moe than the roots of the quadratic equation `2x^(2) +3x + 5 = 0`, can be obtained by substituting `"_____"` fo

Last Answer : A quadratic equation whose roots are 2 moe than the roots of the quadratic equation `2x^(2) +3x + 5 = 0`, can be ... `"_____"` for x. `[(x-2)//(x+2)]`

Assertion :- First electrons affinity fo all element is positive. Reason :- Successive electron affinity of all elements is negative

Description : Assertion :- First electrons affinity fo all element is positive. Reason :- Successive electron affinity of all elements is negative

Last Answer : Assertion :- First electrons affinity fo all element is positive. Reason :- Successive electron affinity ... D. If both Assertion & Reason are false

Which of the following is true fo the reacion `H_(2)O(l)hArr H_(2)O(g)` at `100^(@)C` and 1 atmosphere

Description : Which of the following is true fo the reacion `H_(2)O(l)hArr H_(2)O(g)` at `100^(@)C` and 1 atmosphere

Last Answer : Which of the following is true fo the reacion `H_(2)O(l)hArr H_(2)O(g)` at `100^(@)C` and 1 atmosphere ... Delta H = Delta E` D. `Delta H = T Delta S`

In the conversion fo ` Br_2` to `BrO_3^(-)` , the oxidation state of `Br` changes from.

Description : In the conversion fo ` Br_2` to `BrO_3^(-)` , the oxidation state of `Br` changes from.

Last Answer : In the conversion fo ` Br_2` to `BrO_3^(-)` , the oxidation state of `Br` changes from. A. 0 to 5 B. 1 to 5 C. 0 to `-3` D. 2 to 5

Mechanism fo breathing vary among different groups of animals depending mainly on _____ and _____.

Description : Mechanism fo breathing vary among different groups of animals depending mainly on _____ and _____.

Last Answer : Mechanism fo breathing vary among different groups of animals depending mainly on _____ and _____.

Mechanism fo breathing vary among different groups of animals depending mainly on _____ and _____.

Description : Mechanism fo breathing vary among different groups of animals depending mainly on _____ and _____.

Last Answer : Mechanism fo breathing vary among different groups of animals depending mainly on _____ and _____.

Deficiency symptom fo mobile elements (e.g. N,Mg,K,P) first appear in

Description : Deficiency symptom fo mobile elements (e.g. N,Mg,K,P) first appear in

Last Answer : Deficiency symptom fo mobile elements (e.g. N,Mg,K,P) first appear in