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, 2868👍, 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, 4026👍, 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, 5559👍, 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, 3288👍, 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, 4306👍, 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, 6003👍, 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, 6221👍, 0💬
What are the core functionalities in XML .NET framework? Can you explain in detail those functionali...
How To Set Background to Transparent or Non-transparent? - CSS Tutorials - HTML Formatting Model: Bl...
How To Merge Values of Two Arrays into a Single Array? - PHP Script Tips - PHP Built-in Functions fo...
What Are Named Parameters? - Oracle DBA FAQ - Creating Your Own PL/SQL Procedures and Functions Name...
What are urlencode() and urldecode() functions in PHP? string urlencode(str) - Returns the URL encod...