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 3475

what is ORACLE MEMORY STRUCTURES

3 9049

How to find the SGA Size

Baidu, Reliance,

7 24854

How to find the current session sid

Baidu,

3 10063

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 oracle’s system global area (sga).

1139

How to turn on or off recycle bin for the instance?

1083

What is blob datatype?

1128

what is meant by magic query

2186

Explain the various types of oracle report?

1075

WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?

2209

A scenario for amount correction & how to use amount correction functionality in AP invoices

2134

Why does Oracle not permit the use of PCTUSED with indexes?

2424

can we implement package in package?

582

What is tkprof?

What happens if a tablespace clause is left off of a primary key constraint clause?

581

Differentiate between pre-select and pre-query?

1106

How can I introduce multiple conditions in like operator?

989

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1933

How to open a cursor variable?

1035

For More Un-Answered { Oracle } Questions Click Here