Answer Posted / sant

sql loader wil run through DOS prompt,please find below
syntax for the same:

sqlldr <username>/<password>@<schemaname> control = XXX.ctl
DIRECT=FALSE

all steps of bitmap report?

2347

---

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

1981

---

how report can be generated if we have the database designed in oracle 10g?

1879

---

What is an SQL FORMS ?

2783

---

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

2986

---

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

2119

---

what are bind variables?

1083

---

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

2128

---

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

1203

---

Is it possible to execute a dynamic sql from forms?

1066

---

What is the difference between BPA AND Contract What are documents and test cases u followed

2375

---

Name the different triggers supported by oracle reports and their firing order.

1073

---

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

1677

---

can you convert or reverse engineer a fmx back to a fmb file?

1156

---

what is a package n what r the packages availbla in report

2088

---