Search string in oracle forms tutorial

Back to Topic List. Using Regular Expressions in Oracle Database 10g Matching Mechanism. If you have a string aabcd and you specify a search for a(b|c)d, the search looks for a followed by either b or c, which is then followed by d. Hi, Your articule about Oracle Search Text is really nice. I'm implementing a kind of Catalog Search (Item Search) on my eCommerce solution, but I want to support searches with partial information, specially to support searches with Serial Numbers, so web users could type in part of the Serial Number. How do you find code if you don't know which Form it's in. If you know the form you can search pl sql but what if you don't know form? For example I know the name of a field that is used in some code I want to see but don't know where code is at. Oracle EBS Query-by-Example - Query like a Pro. Knowing all of the options when querying in forms will help take users beyond average and toward 'power user' status. Master the use of query wildcards, and query operators as described below. I know this reply is just a little behind the question, but I stumbled upon it when looking for answers to the single quote problem. I saw the new Q-quote that came with 10g, but could find few good examples of how to use it. About site. OracleTutorial.org was created to help you to learn how to use Oracle database, Oracle Forms and Reports, SQL*Plus and PL/SQL language simple and fast. I'm working on forms 10g, i have requirement to develop find form and display results in data block. 1. query form will have 4 parameters and submit button. 2. once parameters are selected and clicked on submit button it should pull data from table A and display data in data block which is based on table B. In Oracle/PLSQL, the instr function returns the location of a sub-string in a string.. If the sub-string is not found, then instr will return 0.. I want to search multiple sub-strings in a string and return the first non-zero value. Introduction Oracle Forms