How do you reference a parameter indirectly?

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

272. How do you reference a parameter indirectly?

To indirectly reference a parameter use the NAME IN, COPY ‘built-ins to indirectly set and reference the parameters value’ Example name_in (’capital parameter my param’), Copy (’SURESH’,'Parameter my_param’)

(Continued on next question...)

Other Job Interview Questions

• If you see the value for reloads is high in the estat library cache report is this a matter for concern?
• Is it possible to split the print reviewer into more than one region?
• What are the built-ins used for Getting cell values?
• How can you tell if a tablespace has excessive fragmentation?
• Display the records between two range
• Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?
• What are PL/SQL Cursor Exceptions?
• What is a “trigger”?
• What view would you use to look at the size of a data file?
• Explain about horizontal, Vertical tool bar canvas views?
• More...