0
Are really important in an Oracle Database.
Wiki User
∙ 15y ago
Add your answer:
Earn +20 pts
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?
Procedures are a set of instructions that perform a specific task but do not return a value, while functions are similar but return a value after completing their task. Functions are typically used when you need to perform some computation and return a result, while procedures are used for tasks that don't require a return value.
What are the procedures in rdbms?
In an RDBMS (Relational Database Management System), the procedures are typically defined as a set of structured query language (SQL) statements that are stored and executed within the database. These procedures can include functions, triggers, and stored procedures. Functions are used to perform calculations or manipulate data, triggers are used to automatically execute actions when specific events occur, and stored procedures are pre-compiled routines that can be called to perform a specific set of operations on the database. These procedures help in maintaining data integrity, enforcing business rules, and improving performance.
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).
Is it possible to change the structure of existing view if yes then how?
using plsql sql
What is a term used as a synonym for module in any programming language?
subroutines procedures functions or methods
What are the functions of Human Resource manager?
motivate employees organise training courses Set disciplinary procedures
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.
