Answer Posted / kashif keeriyo

you have to give link of
database =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =ip addrss or name
of the host)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = service name or database name)
)
)
to the tnsnames file inside the admin folder then connect it
will work surely.

what is oracle forms?

601

---

What is the difference between bind and lexical parameter?

543

---

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

600

---

What is a matrix report and how many minimum groups are required to prepare the same?

552

---

What is an oracle report? List its various types.

568

---

---

Explain how can you use the same lov for 2 columns?

643

---

what is tripstop report?

1357

---

how do u compile a form i.e .fmb file in Unix or in dos

4020

---

from where do u receive the information to develop report

1528

---

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

1294

---

how do u place it in required folder

1478

---

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

2466

---

What is an SQL FORMS ?

2312

---

if u want to delete all these detail block etc what will happen in form

1475

---

a text item is there what r the different types of triggers associated with it

1514

---