Oracle Interview Questions
Questions Answers Views Company eMail

Explain 1st, 2nd, 3rd normalization form of data base

KH, Thermotech,

3 22345

What is different bet native dynamic sql and Dbms_Sql?

Thermotech,

4 15509

What is TNS File

Thermotech,

7 30406

What is flashback Query ? And Use ?

Thermotech,

4 8384

What is Trace File ?

Thermotech,

4 24944

What is forall Statement ?

Thermotech,

2 5423

Tell me New Feature of Oracle 10g?

Thermotech,

5 10084

Table Has C1 And C2 Column If Exits any record in c1 then Update c2 record Otherwise insert new record in the C1 And C2 (Using Procedure)

Thermotech,

4 6456

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 3091

what is ORACLE MEMORY STRUCTURES

3 8216

How to find the SGA Size

Baidu, Reliance,

7 23565

How to find the current session sid

Baidu,

3 9339

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

Oracle,

1 11521

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

1977

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 3286


Un-Answered Questions { Oracle }

What is proxy method?

709


What are internal user account in oracle?

735


What is key preserved table?

730


I am Bsc Computer Science Graduate, I have good knowledge in SQL 7.0, Can I go for Oracle APPS course please suggest me the answer

2020


Explain how to convert a report into excel sheet.

1


What file will give you oracle instance status information? Where is it located?

394


How is rman better than user-managed backup recovery process?

1


What is the difference between flex mode and confined mode?

715


What is the sequence of firing in form level trigger?

1


how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?

1720


How to create a stored function in oracle?

821


I need a Technical evaluation between Oracle and SAP ? please do a need ful.

1693


please send me oracle pl/sql exp resume. and also faqs...

2260


What are the ways tablespaces can be managed and how do they differ?

1902


 What are the oracle DML commands possible through an update strategy?

789