Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...



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,

1636

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

Gap Inc,

1 2711

how to write customizations in po

Ernst Young,

1567

how to handle exceptions in post production

1367

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

1506

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?

1334

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.

1381

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

1173

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

FIS,

1382

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,

1298

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

Accenture,

1742

how to hide the stored procedure inside a package

1 2020

Are These Dff's Flexible?

Oracle,

1127

What Are Cross Validation & Adi?

Oracle,

1102

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,

1049


Un-Answered Questions { Oracle }

What is an SQL FORMS ?

2732


How to connect the oracle server as sysdba?

1023


What is mrc and what is its use? : oracle accounts receivable

1117


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.

1381


What is index-organized table in Oracle?

1025


How can you determine if an oracle instance is up from the operating system level?

523


How to add another datafile to a tablespace?

998


How to clone the database using RMAN back

2154


What is call form stack?

1


What are triggers in oracle?

981


How to create a new tablespace in oracle?

939


What are different types of transactions in ar? : oracle accounts receivable

1231


How does one get the view definition of fixed views/tables?

974


How do you find current date and time in oracle?

994


What is an oracle function?

1089