Answer Posted / Sadaf Naz

Lexical parameters in Oracle D2K offer several benefits and use cases. First, they provide a way to pass values between procedures and functions without the need for explicit variable assignment. Second, they allow for the reuse of code by defining common parameters that can be shared across multiple routines. Lastly, lexical parameters make it easier to manage the flow of control in complex programs by encapsulating related functionality.

Were you involved in any data conversion, which one?

27

How many concurrent programs you have customized, can you name some of them?

17

Have you used lexical parameters in reports?

26

Any work done in oracle workflow builder. Did you customize or build a new workflow?

24

Are you familiar with user exits in reports?

27