How to find Oracle forms that use a column in Solaris ?
I am trying to find all the oracle forms that have text item invoice_id in Solaris ( SunOS 5.10)
If I use
Code:
grep -i -l 'invoice_id' *
I get only those oracle forms that have 'invoice_id' in the PL/SQL code.
I want to find all the oracle forms that use invoice_id column in their datablocks.
Please let me know how can I find those oracle forms ?
If you try to edit (vi or vim) any one of the forms you will see why grep does not work.
Oracle forms files have munged characters in them. I do not know of a tool to unscramble those characters.
Need your support for below. Please help to get required output
If column 5 is INV then only consider column1 and take out duplicates/identical rows/values from column1 and then put minimum value of column6 in column7 and put maximum value in column 8 and then need to do subtract values of... (7 Replies)
I have a file like:
I would like to find lines lines with duplicate values in column 1, and retain only one based on two conditions: 1) keep line with highest value in column 3, 2) if column 3 values are equal, retain the line with the highest value in column 4.
Desired output:
I was able to... (3 Replies)
I use a forms application where I develop the forms(Oracle 6i) in windows server and compile(Oracle 9i) the same in Unix server.
The whole forms application executables are placed in Unix.
My requirement is to upload data from excel sheet to oracle tables using Oracle forms. I have developed the... (0 Replies)
Hi. How do I find an expression with awk in only one column, and if it fits, then print that whole column.
1 apple oranges
2 bannanas pears
3 cats dogs
4 hesaid shesaid
echo "which number:"
read NUMBER (user inputs number 2 for this example)
awk " /$NUMBER/ {field to search is field... (2 Replies)
I am using the command: f60gen to complie a form and it says it does not work
Pls help, as I am trying to compile a few .fmb files to fmx...
Cheers (1 Reply)
