answersLogoWhite

0

Plsql procedures and functions

User Avatar

Anonymous

16y ago
Updated: 8/16/2019

Are really important in an Oracle Database.

User Avatar

Wiki User

16y ago

What else can I help you with?

Related Questions

What are stored procedures in data bases?

Stored procedure is the pl-sql block in precomplile from and can be used to excecute plsql statement


Can you pass argument to procedures?

Yes. Procedures are otherwise known as functions, and functions can accept arguments.


Why decode is not used in plsql?

Decode can be used in PLSQL, but in version 9i and later the case statement is easier to use, more powerful and more intuitive.


What are the functions Microsoft Excel?

Functions allow you to perform some mathematical or string procedures to other cells.


What is the difference between procedures and functions?

Functions return a value.NoteThere are no procedures in C, only functions with no return value (type void is used to indicate that). In general a function is the purpose or what a system actually does( what output it returns) and a procedure is how that output is returned.


Is it possible to change the structure of existing view if yes then how?

using plsql sql


What are the procedures in rdbms?

Procedures in an RDBMS are programs that are written to accomplish a set of functions that cannot be done using a single query. A procedure contains a sequence of SQL Queries that can be executed one after the other by invoking the procedure. There are two kinds of procedures Functions & Stored Procedures.


What are the similarities and differences between procedures and functions in pascal programming language?

Procedures and functions are exactly the same in Pascal, the only difference is that a function must return a value to its caller while a procedure does not. A procedure is essentially the same as a function returning void in C. We use procedures and functions to avoid writing duplicate or repeated sections of code and thus reduce maintenance costs. With well-named procedures and functions our code also becomes self-documenting, making the code much easier to read (and maintain).


What is a term used as a synonym for module in any programming language?

subroutines procedures functions or methods


What is the maximum number of handlers processed before the PLSQL block is exited when an exception occurs?

only one


Which is an example of a PLSQL subprogram?

A PL/SQL subprogram is equivalent to a procedure or function in conventional procedural programming.


What are the functions of Human Resource manager?

motivate employees organise training courses Set disciplinary procedures