GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Tech FAQs  >  Oracle
Go To First  |  Previous Question  |  Next Question 
 Oracle  |  Question 28 of 244    Print  
what is report customization? what are the triggers used ?

  
Total Answers and Comments: 2 Last Update: October 24, 2007     Asked by: megh 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
July 14, 2006 11:40:05   #1  
Harsha        

RE: what is report customization? what are the trigger...

Report Customization means taking the orginal oracle report and modifing ( changing layout query- by adding some more field....) according the user requirement.

There are 5 types of report triggers

1)Before parameter form
2)After parameter form
3)Before Report
4)Between Pages
5)After Report

They are executed in above sequence; i.e if you want to assign some value or execute dynamic query(we modify query at run time based on input parameters) we right After parameter form or Before Report and any deletion is done at after report.


 
Is this answer useful? Yes | No
October 24, 2007 04:55:00   #2  
shravanam Member Since: August 2007   Contribution: 22    

RE: what is report customization? what are the trigger...

what harsha said is right.
in addition to the above reports there are 3 more triggers
1. VALIDATION TRIGGERS
2.FORMAT TRIGGERS
3.ACTION TRIGGERS


 
Is this answer useful? Yes | No

 Related Questions

I have got the following error when importing few of my package bodies and triggers. ORA-01653: unable to extend table SYS.IDL_UB1$ by 13 in tablespace SYSTEM The tablespace SYSTEM had enough space at the time of import. Later when I tried to create theses objects seperately through a script, they were successfully created. It is important to note that not all package bodies and triggers failed. If you have any idea regarding this error, please let me know the problem and solution, if possible.

Can we set the parameter, so that a particular report gets printed in the particular printer only ?
Read Answers (1) | Asked by : ramesh

I used oracle8i and report 6i. I want to print character mode report pagewise. e.g. in report there is 20 pages and I want to print out only 5 to 12 pages. How does it possible..? our application is web based so that we used apache as server and orarrp.exe for printing utility. Please give me answer about it as soon as possible. it's urgent.
View Question | Asked by : mehulmb

Latest Answer : what harsha said is right.in addition to the above reports there are 3 more triggers1. VALIDATION TRIGGERS2.FORMAT TRIGGERS3.ACTION TRIGGERS ...
Read Answers (2) | Asked by : megh

Latest Answer : How can I call a report from a from in d2k? ...
Read Answers (1) | Asked by : Chandra Kishor Ravi

Latest Answer : there are many tips!1) inside a cursor never  perform an other sql or call a function performing an sql, join that table better to the cursor body.2) perform bulk operations3) avoid in (subselect) better join this table to the master select4) avoid ...

Hi, Here we are using Reports 6i, how to get report output format in ppt or doc,is there direct print option instead of generating it into pdf or rtf.pls let me know and give me the proper example
View Question | Asked by : jayaram

Latest Answer : Hi,If a Form Item's property needs to be changed, then it should be done from a form trigger and not a database trigger. You can use Visual Attributes or Property Classes to achieve this or a form trigger. Depending on your criteria, you can use form ...

Hi, We are on Oracle Apps 11.5.8Database 9.2.0.6 We want Report outputs in excel. Is there anyway we can get the same. Sajani Pillai
Read Answers (1) | Asked by : Sajani

Latest Answer : Yes we can use procedure in trigger...but not trigger in Procedure.ThanksAmol Bawane ...
Read Answers (2) | Asked by : suguna


 Sponsored Links

 
Related Articles

Querying Data with Oracle XQuery

Querying Data with Oracle XQuery Starting with Oracle Database 10g Release 2 you can take advantage of a full featured native XQuery engine integrated with the database With Oracle XQuery you can accomplish various tasks involved in developing PHP Oracle XML applications operating on any kind of dat
 

Using Oracle XML DB Repository

Using Oracle XML DB Repository Another variation on accessing and manipulating XML content stored in Oracle database is provided by Oracle XML DB repository which is an essential component of Oracle XML DB mosgoogle NOTE Oracle XML DB repository also known as XML repository is a hierarchically organ
 

Using Oracle Database for Storing, Modifying, and Retrieving XML Data

Using Oracle Database for Storing Modifying and Retrieving XML Data With Oracle XML DB you have various XML storage and XML processing options allowing you to achieve the required level of performance and scalability One of the most interesting things about Oracle XML DB is that it allows you to per
 

XML Processing in PHP and Oracle Applications

Processing XML in PHP Oracle Applications As mentioned there are two alternatives when it comes to performing XML processing in your PHP Oracle application You can perform any required XML processing using either PHP s XML extensions or PEAR XML packages or Oracle s XML features mosgoogle In the fol
 

PHP Oracle Web Development

PHP Oracle Web Development Data processing Security Caching XML Web Services and Ajax The book is written by Yuli Vaseliev a well known author of different web development and programming books PHP Oracle Web Development Data processing Security Caching XML Web Services and Ajax is a good starting b
 

Getting Started with Oracle and ODP.NET

ODP NET Developer’ s Guide by Jagadish Chatarji Pulakhandam Sunitha Paruchuri A practical guide for developers working with the Oracle Data Provider for NET and the Oracle Developer Tools for Visual Studio 2005 Application development with ODP NET Dealing with XML DB using ODP NET Oracle
 

PHP Oracle Web Development Review

PHP Oracle Web Development Data processing Security Caching XML Web Services and Ajax The book is written by Yuli Vaseliev a well known author of different web development and programming books The author is also an expert in open source technologies and SOA Service Oriented Architecture But besides
 

Step by Step Oracle PL-SQL Tutorial

This introductory tutorial to PL SQL will help you to understand the basic concepts of PL SQL Please review the following tutorials and practice the sample SQL Statements on your local Oracle Database Please note that you must learn these basic things before we actually start getting in to Advanced
 

Working with XML in Oracle

Working with XML in Oracle Introduction to XML Extensive markup language is the language which presents data in a human readable form of text The data can be anything from a purchase order or a stock quote or weather radar or a flight schedule it can be represented using XML XML is very similar to H
 

What are the differences between stored procedures and triggers?

Stored procedures are compiled collection of programs or SQL statements that live in the database. A stored procedure can access and modify data present in many tables. Also a stored procedure is not associated with any particular database object. But triggers are event-driven special procedures whi
 

About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape