Answer Posted / suresh.somayajula

integrity means which doesn't allow duplication of files.

we have 3 types of integrity rules.

1. Entity Integrity Rule : In this Primary key can't

be null.

2. Referential Integrity : It tells the relation

between the Master Table and Child table.

3. Business Rule Integrity.

Thanks,

suresh_somayajula@hotmail.com

I need a query to list out "Subinventory Transfer" record from Oct 2016 to Oct 2017 for few users

1250

---

Can we invoke one form from another in a multi-forms application?

1173

---

What is responsibility and how u attach How to create user and how u attach with responsibility.

2091

---

suppose u have been seven tables based on that u have to create a report u don't have access to db. then how do u find the relation between tables

2060

---

Is it possible to execute a dynamic sql from forms?

1114

---

did u p prepared complex report

2048

---

In what sequence do triggers get fired by oracle forms?

1017

---

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

2185

---

What is an oracle report?

1119

---

How do u print the data horizantally by using XML report? EX:Suppose there is one table names as SAMPLE in that we have only two columns say empno,ename.I want the output like this,At run time user may enter 3 colums(i.e to data print horizantally). empno ename empno ename empno ename 100 aaa 101 bbb 102 ccc 103 ddd 104 eee 105 fff

2290

---

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

1216

---

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

3046

---

Explain the various types of oracle report?

1131

---

How to create Drill down report?

2185

---

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

1944

---