0
A PL/SQL subprogram is equivalent to a procedure or function in conventional procedural programming.
Wiki User
∙ 6y ago
Add your answer:
Earn +20 pts
What is overloaded subprogram?
subprogram overloading is a process of using the same (function) name for many subprograms. the overloaded subprograms may differ in the number, type or order of its its parameters.java, c++ and c# provides the feature of subprogram overloading . when an overloaded subprogram is called,java or c++ compiler first checks the subprogram name and then the number and type of parameters are analyzed to decide which version of the overloaded subprogram must be chosen for execution. this process is also known as 'polymorphism'. the return type of a subprogram has no affect on subprogram overloading whereas it is used to differentiate between the calls in ADA. hence,two overloaded functions in ADA can have the same parameter profile with different return values.
Does a subprogram always return a value to the program or subprogram that calls it?
No. In some languages PROCEDUREs don't return a value, FUNCTIONs do; in C (and derivatives) return-type void means no return value. Example:void Hello (const char *msg) { puts (msg); }
What is the maximum number of handlers processed before the PLSQL block is exited when an exception occurs?
only one
How do you compile a PLSQL procedure?
You can do that with Sql*Plus: SQL> CREATE OR REPLACE PROCEDURE foo ... IS ... END foo; / SHOW ERRORS
Addition of two numbers on plsql program?
--THE SUM OF TWO NUMBERS: declare a number(2); b number(2); c number(2); begin a:=&a; b:=&b; c:=a+b; dbms_output.put_line(a ' + 'b' = 'c); end;
What is overloaded subprogram?
subprogram overloading is a process of using the same (function) name for many subprograms. the overloaded subprograms may differ in the number, type or order of its its parameters.java, c++ and c# provides the feature of subprogram overloading . when an overloaded subprogram is called,java or c++ compiler first checks the subprogram name and then the number and type of parameters are analyzed to decide which version of the overloaded subprogram must be chosen for execution. this process is also known as 'polymorphism'. the return type of a subprogram has no affect on subprogram overloading whereas it is used to differentiate between the calls in ADA. hence,two overloaded functions in ADA can have the same parameter profile with different return values.
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 is the linker?
linker is a subprogram,its written by one user and one source code file will exit. linker is a subprogram,its written by one user and one source code file will exit.
Plsql procedures and functions?
Are really important in an Oracle Database.
Is it possible to change the structure of existing view if yes then how?
using plsql sql
Why function in VHDL?
A function is a subprogram written in VHDL. This program can be called and used in other programs.
Does a subprogram always return a value to the program or subprogram that calls it?
No. In some languages PROCEDUREs don't return a value, FUNCTIONs do; in C (and derivatives) return-type void means no return value. Example:void Hello (const char *msg) { puts (msg); }
What is the maximum number of handlers processed before the PLSQL block is exited when an exception occurs?
only one
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
How do you compile a PLSQL procedure?
You can do that with Sql*Plus: SQL> CREATE OR REPLACE PROCEDURE foo ... IS ... END foo; / SHOW ERRORS
Where can I download the book Oracle Jdeveloper 10g for Forms and PLSQL Developers by Peter Koletzke and Duncan Mills?
i cant download from ...any where
Why is type checking the parameters of a subprogram important?
Because by checking the data type, errors canbe detected before the program runs. So itmakes us easier to repair the program.
