摘要：
Obtaining Query Count Without executing a Query in Oracle D2k Obtaining a count of records that will be retrieved by EXECUTE_QUERY before actually performing it in a database block is especially usefu... 阅读全文
posted @ 2016-12-25 22:30
全威儒
阅读(453)
评论(0)
推荐(0)
摘要：
Using Call_Form in Oracle D2kCALL_FORM examples/* Example 1:** Call a form in query-only mode.*/BEGINCALL_FORM(’empbrowser’, no_hide, no_replace, query_only);END;/* Example 2:** Call a form, pass a pa... 阅读全文
posted @ 2016-12-25 22:28
全威儒
阅读(349)
评论(0)
推荐(0)
摘要：
Upload Files To FTP in Oracle Forms D2k Use following procedure to upload files to Ftp. PROCEDURE Ftp_Upload IS outfile text_io.file_type;BEGIN -- write a ftp script outfile := text_io.fope... 阅读全文
posted @ 2016-12-25 22:27
全威儒
阅读(501)
评论(0)
推荐(0)
摘要：
Using GET_APPLICATION_PROPERTY in Oracle D2k FormsDescriptionReturns information about the current Form Builder application. You must call the built-in once for eachvalue you want to retrieve.Usage No... 阅读全文
posted @ 2016-12-25 22:26
全威儒
阅读(638)
评论(0)
推荐(0)
摘要：
A very nice ebook on building reports in Oracle fusion middleware 11g. This manual is intended for anyone who uses Oracle Reports to build reports. The needs of both novice and advanced users are addr... 阅读全文
posted @ 2016-12-25 21:55
全威儒
阅读(556)
评论(0)
推荐(0)
摘要：
A step by step tutorial for Oracle Forms 10g development. This guide is helpful for freshers in Oracle forms 10g. To download this ebook click the below button: Download Oracle Forms 10g eBookSee Also... 阅读全文
posted @ 2016-12-25 21:48
全威儒
阅读(1147)
评论(0)
推荐(0)
摘要：
To download Oracle Forms Developer 6i from Oracle click this link http://download.oracle.com/otn/nt/forms/6i_rel2_xp.zipNote. You must have Oracle username and password to download any software from ... 阅读全文
posted @ 2016-12-25 21:41
全威儒
阅读(1168)
评论(0)
推荐(0)
摘要：
Convert numbers to Indian Rupees format in Oracle Forms / Reports.Create the below mention function in Oracle Forms / Reports and call it with passing a number parameter.FUNCTION INR_words( p_number I... 阅读全文
posted @ 2016-12-25 21:39
全威儒
阅读(268)
评论(0)
推荐(0)
摘要：
Below is the example plsql unit to validate login credentials and after successful validation open a new form by passing some parameters to it, in Oracle forms 10g.Create a form for custom login. Crea... 阅读全文
posted @ 2016-12-25 21:38
全威儒
阅读(426)
评论(0)
推荐(0)
摘要：
Below is the example to write file on client in Oracle Forms 10g with webutil library package.Note: Webutil library must be attached to the form.DECLAREv_dir VARCHAR2(250) := 'c:\temp';ft_tempfile CL... 阅读全文
posted @ 2016-12-25 21:36
全威儒
阅读(547)
评论(0)
推荐(0)
摘要：
Center window automatically in Oracle Forms 6i, use the following procedure by passing window name as parameter:ExamplePROCEDURE auto_centre (pwn in varchar2) ISvw number := get_window_property(forms... 阅读全文
posted @ 2016-12-25 21:34
全威儒
阅读(421)
评论(0)
推荐(0)
摘要：
Add combo list / drop down list item element at runtime in Oracle forms.SyntaxPROCEDURE ADD_LIST_ELEMENT(list_name VARCHAR2,list_index, NUMBERlist_label VARCHAR2,list_value NUMBER);ExampleDeclare nEl... 阅读全文
posted @ 2016-12-25 21:32
全威儒
阅读(988)
评论(0)
推荐(0)
摘要：
The below plsql program unit could be used in a WHEN-NEW-FORM-INSTANCE trigger to initially populate the hierarchical tree with data in Oracle forms.DECLAREhtree ITEM;v_ignore NUMBER;rg_emps RECORDGRO... 阅读全文
posted @ 2016-12-25 21:30
全威儒
阅读(438)
评论(0)
推荐(0)
摘要：
You want to connect multiple databases in oracle forms to perform certain tasks, for example you need to execute ddl or dml statements against databases but when you try to use dblink it gives you err... 阅读全文
posted @ 2016-12-25 21:29
全威儒
阅读(472)
评论(0)
推荐(0)
摘要：
When called from an On-Fetch trigger, initiates the default Form Builder processing for fetching recordsthat have been identified by SELECT processing.FETCH_RECORDS examples/*** Built-in: FETCH_RECORD... 阅读全文
posted @ 2016-12-25 21:27
全威儒
阅读(516)
评论(0)
推荐(0)
摘要：
Suppose you want to scan a tabular grid block (loop through all records in detail block) from top to bottom in Oracle forms. You can do this task by using :system.last_record system variable to determ... 阅读全文
posted @ 2016-12-25 21:23
全威儒
阅读(264)
评论(0)
推荐(0)
摘要：
SYSTEM.CURSOR_BLOCK Determining current block in Oracle Forms Using SYSTEM.CURSOR_BLOCK system variable. The value that the SYSTEM.CURSOR_BLOCK system variable represents depends on the current navig... 阅读全文
posted @ 2016-12-25 21:21
全威儒
阅读(1447)
评论(0)
推荐(0)
摘要：
I shared a data entry example form here in this post for Oracle Forms beginner developers, so that they may take an idea to how to develop a simple data entry form in Oracle Forms. The form can be ful... 阅读全文
posted @ 2016-12-25 21:19
全威儒
阅读(390)
评论(0)
推荐(0)
摘要：
A user-named trigger is a trigger defined in a form by the developer. User-Named triggers do not automatically fire in response to a Form Builder event, and must be called explicitly from other trigge... 阅读全文
posted @ 2016-12-25 21:17
全威儒
阅读(190)
评论(0)
推荐(0)
摘要：
Suppose you want to give the data backup option in Oracle Forms application to some client users, where you have installed Oracle 11g client or direct from server.The following procedure executes a ba... 阅读全文
posted @ 2016-12-25 21:15
全威儒
阅读(213)
评论(0)
推荐(0)
浙公网安备 33010602011771号