Sql Question and answer 7

31. How you were passing cursor variables in PL/SQL 2.2.
In PL/SQL 2.2 cursor variables cannot be declared in a package.This is because the storage for a cursor variable has to be allocated using Pro*C or OCI with version 2.2,the only means of passing a cursor variable to a PL/SQL block is via bind variable or a procedure parameter.

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

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

33. Difference between procedure and function.

Functions are named PL/SQL blocks that return a value and can be called with arguments procedure a named block that can be called with parameter. A procedure all is a PL/SQL statement by itself, while a Function call is called as part of an expression.

34. What are different modes of parameters used in functions and procedures.

IN
OUT
INOUT

35. What is difference between a formal and an actual parameter

The variables declared in the procedure and which are passed, as arguments are called
actual, the parameters in the procedure declaration. Actual parameters contain the
values that are passed to a procedure and receive results. Formal parameters are the
placeholders for the values of actual parameters

36. Can the default values be assigned to actual parameters.

Yes

37. Can a function take OUT parameters.If not why.

No.A function has to return a value,an OUT parameter cannot return a value.

38. What is syntax for dropping a procedure and a function .Are these operations possible.

Drop Procedure procedure_name
Drop Function function_name