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 3396

what is ORACLE MEMORY STRUCTURES

3 8894

How to find the SGA Size

Baidu, Reliance,

7 24595

How to find the current session sid

Baidu,

3 9933

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

Oracle,

1 12315

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

2191

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 3532

Un-Answered Questions { Oracle }

When using oracle export/import what character set concerns might come up? How do you handle them?

544

What is the purpose of the import option ignore? What is its default setting?

562

What is the relation of a user account and a schema?

1070

What are the Features of Forms 6i over 4.5? What are the Features of Forms 10g? What are the Features of Reports 6i? What are the Features of Reports 10g ?

4562

What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.

1065

What are the types of Knowledge Modules?

547

What database block size should I use?

674

What does >> do?

546

What is the full form of dba?

557

What is an oracle transaction?

1066

Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.

2289

how do u compile a form i.e .fmb file in Unix or in dos

4518

Explain the use of control file?

1068

What is oracle latest version?

1044

Why do we use bulk collect in oracle?

1019

For More Un-Answered { Oracle } Questions Click Here