Archive for the ‘Oracle Queries’ Category

Difference Between Bitmap and Character Mode Report

April 12th, 2020, posted in Oracle Queries
Share

Here is an example to help explain how Oracle Reports are designed and printed in both the bitmap and character-mode environments.Difference Between Bitmap and Character Mode Report, Occurred In Oracle Reports,Oracle Reports,Oracle,Reports,Difference Between Bitmap and Character Mode Assume you wish to print “Cc” where “C” is a different font and a larger point size than “c” and is in boldface type (where “c” is not). In Oracle Reports Designer, bitmap mode, you can make “C” bold and in a different font and point size than “c”.

This is because you are generating postscript output. Postscript is a universal printer language and any postscript printer is able to interpret your different design instructions. In Oracle Reports Designer, character mode, the APPLICATIONS STANDARDS REQUIRE the report to be designed in ONE FONT/ ONE CHARACTER SIZE. Character mode reports generate ASCII output.

In ASCII you cannot dynamically change the font and character size. The standard is in effect so a report prints as identically as possible from both conventional and postscript printers.

Share

REP-0300: ORACLE Error Occurred In Oracle Reports

March 29th, 2020, posted in Oracle Queries
Share

Imam Dba, Immam Dba, Oracle DBA,

If the below error occurs

REP-0300: ORACLE error occurred.
REP-0069: Internal error
REP-57054: In-process job terminated:Terminated with error: 
REP-300: ORACLE error occurred.

Answer :
Please check the report parameter data types.
It should be correct to overcome the issue.

Share

SQL Functions for Hex to Character and Character to Hex

March 17th, 2020, posted in Oracle Queries
Share
SELECTSQL for Active Banks and Branches in EBS R12,SQL for Active Banks and Branches in Oracle EBS R12,SQL for Active Banks and Branches in Oracle,Oracle Query,Oracle DBA,DBA Query,SQL for Active Bank and Branche in Oracle,
ascii(UTL_I18N.RAW_TO_CHAR ('00', 'AL32UTF8')),
ascii(UTL_I18N.RAW_TO_CHAR ('20', 'AL32UTF8')),
utl_raw.cast_to_raw(' ')
FROM DUAL;
Share

Oracle SQL To Check Instance Clone Date

March 1st, 2020, posted in Oracle Queries
Share

Oracle Database,DBA immam,DBA imam,oracle issues,oracle database,oracle clone issues,oracle clone,oracle autoconfig,oracle autoconfig issues

 

 

 

SELECT resetlogs_time FROM v$database ;

 

 

Share