What is difference between SUBSTR and INSTR?

ORACLE Interview Questions and Answers (Part 3)

(Continued from previous question...)

519. What is difference between SUBSTR and INSTR?

SUBSTR returns a specified portion of a string eg SUBSTR('BCDEF',4) output BCDE INSTR provides character position in which a pattern is found in a string. eg INSTR('ABC-DC-F','-',2) output 7 (2nd occurence of '-')

(Continued on next question...)

Other Interview Questions

• What is the difference between restricted and unrestricted package procedure ?
• A query fetched 10 records How many times does a PRE-QUERY Trigger and POST-QUERY Trigger will get executed ?
• Give the sequence in which triggers fired during insert operations, when the following 3 triggers are defined at the same block level ?
• State the order in which these triggers are executed ?
• What the PAUSE package procedure does ?
• What do you mean by a page ?
• What are the type of User Exits ?
• What is the difference between an ON-VALIDATE-FIELD trigger and a trigger ?
• Can we use a restricted package procedure in ON-VALIDATE-FIELD Trigger ?
• Is a Key startup trigger fires as result of a operator pressing a key explicitly ?
• Can we use GO-BLOCK package in a pre-field trigger ?
• Can we create two blocks with the same name in form 3.0 ?
• What is Post-Block is a. ???
• What does an on-clear-block Trigger fire?
• Name the two files that are created when you generate the form give the filex extension ?
• What package procedure used for invoke sql *plus from sql *forms ?
• What is the significance of PAGE 0 in forms 3.0 ?
• What are the different types of key triggers ?
• What is the difference between a Function Key Trigger and Key Function Trigger ?
• Committed block sometimes refer to a BASE TABLE ?
• Error_Code is a package proecdure ?
• When is cost based optimization triggered? (for DBA
• How can one optimize %XYZ% queries? (for DBA
• What Enter package procedure does ?
• Where can one find I/O statistics per table? (for DBA
• My query was fine last week and now it is slow. Why? (for DBA
• Why is Oracle not using the damn index? (for DBA
• When should one rebuild an index? (for DBA
• What are the unrestricted procedures used to change the popup screen position during run time ?
• What is an Alert ?
• Deleting a page removes information about all the fields in that page ? a. True. b. False?
• Two popup pages can appear on the screen at a time ?Two popup pages can appear on the screen at a time ? a. True. b. False?
• Classify the restricted and unrestricted procedure from the following: ...
• What is an User Exits ?
• What is a Trigger ?
• What is a Package Procedure ?
• What is the maximum size of a form ?
• What is the difference between system.current_field and system.cursor_field ?
• List the system variables related in Block and Field?
• What are the types of TRIGGERS ?
• Identify package function from the following ?
• Can you attach an lov to a field at run-time? if yes, give the build-in name.?
• Is it possible to attach same library to more than one form?
• Can you attach an lov to a field at design time?
• List the windows event triggers available in Forms 4.0?
• What are the triggers associated with the image item?
• What is a visual attribute?
• How many maximum number of radio buttons can you assign to a radio group?
• How do you pass the parameters from one form to another form?
• What is a Layout Editor?
• List the Types of Items?
• List system variables available in forms 4.0, and not available in forms 3.0?
• What are the display styles of an alert?
• What built-in is used for showing the alert during run-time?
• What built-in is used for changing the properties of the window dynamically?
• What are the different types of windows?
• What is a predefined exception available in forms 4.0?
• What is a radio Group?
• What are the different type of a record group?
• What are the menu items that oracle forms 4.0 supports?
• Give the equivalent term in forms 4.0 for the following. Page, Page 0?
• What triggers are associated with the radio group?
• What are the triggers associated with a check box?
• Can you attach an alert to a field?
• Can a root window be made modal?
• What is a list item?
• List some built-in routines used to manipulate images in image_item?
• Can you change the alert messages at run-time?
• What is the built-in used to get and set lov properties during run-time?
• What is the built-in routine used to count the no of rows in a group?
• Give the Types of modules in a form?
• Write the Abbreviation for the following File Extension 1. FMB 2. MMB 3. PLL?
• List the built-in routine for controlling window during run-time?
• List the built-in routine for controlling window during run-time?
• What is the built-in function used for finding the alert?
• List the editors availables in forms 4.0?
• What buil-in routines are used to display editor dynamicaly?
• What is an Lov?
• What is a record Group?
• Give built-in routine related to a record groups?
• List the built-in routines for the controlling canvas views during run-time?
• System.effective_date system variable is read only True/False?
• What are the built_in used to trapping errors in forms 4?
• What is Oracle Financials? (for DBA
• What are the design facilities available in forms 4.0?
• What is the most important module in Oracle Financials? (for DBA
• What are the types of canvas-views?
• What is the MultiOrg and what is it used for? (for DBA
• What is the difference between Fields and FlexFields? (for DBA
• Explain types of Block in forms4.0?
• What is an Alert?
• What are the built-in routines is available in forms 4.0 to create and manipulate a parameter list?
• What is a record Group?
• What is a Navigable item?
• What is a library in Forms 4.0?
• How image_items can be populate to field in forms 4.0?
• What is the content view and stacked view?
• What is a Check Box?
• What is a canvas-view?
• Explain the following file extension related to library?
• Explain the usage of WHERE CURRENT OF clause in cursors ?
• Name the tables where characteristics of Package, procedure and functions are stored ?
• Explain the two type of Cursors ?
• What are two parts of package ?
• What are two virtual tables available during database trigger execution ?
• What is Fine Grained Auditing? (for DBA
• What is a package ? What are the advantages of packages ? What is Pragma EXECPTION_INIT ? Explain the usage ?
• What is Fine Grained Access Control? (for DBA
• What is a Virtual Private Database? (for DBA
• What is Raise_application_error ?
• What is Oracle Label Security? (for DBA
• Give the structure of the procedure ?
• What is OEM (Oracle Enterprise Manager)? (for DBA
• Question What is PL/SQL ?
• What are the components of OEM? (for DBA
• What happens if a procedure that updates a column of table X is called in a database trigger of the same table ?
• Is it possible to use Transaction control Statements such a ROLLBACK or COMMIT in Database Trigger ? Why ?
• How many types of database triggers can be specified on a table ? What are they ?
• What are the modes of parameters that can be passed to a procedure ?
• Where the Pre_defined_exceptions are stored ?
• Write the order of precedence for validation of a column in a table ?
• Give the structure of the function ?
• Explain how procedures and functions are called in a PL/SQL block ?
• What are advantages fo Stored Procedures?
• What is an Exception ? What are types of Exception ?
• What are the PL/SQL Statements used in cursor processing ?
• What are the components of a PL/SQL Block ?
• What is a database trigger ? Name some usages of database trigger ?
• What is a cursor ? Why Cursor is required ?
• What is a cursor for loop ?
• What will happen after commit statement ?
• How packaged procedures and functions are called from the following? a. Stored procedure or anonymous block b. an application program such a PRC *C, PRO* COBOL c. SQL *PLUS??
• What is a stored procedure ?
• What are the components of a PL/SQL block ?
• What is difference between a PROCEDURE & FUNCTION ?
• What is difference between a Cursor declared in a procedure and Cursor declared in a package specification ?
• What are the cursor attributes used in PL/SQL ?
• What are % TYPE and % ROWTYPE ? What are the advantages of using these over datatypes?
• What is difference between % ROWTYPE and TYPE RECORD ?
• What are the different types of PL/SQL program units that can be defined and stored in ORACLE database ?
• What are the advantages of having a Package ?
• What are the uses of Database Trigger ?
• What is a Procedure ?
• What is a Package ?
• What is difference between Procedures and Functions ?
• What is Database Trigger ?
• Can the default values be assigned to actual parameters?
• Can a primary key contain more than one columns?
• What is an UTL_FILE.What are different procedures and functions associated with it?
• What are ORACLE PRECOMPILERS?
• Differentiate between TRUNCATE and DELETE?
• What is difference between a formal and an actual parameter?
• What should be the return type for a cursor variable.Can we use a scalar data type as return type?
• What are different Oracle database objects?
• What is difference between SUBSTR and INSTR?
• Display the number value in Words?
• What is difference between SQL and SQL*PLUS?
• What are various joins used while writing SUBQUERIES?
• What a SELECT FOR UPDATE cursor represent.?
• What are various privileges that a user can grant to another user?
• Display the records between two range?
• minvalue.sql Select the Nth lowest value from a table?
• What is difference between Rename and Alias?
• Difference between an implicit & an explicit cursor.?
• What is a OUTER JOIN?
• What is a cursor?
• What is the purpose of a cluster?
• What is OCI. What are its uses?
• How you open and close a cursor variable.Why it is required?
• Display Odd/ Even number of records?
• What are various constraints used in SQL?
• Can cursor variables be stored in PL/SQL tables.If yes how. If not why?
• Difference between NO DATA FOUND and %NOTFOUND?
• Can you use a commit statement within a database trigger?
• What WHERE CURRENT OF clause does in a cursor?