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 3561

what is ORACLE MEMORY STRUCTURES

3 9185

How to find the SGA Size

Baidu, Reliance,

7 25158

How to find the current session sid

Baidu,

3 10198

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

Oracle,

1 12556

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

2289

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 3694

Un-Answered Questions { Oracle }

What causes the "snapshot too old" error? How can this be prevented or mitigated?

554

What are the key components of oracle’s maximum availability architecture?

In what script is snap$ created? In what script is the scott/tiger schema created?

2763

what are the default admin accounts in Oracle 10g ?

1026

What is dual table oracle?

1033

What do you mean by redo log file mirroring?

1071

What is data store? How to create data store?

690

What is execute immediate in oracle?

1080

What is a staging area? Do we need it?

what are the oracle forms services components include?

1086

What is recovery manager(rman) backup in Oracle?

1233

How do I escape a reserved word in oracle?

1264

What is an oracle report?

1124

How to find out what oracle odbc drivers are installed?

1096

How to use "while" statements in oracle?

1381

For More Un-Answered { Oracle } Questions Click Here