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 22105

What is different bet native dynamic sql and Dbms_Sql?

Thermotech,

4 15133

What is TNS File

Thermotech,

7 29907

What is flashback Query ? And Use ?

Thermotech,

4 8064

What is Trace File ?

Thermotech,

4 24410

What is forall Statement ?

Thermotech,

2 5219

Tell me New Feature of Oracle 10g?

Thermotech,

5 9768

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 6180

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 2964

what is ORACLE MEMORY STRUCTURES

 3 7950

How to find the SGA Size

Baidu, Reliance,

7 23097

How to find the current session sid

Baidu,

3 9098

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

Oracle,

1 11112

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

 1873

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 3131

Un-Answered Questions { Oracle }

How to shutdown your 10g xe server from command line?

651

What happens when the default and temp tablespace clauses are left out from create user statements?

365

What is the usage of synonyms?

690

What happens to the current transaction if the session is killed?

627

Why do you use stored procedures and state some of its disadvantages?

667




What are the Types of Scd's?

368

Explain how can you use the same lov for 2 columns?

729

List out the difference between commit, rollback, and savepoint?

716

Describe an oracle table?

668

What happens if variable names collide with table/column names?

689

What is the load balancing advisory?

1

i want to know about the javaBean.what is its purpose and how it can use in Forms.

1930

Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable

1385

What is an external table?

664

Compare and contrast between sql and sql server and explain its various functions?

636

For More Un-Answered { Oracle } Questions Click Here