Answer Posted / chaudhry
Using transactional triggers we can control or
modify the default functionality of the oracle forms
Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
how do u place it in required folder
What is the difference between bind and lexical parameter?
What do you understand by oracle forms and why are they required?
What do you understand by oracle forms?
What is an SQL FORMS ?
Explain master-detail relationship with some examples.
In what sequence do triggers get fired by oracle forms?
What is responsibility and how u attach How to create user and how u attach with responsibility.
in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement
Have you come across the error ?Failed while printing ?. Why it is happened and How to solve that?
i want to print the employee details on department wise with group above report with the fields DEPTNO------group above ENAME ------ SAL-------- COMM------ I WANT OUTPUT LIKE THIS ---------------------------------------------------------- 1)FIRST DEPTNO=10 EMPLOYEES DISPLAYED IN FIRST PAGE AND DEPTNO=20 EMPLOYEES DISPLAYED IN 2ND PAGE WHAT I HAVE TO DO OUTPUT ------- --FIRST_PAGE ----------- DEPTNO:10 ENAME SAL COMM KING 5000 A 2000 2222 ---- =- -- SECONDPAGE DEPTNO:20 ENAME SAL COMM MILLER 220 22 D 45 23 -- - - LIKE THE ABOVE PROCDURE REPORTS HOW MANY DEPARTMENTS ARE EXISITING IN EMP TABLE
What do we mean by record group in oracle forms?
what are bind variables?
difference between global n context sensitive segments?
What is an oracle report? List its various types.