Oracle Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle General (1809)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)

Oracle Interview Questions

Questions Answers Views Company eMail

how to find find & delete duplicate rows from two different tables?

3 11789

i want to print the employee details on department wise with group above report with the fields DEPTNO------group above ENAME ------ SAL-------- COMM------ I WANT OUTPUT LIKE THIS ---------------------------------------------------------- 1)FIRST DEPTNO=10 EMPLOYEES DISPLAYED IN FIRST PAGE AND DEPTNO=20 EMPLOYEES DISPLAYED IN 2ND PAGE WHAT I HAVE TO DO OUTPUT ------- --FIRST_PAGE ----------- DEPTNO:10 ENAME SAL COMM KING 5000 A 2000 2222 ---- =- -- SECONDPAGE DEPTNO:20 ENAME SAL COMM MILLER 220 22 D 45 23 -- - - LIKE THE ABOVE PROCDURE REPORTS HOW MANY DEPARTMENTS ARE EXISITING IN EMP TABLE

2986

plz explain when we are using pre-query,post-query,pre-insert and post-insert?plz explain with one example

2 15884

• What is oracle Architecture?

3 6431

You have one employee table having 3 entries emp_id, Mgr_id and salary. Mgr_id is also referencing emp_id. so now find out the emp_id which are having the second highest salary, under a particular manager.

Amazon, HCL,

3 8667

how to hide the scroll bar in forms 6i

2 13467

I'm doing my final year and i ve planned to do an oracle certification , is this the rit tim nd wat's the future scope??

1 3422

How can I sum column wise in Oracle excel report?

1 5813

how to retrieve 1st and last row of table without using group functions??

6 8719

How to Identify the previously inserted/updated records in already populated table.

2727

Which is the cheapest and quality Oracle Education provider in Bangladesh?

1 3690

how can get like this result table A col1 col2 --- ----- a A b B C C .. .. .. ... .. ... wants result like for a single column col1 ------ a,b,c,........n of data and another is col1 ------- A B C D ........ a b b d ........

TCS,

2 5044

without using count(*) and rownum how can we count total record in a table

AC, HP,

5 10135

you are sorting a table using "order by"(descending) clause of a column which contains a null value...whether that row containing null value will come first or last in the output??

BirlaSoft,

2 5847

Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

2257

Un-Answered Questions { Oracle }

How do I manually create a database in oracle?

1014

What is rowid and rownum in oracle?

1007

QUESTION IS THAT DURING UPLOADING DATA IN PROD SERVER,OUR EQUIPMENT TAG NUMBERS ARE NOT MATCHING WITH SAP TAG NUMBERS SO DUE TO THIS WE ARE FACING PROB, BECAUSE WHENEVER ALARM IS COMING FROM SCADA DUE MISMATCH THE NOTIFICATION IS NOT CREATED IT IS GIVING ERROR. PLEASE SUGGEST THE METHOD SO THAT THE TAG NUMBERS OF BOTH (SCADA EQUIPMENT AND SAP EQUIP) SHOULD CONCIDE.OTHERWISE WE HAVE TO GO FOR LONG PROCESS EITHER BY INTERFACE TABLE OR BY EXPORTING ALL DATA AND MAKING RIGHT CHANGES.DO YOU HAVE ANY SHORTCT METHOD PL WRITE ME. THANKS

2064

How to convert a date to char in oracle? Give one example.

1061

What do you mean by dba?

570

Mention where does the clusterware write when there is a network or storage issue?

Query to retrieve record for a many to many relationship ?

2511

Explain the use of owner option in exp command.

1041

> CREATE OR REPLACE FUNCTION FACTORIAL_1(factstr varchar2 ) 2 RETURN NUMBER AS 3 new_str VARCHAR2(4000) := factstr||'*' ; 4 fact number := 1 ; 5 BEGIN 6 7 WHILE new_str IS NOT NULL 8 LOOP 9 fact := fact * TO_NUMBER(SUBSTR(new_str,1,INSTR(new_str,'*')-1)); 10 new_str := substr( new_str,INSTR(new_str,'*')+1); 11 END LOOP; 12 13 RETURN fact; 14 15 END; explanation Above program?

2026

does odi support web services?

558

What is the page protect in reports?

How to define a variable to match a table column data type?

981

Is there any link between pr form(purchse requisition)and po form(purchase order)

2713

Explain the use of indexes option in imp command.

1171

i am pursuing mca and i want to do oracle apps technical in hydrabad, plz guide me tne best institue in hydrabad those have excellent knowledge in oracle apps.

2304

For More Un-Answered { Oracle } Questions Click Here