Question

Define the pl/sql block constructs, using variables

Answer 1

hey dude


A PL/SQL block is defined by the keywords DECLARE, BEGIN, EXCEPTION, and END, which break up the block into three sections: Declarative: statements that declare variables, constants, and other code elements, which can then be used within that block. Executable: statements that are run when the block is executed.

Answer 2

The short answer is that method overloading is for passing different sets of data to a function. Generics are for passing different types to a function. ... You may want to have one function signature that takes no parameters and uses the current date as the "as of" date.