What is syntax for dropping a procedure and a function? Are these operations possible?
What is syntax for dropping a procedure and a function? Are these operations possible? Drop Procedure/Function ; yes, if they are standalone procedures or functions. If they are a part of a package then one have to remove it from the package definition and body and recompile the package. 2011-09-27, 2836👍, 0💬
How can I read/write OS Files from Forms?
How can I read/write OS Files from Forms? OS files can be read/written from Forms using the TEXT_IO package in Forms. The TEXT_IO package has a datatype FILE_HANDLE. It also has procedures FCLOSE, GET_LINE, NEW_LINE, PUT, PUT_LINE & PUTF and a function FOPEN. Example: DECLARE file1 TEXT_IO.FILE_TYPE... 2011-05-03, 3972👍, 0💬
Can one change the mouse pointer in Forms?
Can one change the mouse pointer in Forms? The SET_APPLICATION_PROPERTY build-in in Oracle Forms allows one to change the mouse pointer. Example: SET_APPLICATION_PROPERTY(CURSO R_STYLE,BUSY); The following cursor styles are supported: * BUSY - Specifies a busy symbol * CROSSHAIR - Specifies a crossh... 2011-04-19, 5373👍, 0💬
Forms won't allow me to use restricted built-in's. What should I do?
Forms won't allow me to use restricted built-in's. What should I do? How to get around the "can't use a restricted built-in in built-in XXX" message: 1. Create a TIMER at the point where you want the navigation to occur. Eg. create_timer('TIMER_X', 5, NO_REPEAT); 2. Code a WHEN-TIMER-EXPIRED trigger... 2011-04-12, 3238👍, 0💬
What is Oracle Forms and what is it used for?
What is Oracle Forms and what is it used for? Oracle Forms is a 4GL Rapid Application Development (RAD) environment. Forms Builder is used to create applications to enter, access, change, or delete data from Oracle (and other) databases. The Forms Runtime environment is required to execute compiled ... 2011-03-15, 4239👍, 0💬
What are database triggers?
What are database triggers? How are the triggers fired? Read this collection of questions and answers on SQL Server triggers: A collection of 20 FAQs on creating and managing triggers. Clear explanations and tutorial exercises are provided on creating DML and DDL triggers; altering, dropping, enabli... 2008-08-12, 5881👍, 0💬
DBMS questions with answers
it will be very helpful if you send some important Questions with Answers of DBMS Tell us what types of DBMS questions you are interested in. We will send you what we have collected so far. 2008-08-12, 6134👍, 0💬
Can you explain duplex contracts in WCF? In duplex contracts when client initiates an operation the ...
Which bit wise operator is suitable for turning off a particular bit in a number? The bitwise AND op...
Can one change the mouse pointer in Forms? The SET_APPLICATION_PROPERTY build-in in Oracle Forms all...
What is page thrashing? Some operating systems (such as UNIX or Windows in enhanced mode) use virtua...
If XML does not have closing tag will it work? No, every tag in XML which is opened should have a cl...