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, 2776👍, 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, 3902👍, 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, 5162👍, 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, 3187👍, 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, 4159👍, 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, 5771👍, 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, 6001👍, 0💬
What is thread? A thread is an independent path of execution in a system.
What Is Posting? Posting is an event that writes Inserts, Updates and Deletes in the forms to the da...
What are the two fundamental objects in ADO.NET ? Datareader and Dataset are the two fundamental obj...
What is the use of “OverRides” and “Overridable” keywords ? Overridable is used in parent class to ...
How To Assign Query Results to Variables? - Oracle DBA FAQ - Working with Database Objects in PL/SQL...