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 24816

How to find the current session sid

Baidu,

3 10050

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

2227

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 data block in Oracle?

1110

Users are not being allowed on the system. The following message is received: ora-00257 archiver is stuck. Connect internal only, until freed. What is the problem?

604

How to change user password in oracle?

1021

while creating requisitions i am unable to see the list of organisation can anyone help me out ?

2131

Can we call procedure inside function in oracle?

1075

what is dynamic SGA and static SGA

4408

Can we protect our pl/sql source code?

1038

How many types of database triggers exist?

1125

What is the simplest tool to run commands on oracle servers?

1002

What is save point in oracle database?

1289

Who is a database user?

538

Explain joins in oracle?

1028

Why more redos are generated when the oracle database is in begin backup mode?

1116

How to write a query with a right outer join in oracle?

1156

If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?

2289

For More Un-Answered { Oracle } Questions Click Here