Search results for query: *

Hi Himanshu: Thank you for the help? How to check the no data returned by a query group object? Thanks! Ke

Hi I am working on a Oracle 6i report. The final report looks like: ==================================================== Sample Oracle Report Org ID: 1 Org Name: MUS Org ID: 2 Org Name: MFG ==================================================== The report layout looks like: Org ID...

Hi HimanB: This report is showing the information for a component in different sub-inventory location. The quantity column means the total quantity for a component in all possible sub-inventory. Since a component could have multiple sub-inventory, the information about the same component could...

Hi All: I am creating a SQL*PLUS (not Oracle report) report. The code segment liks following: ============================================== set newpage 0 set pagesize 55 BREAK ON component desc quantity select ..... from .... // ignore the actual syntax...

Hi All: I am creating a SQL*PLUS (not Oracle report) report. The code segment liks following: ============================================== set newpage 0 set pagesize 55 BREAK ON component desc quantity select ..... from .... =============================================== When I run...

Hi Nagornyi: can you explain more? I am still confused....Sorry, I am a junior oracle report developer. Do you means I should create a format trigger for the repeat frame which contains all the columns in my report? For my report, it breaks on component and sequence; even though you saw a...

I haven't tried it yet.. Will let you guys know when I test it out. Thanks!

I am using Oracle 6i. Here is an example of output of my report: Component Seq SubInv Quantity ========= === ====== ======== 018-1071 10 test1 10 test2 20 <=== blank line test3 30...

I am using Report6i, in the layout model, I created two lines as following (each line consists of a text object and field object): supply subinventory1 : F_supply_sub1 supply subinventory2 : F_supply_sub2 Also, I group each line (text + field)into a frame. When I printed out it, there are...

Thanks a lot!

Does anyone knows any good online documents for tips/demo/example for using report 6i?

Hi Nagornyi: The report will be invoked through a concurrent request submitted by user in Oracle 11i app. So, there is no way to reset the value of COPIES system parameter? Thanks!

Hi: I am modified an Oracle report using report 6i. I need figure out how to dynamic print out multiple copies for the same report based on the value of a column retreived from a table in the database. Can I do this in Oracle report 6i? Can I dynmaically reset the value for "Copies" system...

You can also run the following one line of PL/SQL to get the explanation of a SQL error: exec dbms_output.put_line('==> '||sqlerrm( &errno ) ); DEV> exec dbms_output.put_line('==> '||sqlerrm( &errno ) ); Enter value for errno: 100 old 1: begin dbms_output.put_line('==> '||sqlerrm( &errno )...

Hi All: What is the command line that 1) Launch the Oracle Report Builder6i on Unix box (e.g. HPUX) 2) run the Oracle report 6i from command line on Unix box. Where can I find the document for Oracle report builder 6i on unix box where Oracle 9i is installed. Thanks!

I think I figure it out by myself: select * from v$parameter where name = 'optimizer_mode' /

Hi sem: Thanks a lot!

Hi All: Is there a way to list all Oracle V$ virtual tables? Thanks!

Hi All: We can use alter session command to change a lot of session information (e.g. ALTER SESSION SET OPTIMIZER_MODE = RULE). My question is how to find all session information? What command can tell me the value for OPTIMIZER_MODE of my current session? Thanks!

To see all nls related parameter for your instance, you can: DEV> l 1 select 2 parameter 3 , value param_value 4 from nls_session_parameters 5* DEV> / PARAMETER PARAM_VALUE ------------------------------ ----------------------------------------...