1. Categories >> Software >> Databases >> Oracle
  2. Suggest New Category


Oracle Interview Questions
Questions Answers Views Company eMail

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

KH, Thermotech,

3 21808

What is different bet native dynamic sql and Dbms_Sql?

Thermotech,

4 14796

What is TNS File

Thermotech,

7 29259

What is flashback Query ? And Use ?

Thermotech,

4 7756

What is Trace File ?

Thermotech,

4 23953

What is forall Statement ?

Thermotech,

2 4948

Tell me New Feature of Oracle 10g?

Thermotech,

5 9393

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 5843

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 2792

what is ORACLE MEMORY STRUCTURES

 3 7704

How to find the SGA Size

Baidu, Reliance,

7 22585

How to find the current session sid

Baidu,

3 8829

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

Oracle,

1 10785

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

 1759

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 2991

Un-Answered Questions { Oracle }

Mention what are the tools provided in oracle enterprise manager?

1

What are record groups ?

1

What are functions of dba?

288

What is format trigger?

1610

How to make the project as .exe file in oracle forms & reports(d2k)?

1




Can we insert data in view oracle?

526

How to delete a column in an existing table?

582

How to define an anonymous procedure without variables?

541

How to use "in" parameter properly?

608

What is the difference between translate and replace?

544

What do you mean by merge in oracle?

587

When do you get a .pll extension in oracle? Explain its importance

566

You have installed oracle and you are now setting up the actual instance. You have been waiting an hour for the initialization script to finish, what should you check first to determine if there is a problem?

273

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

4005

What do we mean by hot backup & cold backup and how are they different?

1

For More Un-Answered { Oracle } Questions Click Here