Oracle Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Hi...... I created a report which is geneated in .txt format. What I do for this is 1.First I change the system parameter mode to character in the report. 2.Then I place a button in my form to call the report. code in the button is as follows.. DECLARE rePid REPORT_OBJECT; rep_hndl VARCHAR2(100); BEGIN rePid := Find_Report_Object('reptxt.rdf'); Set_Report_Object_Property(rePid,Report_deStype,FILE); Set_Report_Object_Property(rePid,Report_FileName,'d:\sasi\reports\reptxt.rdf'); Set_Report_Object_Property(rePid,Report_desName,'d:\sasi\output\repprint.txt'); rep_hndl := Run_Report_Object(rePid); END; and it is working.. Now the problam is that when I preview the report from the report builder, it is in the format I needed. But when I run the form and run the report,Its alligment is not correct. Regards abc

1 3482

what is ORACLE MEMORY STRUCTURES

3 9062

How to find the SGA Size

Baidu, Reliance,

7 24881

How to find the current session sid

Baidu,

3 10079

What is difference b/w Credit memo and Adjustment in AR.

Oracle,

1 12430

hi iam kavya, i completed Oracle11i(finance module), i do not know how to face the interview questions please adivese me

2231

BY SELECT * FROM EMP QUERY ,I GENERATED ONE REPORT.AND SUPPOSE THAT I HAVE 10 PAGES OF OUTPUT. WHAT I WANT IS ,I WANT TOTAL PER EACH PAGE.OK I GOT THAT AND THAT SHOULD BE FORWARDED TO NEXT PAGE AND NEXT PAGES TOTAL SHOULD BE DISPLAYED

1 3621

Un-Answered Questions { Oracle }

Why do you create or replace procedures rather that drop and recreate.

1013

How can we force the database to use the user specified rollback segment?

1152

What command is used to type files to the screen?

599

What are record groups ?

What are a query and state the different types of queries and their uses?

1019

How to turn on or off recycle bin for the session?

1113

What is a lookup table in oracle?

974

How to revoke create session privilege from a user in oracle?

1020

What are the different optimizers that are used to optimize database?

What is a dba certification?

600

How to select an oracle system id (sid)?

1065

What is a select query statement in oracle?

972

What is your favorite tool for day-to-day oracle operation?

548

How to retrieve values from data fields in record variables?

1121

How can windows applications connect to oracle servers?

1059

For More Un-Answered { Oracle } Questions Click Here