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 3469

what is ORACLE MEMORY STRUCTURES

3 9045

How to find the SGA Size

Baidu, Reliance,

7 24850

How to find the current session sid

Baidu,

3 10061

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

Oracle,

1 12425

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

2231

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 3619

Un-Answered Questions { Oracle }

Explain a private synonyms?

1036

What are the various tools? - Name a few?

State and explain the different types of data models?

942

How can I learn oracle dba?

563

What are the set operators union, union all, minus & intersect meant to do?

987

How many databases should a dba manage?

654

How do I connect to oracle?

1028

What is a static data dictionary in oracle?

1112

What is oracle update statement with inner join ?

1059

What is a Garbage Collection? and what is full recursive Garbage collection?

2901

How to retrieve data from an cursor to a record?

1102

I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?

1110

What is different type of rman backup?

665

Where does the clusterware write when there is a network or storage issue?

What happens to the data files if a tablespace is dropped?

1059

For More Un-Answered { Oracle } Questions Click Here