Customized Titles in Oracle
Posted by: Edi Yanto on: April 18, 2007
We can create a header and a footer to display customized titles at the top and bottom of each page in the report output using the TTITLE and BTITLE commands.
Query for display the employees who work in SALES department and hire date year is 1981.
After type the command to display the title 1981 Employees at the top and Sales Department at the bottom of each page.
Leave a Reply
RSS Syndication
Edi Yanto
Oracle Applications Technical Consultant
My Certifications
- Edi Yanto: Hi Ang, You can find the solution for this problem at http://www.ediyanto.co.cc/unable-to-view-excel-output-xml-publisher-from-concurrent-program-req
- ang: xml view output to excel ORA-01403: no data found -------------------------------------------------------------- FRM-40735: WHEN-BUTTON-PRESSED
- Edi Yanto: Hi Ricky, Have you try to set the security setting (Enable Automatic prompting for file download) for your internet/local/trusted sites zone at inter
Edi Yanto (何万新)
- Oracle Top-N Query October 2, 2009Using RANK function, with a faster execution plan (WINDOW SORT PUSHED RANK) SELECT Empno, Ename, Job, Mgr, Hiredate, Sal FROM (SELECT Empno, Ename, Job, Mgr, Hiredate, Sal, RANK() OVER (ORDER BY SAL Desc) AS Emp_Rank FROM Emp) WHERE Emp_RankEdi Yanto
- Bersyukurlah… June 30, 2009AKU TAK SELALU MENDAPATKAN APA YANG KUSUKAI oleh karena itu AKU SELALU MENYUKAI APAPUN YANG AKU DAPATKAN. Kata-kata di atas merupakan wujud syukur. Syukur merupakan kualitas hati yang terpenting. Dengan bersyukur kita akan senantiasa diliputi rasa damai, tentram dan bahagia. Sebaliknya, perasaan tak bersyukur akan senantiasa membebani kita. Kita akan selalu […]Edi Yanto
- Cinta Sejati June 30, 2009Kenapa kita menutup mata ketika kita tidur ? Kenapa kita menutup mata ketika kita menangis ? Kenapa kita menutup mata ketika kita membayangkan sesuatu ? Kenapa kita menutup mata ketika kita berciuman ? Hal hal yang terindah di dunia ini biasanya tidak terlihat Ada hal hal yang tidak ingin kita lepaskan dan ada orang orang yang tidak ingin kita tinggalkan Tap […]Edi Yanto
- Nice Story June 8, 2009Share on FacebookEdi Yanto
- 5 Tips Agar Tak Mudah Lelah June 2, 2009Sebagian orang mengeluhkan kondisi tubuhnya yang cepat capai atau lelah. Kebanyakan orang menilai hal itu diakibatkan kerja ekstra. Tetapi, sebenarnya hal itu dilatarbelakangi kebiasaan seseorang sehari-hari. Berikut lima tips yang dikutip VIVAnews dari WebMD, Sabtu 25 April 2009 agar kondisi tubuh Anda tidak mudah capai atau lelah. 1. Lapar atau tidak, sara […]Edi Yanto
- Belajar dari Alphabet May 29, 2009A : AcceptTerimalah diri anda sebagaimana adanya. B : BelievePercayalah terhadap kemampuan anda untuk meraih apa yang anda inginkan dalam hidup. C : CarePedulilah pada kemampuan anda meraih apa yang anda inginkan dalam hidup. D : DirectArahkan pikiran pada hal-hal positif yang meningkatkan kepercayaan diri. E : EarnTerimalah penghargaan yang diberi orang lai […]Edi Yanto
- How To Get the List of All Responsibilities Assigned To A User May 29, 2009 Edi Yanto
- Query To Find Multi-Org Is Enabled Or Not May 29, 2009SELECT DECODE (multi_org_flag, ‘Y’, ‘Multi-Org Enabled’, ‘Multi-Org Disabled’ ) FROM fnd_product_groups; Share on FacebookEdi Yanto
- How To Find A Patch Is Applied For A Bug May 29, 2009 Edi Yanto
- Excel Limitations on Images in Oracle Apps May 23, 2009The Excel output can’t showing the image (even after you save and send to another person or open it at different notebook), but it is showing only small red color empty cross written ‘An Image’. Why??? As many of you know or have noticed, our Excel output for all flavors of BIP/XMLP is not true binary [...]Edi Yanto
Blogs.oracle.com Recent Posts (all languages)
- Four New Sample Applications
- Jan / Feb 2010 FRAMEWORKS Column on Task Flow Routing
- Pergunte-me, no formspring.me
- 「3PL Study 2009」 （４）全体調和 - 新時代
- Happy holiday! Thanks for a making the SOA Partner Community a superb success in 2009!
- Carol à la 2.0
- Profit Online's Top 10 of '09
- Simplify Application Grid Deployments with Assemblies
- Oracle Database 11g Release 2 (11.2.0.1.0) for AIX (PPC64) is available
- Merry Christmas and a Happy New Year
Online Apps DBA
- Install Oracle AIA 2.2 with Agile PLM (9.2) PIP (Process Integration Pack)
- Oracle Apps R12 distributed / Multi-node Installation : Unix/Windows
- ODI - Data Quality : Metabase Manager
- OPA / OPM (Haleys Office Rules) version 10 now available
- opatch requires response file for Oracle Configuration Manager (OCM) : One-off patch installation failed during configuration
Visitors
Users Online
Recent Comments