Answer Posted / ravi

CALL_FORM, NEW_FORM or OPEN_FORM

Explain master-detail relationship with some examples.

1014

---

i am writing a query select EmpNo from Emp how can i call in after parameter form

2129

---

what are the new features introduced in oracle form services in 11g release 2?

1039

---

Explain how one can iterate through items and records in a specified block?

1150

---

Can any one send me oracle form and reports tutorials from which i may get help.contact me on my mail cse_kashif@hotmail.com.

2237

---

Why oracle forms required?

1046

---

did u received a single file or multiple files

2025

---

what exactly u write in when_new_form_instance

3455

---

Name the different triggers associated with oracle forms having a master-detail relationship.

1005

---

What is an SQL FORMS ?

2799

---

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

2990

---

what are bind variables?

1095

---

Have you come across the error ?Failed while printing ?. Why it is happened and How to solve that?

1992

---

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

2142

---

What is the difference between bind and lexical parameter?

1084

---