摘要：
Example is given for Pre-Query and Post-Query triggers in Oracle Forms, with using Display_Itembuilt-in in Post-Query triggers to highlight fields dynamically. This is the screen shot below for this... 阅读全文
posted @ 2016-12-25 19:34
全威儒
阅读(2060)
评论(0)
推荐(0)
摘要：
Suppose you want to check the user permissions on inserting or updating the records in Oracle Forms, then you can use Pre-Insert and Pre-Update triggers for that particular data block to check whether... 阅读全文
posted @ 2016-12-25 19:21
全威儒
阅读(254)
评论(0)
推荐(0)
摘要：
This is one of my most needed tool to create Insert and Update statements using select or alias from different tables where column mapping is difficult. What this utility actually does is, suppose y... 阅读全文
posted @ 2016-12-25 19:18
全威儒
阅读(288)
评论(0)
推荐(0)
摘要：
Example is given below to fetch any Oracle objects DDL script using DBMS_Metadata.Get_DDL command in Oracle Forms using Forms_DDL command. You can download this form for free including source code w... 阅读全文
posted @ 2016-12-25 19:15
全威儒
阅读(433)
评论(0)
推荐(0)
摘要：
Sequence of triggers fires on Commit.1. KEY Commit2. Pre Commit3. Pre/On/Post Delete4. Pre/On/Post Update5. Pre/On/Post Insert6. On commit7. Post Database CommitSequence of triggers fires when ... 阅读全文
posted @ 2016-12-25 19:11
全威儒
阅读(359)
评论(0)
推荐(0)
摘要：
Whenever we commit after entering data in Oracle Forms, many triggers fires during this event and also Pre-Update and Pre-Insert triggers fires just before inserting or updating the record into table.... 阅读全文
posted @ 2016-12-25 19:09
全威儒
阅读(274)
评论(0)
推荐(0)
摘要：
Play_sound is used to play audio files in Oracle Forms, Play_Sound plays the sound object in the specified sound item.PLAY_SOUND examplesThe following plsql block you can write in when-button-pressed ... 阅读全文
posted @ 2016-12-25 19:07
全威儒
阅读(407)
评论(0)
推荐(0)
摘要：
Get_File_Name is built-in function of Oracle Forms 6i, used to get the file name with address by browsing the file. You can browse a specific extension name file or with multiple extensions using wild... 阅读全文
posted @ 2016-12-25 19:05
全威儒
阅读(846)
评论(0)
推荐(0)
摘要：
These errors occurred usually due to forms connection problem or some internal problem, the solution is, close the form, re-connect to the database and then re-open the form.FRM-10001: Internal Error:... 阅读全文
posted @ 2016-12-25 19:04
全威儒
阅读(249)
评论(0)
推荐(0)
摘要：
Displays the standard open file dialog box where the user can select an existing file or specify a new file.SyntaxFUNCTION GET_FILE_NAME(directory_name VARCHAR2,file_name VARCHAR2,file_filter VARCHAR2... 阅读全文
posted @ 2016-12-25 19:03
全威儒
阅读(695)
评论(0)
推荐(0)
浙公网安备 33010602011771号