-
-
-
What is the difference between Property Pallete and Visual Attributes ?Also explain what is Object Group in Oracle Forms ?
santhisistla
- Jul 29th, 2010
Property pallete is used to apply changes to only that object item, as visual attributes are used in more generic manner. Visual attributes are used in the projects in which common specific...
kyuvarajbe
- Jun 11th, 2010
Visual Attribute is the property in Property Pallete of object which deals with only text font,colour.
-
-
If the same trigger is present in Form, Block and Item level, normally the item level will fire first. How to change this default one. That is I want to fire the block level or form level. How to do this?
imranbaig.geek
- Mar 25th, 2010
If same trigger is fired at form block, item item gets executed first then block then form. To change the process, change the trigger property execution hierarchy to "after" from "overridden".RegardsImran Baig
dj_dj_dj
- Jul 1st, 2009
No Idea ?If anybody know it kindly let me also know the right answer.RegardsDharmendra JaiswalCMS.
-
What are the types of TRIGGERS ?
1. Navigational Triggers. 2. Transaction Triggers.
kishor s pawar
- Mar 17th, 2008
Pre triggers,post triggers,when trigger,transactional trigger,validation triggers,key triggerskishor
anilkln
- Feb 21st, 2008
actually there r 3 levels of triggers1)formlevel 2)block level 3) item leveland types of triggers r1 activex triggers2 block processing triggers3 interface event triggers4 key triggers5mas...
-
What is a Trigger ?
A piece of logic that is executed at or triggered by a SQL *forms event.
Bashartullakhan
- Aug 17th, 2011
Triggers are a special PL/SQL construct similar to procedures. However, a procedure is executed explicitly from another block via a procedure call, while a trigger is executed implicitly whenever the triggering event happens. The triggering event is either a INSERT, DELETE, or UPDATE command.
manishagoyal23
- Sep 4th, 2009
A forms trigger is a block of PL/SQL code that adds functionality to your application. Triggers are attached to objects in your application. When a trigger is fired, it executes the code it contai...
-
How to find out duplicate records ?
swetashashi
- Feb 10th, 2010
SELECT emp_name,count(emp_name) AS cntFROM employeeGROUP BY emp_nameWHERE cnt>1
vara
- Nov 18th, 2007
Select * from emp a where rowid >(select min(rowid) from emp b where a.empno = b.empno)
-
Can a sigle canvas be used by different blocks ?
-
-
What are the triggers associated with master detail relationships ?
Ziaullah
- Jul 18th, 2008
NON-ISOLATED (default) a) on check delete masterb) on clear detailsc) on populate details ISOLATEDa) on clear detailsb) on populate detailsCASCADE a) per-deleteb) on clear detailsc) on populate details
Neethi
- Jan 17th, 2007
* Non-Isolated (default)On-Check delete MasterOn Populate DetailsOn Clear Details*IsolatedOn Clear DetailsOn Populate Details*CascadePer-DeleteOn Clear detailsOn Populate Details
-
What are the different types of key triggers ?
Function Key Key-function Key-others Key-startup
-
Give the Types of modules in a form?
Form Menu Library
sunil
- Jul 20th, 2015
Types of modules are:
Menu module
PL/SQL Libraries
Object Library -
What are the different types of windows?
Root window, secondary window.
g_sidhu
- Feb 13th, 2008
There are two styles of windows in Forms: document and dialog. Document windows are commonly used for data entry and query screens; they are the main windows in an application. Dialog windows are used...
-
What are the types of canvas-views?
Content View, Stacked View.
manish
- Sep 17th, 2006
Conetent View(Default)Stack View(Only create on content canvas only)Tab ViewToolbar View(Vertical/Horizontal)--Always try to connect it with window for many forms in one application.
-
-
Hi,what is place holder column?where we can use other than formula column?
sumanpani
- Sep 16th, 2008
A placeholder is a column for which you set the datatype and value in PL/SQL that you define. You can set the value of a placeholder column in the following places: n the Before Report Trig...
rampratap409
- Dec 6th, 2006
Place holder column is the name of variable which can hold a calculated value like ( sum, avg..) or the value can be set by function or by a pl/sql block.use of place holder column for aggrigate function is not advised, for that use summary column.
-
How to get number in words in Oracle 10g Reports
How to get number in words we are using Oracle 10g software and in reports, i am trying to give as function code and return value as placeholder, but i am getting an error as foll.REP:1401 'cf_1formula': Fatal PL/SQL error occurred.Thanks in advanceKrishnan R
Ashish
- Mar 10th, 2014
"vb Function No_To_Word(Amount Number) Return Varchar2 Is Wordsamt Number(30, 12) := 0; Words Varchar2(500) := ; Str Varchar2(50) := ; Amt Number(30, 1...
asifinet
- Feb 16th, 2013
"sql Set Serveroutput On 1000000 Declare V_Input NUMBER := &TESTED; Function Numbertowords(P_Number In Out Number) Return Varchar2 Is V_Words Varchar2(32767) := ; V_Te...
-
Message error
How can I get off a error message oracle form A0001 ask me to save the record when I change a record to other ?
-
While specifying master/detail relationship between two blocks specifying the join condition is a must ? True or False. ?
True.
Thileepan
- Jun 12th, 2007
False. It is not a MUST.Using PL/SQL ref cursors we can maintain data retrieval conditions for master / detail blocks. Also we can handle join conditions at run time too.
Oracle Forms Interview Questions
Ans