<div>
I thought you already had the Oracle Forms format mask working from a previous question. &nbsp;<br />
<br />
The trigger code is also in a previous question.<br />
<br />
What isn't working now?
</div>


I thought you already had the Oracle Forms format mask working from a previous question.  

The trigger code is also in a previous question.

What isn't working now?

<div>
What kind of &quot;form&quot; is this? &nbsp;Is this Oracle Forms? &nbsp;If yes, which version?
</div>


What kind of "form" is this?  Is this Oracle Forms?  If yes, which version?

<div>
<div class="content wysiwyg-content">
format value when navigating<br />
<br />
<br />
hi i have the following value<br />
<br />
7877-12-145-7845<br />
<br />
in database i have the following<br />
<br />
empid empjobid empacc empref <br />
001 &nbsp; &nbsp; 7877 &nbsp; &nbsp;12 &nbsp; &nbsp; &nbsp;1457845<br />
<br />
<br />
<br />

<pre><code id="code-10-29008928-1">select * from employee
where empjobid = substr(:block.item,1,2)
and   empacc   = substr(:block.item,7,7)</code></pre>
<br />
<br />
now the user in form enter value like this<br />
<br />
<br />
emmaccount<br />
121457845<br />
<br />
but when user navigate out of fieild i what value to be formated as<br />
7877-12-14-7845
</div>
</div>


format value when navigating


hi i have the following value

7877-12-145-7845

in database i have the following

empid empjobid empacc empref 
001     7877    12      1457845



(CODE)


now the user in form enter value like this


emmaccount
121457845

but when user navigate out of fieild i what value to be formated as
7877-12-14-7845

mask value when navigating

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.