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

0 Answers  

---

what the 'lov of validation' property of an item? Mention what is the difference between lov and list item?

0 Answers  

---

what is procedure like symbols of bind and lexical

1 Answers  

---

if i want to change the functionality of a item in report during runtime how like what do u write in when_button_pressed

0 Answers  

---

What is the difference between $$DATE$$ & $$DBDATE$$

1 Answers  

---

How can a text file be attached to a report while creating in the report writer?

1 Answers  

---

List some built-in routines used to manipulate images in image_item?

1 Answers  

---

What are the different types of Delete details we can establish in Master-Details?

1 Answers  

---

What is the difference between an ON-VALIDATE-FIELD trigger and a trigger ?

2 Answers  

---

Can a field be used in a report wihtout it appearing in any data group?

1 Answers  

---

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

0 Answers  

---

When will ON-VALIDATE-FIELD trigger executed ?

1 Answers  

---