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 3386

what is ORACLE MEMORY STRUCTURES

3 8869

How to find the SGA Size

Baidu, Reliance,

7 24540

How to find the current session sid

Baidu,

3 9911

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

Oracle,

1 12279

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

2178

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 3519

Un-Answered Questions { Oracle }

Which is better Oracle or MS SQL? Why?

4823

How many types of segments in Oracle?

1012

What is an SQL FORMS ?

2717

What is catalog in Oracle?

1264

What do you mean by oracle database?

528

How to check the server version in oracle?

1032

How to create a new table in oracle?

1065

How to define an anonymous procedure with variables?

1060

What is primefaces used for?

1006

How do I call oracle stored procedures that take no parameters?

1019

6. Display the client name and order date for all orders using the traditional method.

2238

How to export your connection information to a file?

1073

What is an oracle?

956

How to convert csv to table in oracle?

921

Which directory will you copy your new reports, what would be its extension (.rdf or .rex)?

For More Un-Answered { Oracle } Questions Click Here