-
What are the different objects in oracle
samareshp
- Apr 1st, 2009
Synonym,
Table,
View,
Trigger,
Materialized Views,
Indexes,
Sequence
LOB
Package
Package Body
Function
Procedure
Type
ttparavindh
- Aug 7th, 2007
The following Objects are in OracleSequenceLOBPackagePackage BodyTriggerIndexTableSynonymFunctionViewProcedureType
-
How to see the select statement when we issue execute_query
bc_sumanamara
- Jan 12th, 2009
BY USING :SYSTEM.LAST_QUERY;EXAMPLE WHEN-NEW-FORM-INSTANCEBEGIN execute_query;MESSAGE(:SYSTEM,LAST_RECORD);END;RUN THE FORM...
-
What is the use of decode function?
samareshp
- Apr 9th, 2009
Decode(col1,value1,x, value2,y, value3,z, value4,a, Q)it serves as if.else condition ....if col1=value1 then x,elsif col1=value2 then y,elsif col1=value3 then z,elsif col1=value4 then y else Q......
Raghu2008
- Aug 6th, 2008
The decode function is used to read the value from the given column and check 'if' the given column value and given if value is same then return the value other wise return the else value. Like this i...
-
Pre Query & Post Query
How many times pre query and post query fired when we fetch 10 record from a table ?
samareshp
- Apr 9th, 2009
Pre Query 1 Time - Before Query Post Query n Time ( n Times for n number of records fetch by this query)
-
How do you repeat the same values to the next record from the previous record to reduce the user entry in d2k forms 4.5.
pchandna
- Jul 22nd, 2009
Use COPY & NAME_IN BUILT-IN at with the help of System.cursor.record when-New-record-Instance trigger to copy and paset value from previous to next record
najim_t
- Sep 23rd, 2007
Hi Press F3 from on copy one filed. press F4 . it will create same next recordN.TanwirsevenseasgroupDubai
-
Oracle Forms Progress bar
How can i implement progress bar in form 6i.
srivnn
- Oct 24th, 2009
We can incorporate the Progress Bar(Status Bar) in the D2K(Forms) as below.1. Create static Canvas with Small Size & Place the Control item (text item) with colour or Visual attribute assign to th...
-
What is key.next.item trigger?
zahid92005
- Feb 23rd, 2010
This trigger fires forces the cursor to be taken to the next available item or data block.
Venkata Ramana
- Sep 14th, 2006
Key-Next-item trigger will fire whenver the user try to move the control(i.e., cursor) from one item to another item in the form by pressing return key or tab key.
-
What are use of DDE package in D2K
imranbaig.geek
- Mar 23rd, 2010
Oracle Forms for Microsoft Windows supports Dynamic Data Exchange(DDE), a mechanism by which applications can communicate and exchange data. DDE client support is a procedural extension to Oracle Form...
ajay2222@gmail.com
- Dec 21st, 2006
Sir can you tell me any sites name where i can getproject in D2Kajay singh
-
What is the return type for oracle apps report trigger
sameeridol21
- Jul 21st, 2010
The return type for Oracle Apps report trigger is Boolean ie TRUE Or FALSE
Mital Mehta
- Sep 27th, 2007
That Will be Boolean like True or false
-
What is the business reason for using triggers and what sequence they get fired when control transfer from one text item to next text item ?
sameeridol21
- Jul 21st, 2010
A trigger is PL/SQL function which will fire whenever a corresponding event occures. The sequence of the triggers as follows1> When-validate-item2> Post-text-item 3>Key-Next-Item4>when-new-item-instance.
Raghu2008
- Aug 6th, 2008
A trigger is PL/SQL block which will fire whenever a corresponding event occures. The sequence of the triggers are Key-Next-Item, When_validate_item, Post_item and when-new-item-instance.Thanks,Rahgu.
-
If there are 1 to 10 records, how many times between pages trigger will fire?If there are 1 to 2 records? and how many times it will fire from 10th to 1st record?
sameeridol21
- Jul 21st, 2010
Irrespective of number of records, between pages trigger will fire n-1 times.According to the Q -if it has 10 pages (1 record/page) then it will fire 9 times.If it has 5 pages (2 record/page) then it will fire 4 times.It will not fire from 10th to 1st record because it fires for 1st navigation.
Chandra K. Ravi
- Sep 6th, 2007
Mittal,? You are wrong.? Page between trigger ?Fire only 4 times. If there is? 5 pages in a report.C.K.Ravi3i-infotech
-
Which property is used to define the relative position of one field with another
sameeridol21
- Jul 21st, 2010
The property used to define the relative position of one field with another is Anchor
osden
- Oct 7th, 2007
In properties -> Record -> Distance Between Records (Default value is 0).
-
Which property has to be used to fill the columns created_by, updated_by etc in the table when the user uses the customized form to enter the data in the table?
kundancertain
- Jan 25th, 2011
By using FND_STANDARD.SET_WHO in PRE_INSERT and PRE_UPDATE trigger, 5 who columns can be populated. But this work in Oracle Application form customization.
nagendrap
- Jan 10th, 2011
In pre-insert trigger by using 'fnd_standard.who' package?we can insert data into these two columns in Oracle forms.
-
What are features of 4.5,6i,9i differencekindly list them
manishks86
- Jul 25th, 2011
In 1992, Oracle version 7 was released with support for integrity constraints, stored procedures and triggers. In 1997, Oracle version 8 was released with support for object-oriented development a...
anilreddy02
- Aug 17th, 2010
In 6i -> Report6i program units, layout modules, anchors, conflex and flex modes, frames and repeated frames.
-
How to convert a report into excel sheet
parash_3380
- Oct 19th, 2011
Hi Mr. Subrat, very good but when i set system parameters as destype=file and desformat=spreadsheet it is just showing on browser that "Successfully run" and nothing where as if i give destype=c...
subrat
- Oct 13th, 2011
Set system parameters
destype=file
and
desformat=spreadsheet
(100% tested) and secure -
What triggers are activated when master detailed relationship established?
saleem
- Nov 21st, 2011
1) On-Check-Delete-Master Fires when Oracle Forms attempts to delete a record in a block that is Master block in a master-detail relation 2)On-Clear-Details Fires when Oracle Forms needs to clear rec...
shahnirav86
- Jul 2nd, 2008
1) Which trigger are created when master -detail rela?1) master delete property * NON-ISOLATED (default) a) on check delete masterb) on clear detailsc) on populate details *...
-
Can you maintain and manupulate 2 oracle 10g database in a single stand alone machine. If so How and how can you access both the database objects.
abhishek
- Nov 30th, 2011
We can install two instance of oracle on a stand alone machine in two different directories and distinguish them by there different home names as orcl1,orcl2 we can work with both instances........
muraligrandhi
- Dec 2nd, 2010
Yes, we can maintain two oracle databses in a single machine.For this we need to install two Operating systems in your machine, one is Windows and another one is Unix.After you that you should install the databases in the two Operating systems.
-
On-Error Trigger
If you write NULL in on-error trigger defined in Form level of Forms 10g, then what will happen to the error message during runtime? Will the error message get displayed or not?
-
Open Form Example
Give an example for open_form with parameter passing from one form to another form?
-
Scroll bar on tab pages
Can we add scroll bar at on all tab pages in a single canvas? If yes then how:
D2K Interview Questions
Ans