Oracle PLSQL and D2K Interview Questions. 1. What is NOCOPY? By default the IN parameter is passed by reference and the OUT and IN. D2K – 77 D2K interview questions and answers by expert members with experience in D2K subject. Discuss each question in detail for better understanding. Oracle d2k interview questions Oracle d2k interview questions. Overview · Version History · pkraju. Oracle forms interview questions and answers.
|Published (Last):||12 March 2004|
|PDF File Size:||17.52 Mb|
|ePub File Size:||5.6 Mb|
|Price:||Free* [*Free Regsitration Required]|
Key next item trigger fires when we move next item key board events such like tab or enterit ill not fire when we click mouse to another item.
Database Block can be based on more than one table. Query data source name: The advantage of joining tables in your block is that the result set is faster than t What is the advantage of using Program units procedure over database procedure? What scenarios do we use questiohs units procedure over database procedures? Forms program units are local to form builder if quwstions want to use without database you can use form program units else use database procedure.
Program unit procedures can be used when forms ibterview fields, data blocks needs to be accessed. Otherwise it is better to use database procedures. I am using Oracle forms. I want abswers know how to determine which tab the user is on in run time. I created 4 tabs in my canvas A,B,C,D. During run time, how do I get to know that which TAB is qquestions by the user currently? You can change the page size dynamically at main section page go to object navigator and click paper layout and then 3 objectives can be populated you have to click the main section two time then property inspector layout can be populated there you can change the width.
You can develop the queries by using report builder as 1. Is It possible to use or develop grid answerss oracle d2k? Drag and drop one item on ibterview canvas and set its block “no of records displayed” property to more than 1 then the block should look like a grid. How to create the stacked canvas In that you need to have two different canvases in one form.
First canvas should show only semesters wi The stacked canvas is extention wnswers contant canvas which can be display or hide dynamically. The main advantage of stacked canvas is to extend the size of the content cavas.? To understand better plea Some time OCX controls are also available to communicate with devices. Member Since Dec Dec 29th, If the number of records returned by cursor is more, it results in a performance issue.
Oracle D2K Interview Questions & Answers
It is advised to use collections in this case. Bind variables are used for replacing the single parameter in the select statement, where as Lexical Parameter is used to replace the where, order by conditions at run time.
By using lexical parameters we can send only one parameter value by using bind parameters we can send more then one parameter value. If still couldnt see the scroll bar, just look at the x and y coordination of the scroll bar. Change the values of hose two according to the size of the window. You will see the scroll bar on the canvas. You can add whatever scroll bar to your form.
Normally we add scroll bars to the data block.
Therefore no matter whether the canvas is content or stack or tab one. Simply you can add a scroll bar to y 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? Dear All, Basically when we write null on on error then at that time, no error will display.
Dec 08 Sep 02 Sandeep Aug 23rd, Database Block can be based on more than one table.
Jul 25 Sandeep Aug 23rd, Program unit procedures can be used when forms items fields, data blocks needs to be accessed. Jan 19 Oct 20 Sep 10 How do you dynamically change the page size of D2k Reports? Ravi D2K Interview Questions. Hancock Jun 15th, You can change the page size dynamically at main section page go to object navigator and click paper layout and then 3 objectives can be populated you have to click the main section two time then property inspector layout can be populated there you can change the width.
Oct 16 Hancock Jun 15th, You can develop the queries by using report builder as 1. Apr 25 How to create grid in oracle d2k? Sandeep Aug 23rd, Drag and drop one item on your canvas and set its block “no of records displayed” property to more than 1 then the block should look like a grid.
Oracle PLSQL and D2K Interview Questions | Home
Aug 17 Abhishek D2K Interview Questions. May 28 Azhar Hussain Apr 27th, 1. Sep 05 Jun 13 Illustrate a scenario where post change and pre-change trigger get fired? Aug 14 May 15 What are the disadvantages of cursors in oracle?
Report Triggers :-
Pradeep Sep 23rd, If the number of records returned by cursor is more, it results in a performance issue. Difference between flex,lexical and bind variable sanju D2K Interview Questions. Feb 13 With Example zahir Sep 11th, Questionss we cannot change system variable. This is the status of the system. This is not the value. Dec 20 Can we add scroll bar at on all tab pages in a single canvas?
If yes then how: Udara Oct 18th, If still couldnt see the scroll bar, just look at the x and y coordination of the scroll bar. Udara Oct 17th, You can add whatever scroll bar to your form. Jan 12 Feb 07 Nithin Jul 24th, Nothing Happens Showing Questions 1 – 20 of 77 Questions. It looks like you are using an AD Blocker!