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 3463

what is ORACLE MEMORY STRUCTURES

3 9020

How to find the SGA Size

Baidu, Reliance,

7 24815

How to find the current session sid

Baidu,

3 10049

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

Oracle,

1 12411

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

2226

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 3606

Un-Answered Questions { Oracle }

What is the string concatenation operator in oracle?

1168

Point out the difference between user tables and data dictionary?

976

Explain prerequisites and post activities of oracle database installation

2123

What is an index associated with a constraint?

1028

Explain oracle left join with an example?

1003

You have taken a manual backup of a datafile using os. How rman will know about it?

548

Explain the types of exception?

1139

You have taken import of a table in a database. You have got the integrity constraint violation error. How you are going to resolve it.

580

How do you bind variables in oracle?

976

Explain about the analyze command in oracle?

1043

How is it different from a normal table?

1023

Explain coalesce function?

1196

Explain the use of inctype option in exp command.

1024

What is control file used for?

1193

How to update a table row with a record?

1006

For More Un-Answered { Oracle } Questions Click Here