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, 2966👍, 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, 4134👍, 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, 5816👍, 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, 3397👍, 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, 4426👍, 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, 6147👍, 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, 6393👍, 0💬
If locking is not implemented what issues can occur? IFollowing are the problems that occur if you d...
An application needs to load a library before it starts to run, how to code? One option is to use a ...
Explain in detail the fundamental of connection pooling? When a connection is opened first time a co...
What is difference between custom JSP tags and JavaBeans? Custom JSP tag is a tag you defined. You d...
What are the two fundamental objects in ADO.NET ? Datareader and Dataset are the two fundamental obj...