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


Oracle Interview Questions
Questions Answers Views Company eMail

src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));

IBM,

1291

how to retrieve data from different tables ,place this data in different excel worksheets.

Gap Inc,

1 2175

how to write customizations in po

Ernst Young,

1291

how to handle exceptions in post production

 1048

How to get maxsal , minsal, ename department wise in single query

 1139

Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?

 1040

HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.

 1087

I need a query to list out "Subinventory Transfer" record from Oct 2016 to Oct 2017 for few users

 924

Can you tell me how to add new column in existing views?how?How is possible?

FIS,

1022

Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.

Infosys,

947

difference of using cursor for loop and open,fetch,close.which one is better

Accenture,

1349

how to hide the stored procedure inside a package

 1 1392

Are These Dff's Flexible?

Oracle,

832

What Are Cross Validation & Adi?

Oracle,

790

I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?

Oracle,

711

Un-Answered Questions { Oracle }

What are the functions of administration?

347

What is a user role in oracle?

705

What are the types of Knowledge Modules?

350

What is the parameter mode that can be passed to a procedure?

667

Which dictionary tables and/or views would you look at to diagnose a locking issue?

1571




What do you understand by lov?

662

How do I use os authentication with weblogic jdriver for oracle and connection pools?

671

Oracle

1945

Explain the use of indexes option in exp command.

675

How to select an oracle system id (sid)?

668

How do I limit the number of oracle database connections generated by weblogic server?

654

How do we create privileges in oracle?

671

How to rollback the current transaction in oracle?

639

Describe the types of sub query?

643

Which data loaded are in target db?

358

For More Un-Answered { Oracle } Questions Click Here