What is the difference between SHOW_EDITOR and E

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

(Continued from previous question...)

293. What is the difference between SHOW_EDITOR and EDIT_TEXTITEM?

Show editor is the generic built-in which accepts any editor name and takes some input string and returns modified output string. Whereas the edit_textitem built-in needs the input focus to be in the text item before the built-in is executed.

(Continued on next question...)

Other Job Interview Questions

• What are the Large object types suported by Oracle?
• What is COST-based approach to optimization?
• What are the dictionary tables used to monitor a database spaces?
• What is Restricted Mode of Instance Startup?
• Why is it preferable to create a fewer no. of queries in the data model?
• What is Privilege Auditing?
• What are the two ways by which data can be generated for a parameters list of values?
• Is it possible to disable the parameter from while running the report?
• Difference between “ORACLE” and “MICROSOFT ACCESS” databases.
• Which of the two views should objects according to possession?
• More...