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


Oracle Interview Questions
Questions Answers Views Company eMail

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

Accenture, TCS,

3 10325

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

2466

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

 2 14710

• What is oracle Architecture?

 3 5300

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 7216

how to hide the scroll bar in forms 6i

 2 12428

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 2700

How can I sum column wise in Oracle excel report?

 1 5009

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

 6 6970

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

 2236

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

 1 3039

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 4091

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

AC, HP,

5 8066

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 4889

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

 1845

Un-Answered Questions { Oracle }

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

622

Which is better Oracle or MS SQL? Why?

3979

if the source have total 15 records with 2 records are updated and 3 records are newly inserted at the target side we have to load the newly changed and inserted records

274

What are the various configuration files that are used by oracle forms?

568

how to implement the logic in procedures if the source side data deleted that will reflect the target side table?

321




How to call a stored function with parameters?

564

Differentiate between post-database commit and post-form commit?

545

What is the Repository and how many types of repository?

276

Explain the dml?

600

What is a recovery catalog?

1

Explain self joins in oracle?

564

What is ELT? Or What is the difference between ODI and other ETL Tools?

310

What exactly do quotation marks around the table name do?

546

What is recycle bin in Oracle?

720

What is flashback in Oracle?

581

For More Un-Answered { Oracle } Questions Click Here