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 8891

How to find the SGA Size

Baidu, Reliance,

7 24589

How to find the current session sid

Baidu,

3 9931

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

Oracle,

1 12307

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

2188

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 3530

Un-Answered Questions { Oracle }

Differentiate between standard remittance and bills receivable remittance : oracle accounts receivable

1101

Explain self joins in oracle?

953

How do I limit the number of rows returned by an oracle query after ordering?

1107

what the 'lov of validation' property of an item? Mention what is the difference between lov and list item?

971

What are object group?

Explain about your project and its relation to the current job position you are applying to?

947

What is the usage of control file in oracle?

1032

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.

548

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

523

When should you increase copy latches? What parameters control copy latches?

534

What is mutated trigger? In single user mode we got mutated error, as a dba how you will resolve it?

523

Which function is used to find the largest integer less than or equal to aspecific value?

527

How to rename an existing table?

1056

How to check database size in Oracle?

1129

If a tablespace shows excessive fragmentation what are some methods to defragment the tablespace? (7.1,7.2 and 7.3 only)

540

For More Un-Answered { Oracle } Questions Click Here