Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / rupesh babu k
This is used to run DDL or DML commands in forms.
In reports srw.do_sql
In pl/sql execute immediate and dbms_sql
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
i am writing a query select EmpNo from Emp how can i call in after parameter form
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
Why oracle forms required?
I have a frame that contains headings. This frame is enclosed in side a repeating frame. However the headings are not displayed on all pages it is displayed only on the last page. Please let me know why is this happening. print object on = All pages base printing on = enclosing object
What are the various configuration files that are used by oracle forms?
if some data is not transfered where it will get stored
In workflow how can we send a notification to the Supplier giving the Corresponding report Details.
How can we generate report output in excel format?
How can we expand Parameter Form Canvas on Reports 6i?
how to use buttons,check boxes in paper layout,paper design and paper parameter form in oracle report developer 10g
What are the Features of Forms 6i over 4.5? What are the Features of Forms 10g? What are the Features of Reports 6i? What are the Features of Reports 10g ?
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
What is the difference between BPA AND Contract What are documents and test cases u followed
difference between global n context sensitive segments?
Name the different triggers supported by oracle reports and their firing order.
