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, 2850👍, 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, 3991👍, 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, 5469👍, 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, 3259👍, 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, 4267👍, 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, 5955👍, 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, 6181👍, 0💬
Can Java object be locked down for exclusive use by a given thread? Yes. You can lock an object by p...
What Happens to Your Transactions When ERROR 1213 Occurred? - MySQL FAQs - Transaction Management: C...
How To Use "IN OUT" Parameter Properly? - Oracle DBA FAQ - Creating Your Own PL/SQL Procedures and F...
How To Assign Debug Privileges to a User? - Oracle DBA FAQ - Introduction to Oracle SQL Developer In...
How To Give a User Read-Only Access to a Database? - MySQL FAQs - Managing User Accounts and Access ...